Use Power Apps AI Builder to extract data from invoices and store them in SharePoint

The invoice processing prebuilt AI model extracts key invoice data to help automate the processing of invoices. The invoice processing model is optimized to recognize common invoice elements like invoice ID, invoice date, amount due, and more. This reduces the time and effort spent on preparing and fine-tuning custom models for document processing.

• Next, we check if the confidence score for the Invoice total value property is less than 0.65.
• However, by using the AI ​​Builder feature, we will be able to improve the efficiency of this process and therefore the productivity of our employees.
• Next, we check if the confidence score for the detected collection is less than 0.65.
• Finally, we save the extracted data from the invoice into an Excel file.
• Then use this code to determine if the manual review fields text string is empty.
• Now, we need to specify the invoice information which you want to extract from the documents.

Step 2: Use the Form Processing Model in Power Automate Flow

Use this code in the left-side of the logical comparison to target the Score field of the array. Then add the SharePoint – Get File Content action to Interior Design Bookkeeping the flow and target the Invoice PDF using the File Identifier. Download a copy of the sample invoice to follow along with this tutorial. At this point in the example, we’re ready to embed and use the model within a Power Apps app or within a Power Automate flow.

flow-invoice-processing.md

Now, we need to specify the invoice information which you want to extract from the documents. Add the following fields which we created in the invoice list. AI Builder is a new core component of Power Platform that allows us to use Artificial Intelligence to improve business performance ai invoice processing by easily automating the business processes and predict outcomes. It is a low code/no-code solution which means pretty much like most of Power Platform components, you don’t need any coding skills to develop AI models using AI builder.

Create a custom invoice processing solution

There you can now publish the model and use it in Power Apps or Power Automate. ✅ Boost productivity and efficiency by intuitively allowing users to design complex workflows without requiring advanced technical skills. You can also use this formula to retrieve the first item from the result and extract the description of that what are retained earnings item as a text string. For best results, provide one clear photo or high-quality scan per document. To get the best results, provide one clear photo or scan per invoice.

• We are in the process of trying this out for a customer with Austrian invoices – but this is still a challenge.
• Create a SharePoint – Update File Properties action populate its fields as shown below.
• In this example, we’ve trained a custom document processing model to extract a loyalty program number, only present in invoices from providers Adatum and Contoso.
• Next, we check if the vendor for the invoice that has been processed is either from Adatum or Contoso.
• Add an AI Builder – Extract Information From Invoices action and load the File Content into the Invoice File field.
• We are all familiar with situations in which we or a third person spend part of their time processing data from one medium to another or from one information system to another.

In this example, we’ve trained a custom document processing model to extract a loyalty program number, only present in invoices from providers Adatum and Contoso. Now that we have the invoice’s file content we can use AI Builder’s pre-built invoices model to extract its details. Pre-built models do not require any training before using them in a flow.

• After the training you will be immediately redirected to the overview page.
• When our model has finished its training, AI Builder will show us the accuracy of its prediction.
• That is, users can implement the capabilities of such models without having to write code.
• Object detection models can be very useful in automating processes like checking for faults in objects, streamline inventory management and categorizing objects based on their images.
• If you want to see all the values that were extracted from your invoice, click on the action Extract information from invoices from the successful flow run.
• In some articles on Microsoft Flow we have already showed you that a lot of problems can be solved with Power Automate.