How to automate Azure Document Intelligence model

Question

Hi MS Team,

I have a custom invoice extraction model on Azure Document Intelligence Studio with the invoices being held in azure blob storage.

Goal: To extract information from invoices using the model and automatically upload results to an Excel table in SharePoint (i.e. create a central location for invoice data)

Question: How would I go about achieving this?

• Would it be better to create this model in Power Platform so I can automate the process using Automate?
• Is there perhaps a way to connect my document intelligence model to power automate?

I am also aware of Azure Functions as a potential solution but require a little more information/guidance on how to use it for my given scenario.

Thank you for your assistance :)

Answer 1

Hi Krishil Amin

For the above problem statement, you can leverage a combination of Azure services, Power Platform, and Create, and Ensure that your custom invoice extraction model is trained and deployed in Azure Document Intelligence Studio. and store the invoices in your blob storage

now Use Power Automate to create a workflow that triggers when a new invoice is added to the Azure Blob Storage.

Use the "Azure Document Intelligence for Forms" connector in Power Automate to call your custom model and extract information from the invoice.

Parse the extracted information obtained, Prepare the data in a format suitable for uploading to an Excel table in SharePoint.

Use Power Automate to update the Excel table in SharePoint with the extracted invoice information.

You can use the "Update a row" action in the "Excel Online (Business)" connector to add data to the Excel table in SharePoint.

Kindly go through the below links for more info

Azure Blob Storage Documentation

Power Automate Documentation

SharePoint Documentation

Kindly accept the answer if this helped, thanks much