This instruction will guide you through the steps to extract data from CVs uploaded to your SharePoint using Power Automate. By following these steps, you can automate the process and eliminate manual work.
Video Instruction
Step 1. Create a Trigger in Power Automate
Set up a trigger that initiates the extraction process when a file is created in SharePoint.
Provide the complete URL of your SharePoint site and the library name where the invoices are stored.
Also Read: How to extract data from CV to Notion
Step 2: Use the "Get File Content using Path"
Retrieve the file content information using the file path from the previous step.
Step 3: Extract data from resumes with Bitskout
Add a new step and search for Bitskout in the list of connectors. In the list of available actions, choose Extract Data from CV(resumes).
In the file_url field write a small expression, "base64( <FILE CONTENT>)", to extract data from the invoice using Bitskout. You need to select the variable from the previous step in Dynamic Content and add it to the brackets.
The final setup will look like this.
Step 4: Setup Excel
Add the next action called "Add a row into a table" from MS Excel. Map the extracted data directly into Excel.
By following these four steps, you can fully automate the extraction of invoice data to any desired tool.