Power Platform Community Forum Thread Details

Hey Guys

i am a newbie to Power Apps and i was wondering if it can offer a business solution

Each week different units in my organisation produce several reports in PDF files formats they in paralel share the excel files that was used to produce those reports.

In the process of data validation and because it is time consuming, as a team we are thinking of an app solution that could validate the data with the figures in the report using maybe text recongniation to compare the quantitative outcomes (figures) on the PDF files with the results on the Excel files.

is AI Builder a possible solution ?

Thank you

Categories:

AI Builder

Hi @SarahFe ,

If you want to set-up a process that compares data extracted from the PDF and Data coming from an Excel file, the best thing you can do is using a Power Automate flow. You can create a flow that reads the data from the PDF using an AI Builder action and compare with the extracted data from your Excel file.

Which AI Builder model to use?

If you need to get specific information within a document, the best things to do is to use the AI Builder document processing model. You will need to create and train a custom model, but it's quite easy: Overview of document processing model - AI Builder | Microsoft Learn

Then you can see how to use this model in Power Automate: Use the document processing model in Power Automate - AI Builder | Microsoft Learn

How to extract data from an Excel file?

This can be done only if you have an actual table object in your Excel document. Then you can use the action "List rows present in a table".

Once you have both PDF and Excel information, you can compare them using conditions in your Power Automate flow.

Hope that helps!