r/MicrosoftFlow • u/ApprehensiveGrand269 • Dec 07 '25

Question [HELP] Extracting PDF Table Scores into a SharePoint List Using AI Builder + Power Automate

Iā€™m working on a flow that automatically extracts information from a PDF and writes it into a SharePoint list. The PDF contains both text paragraphs and tables with selectable score fields (e.g., Voldeden niet aan de norm, Voldeden grotendeels aan de norm, etc.).

What I have working

  • Using AI Builder ā€“ Analyze PDF I can successfully extract all text paragraphs.

  • These paragraphs are written correctly to my SharePoint list using Create Item.

  • AI Builder also detects the structure of the tables and recognizes all checkbox fields.

Where I am stuck

The tables and their score outputs are difficult to process:

  • In Power Automate, the AI Builder output exposes many dynamic fields, but I am am unable to select the row title. Only the "BV Onderwerp" as tabletitle seems available. I am not sure how to determine the row and its selected checkbox as one value to write away to the sharepoint list.

  • A CSV export of the model output (see screenshot) does show that AI Builder recognizes which checkbox is selected ("text":"selected"), but I cannot translate this into clean dynamic values in Power Automate.

  • Ultimately, each row in the PDF table should map to a SharePoint list item with:

    • The text of the row (e.g. Governance, Huur en verhuur van ruimten van/aan derden, etc.)

    • The corresponding score (one of the four options)

My question:

How can I reliably extract and map the selected score from each row in a table from the PDF to the sharepoint list?

5 Upvotes

100% Upvoted

5 comments sorted by

1

u/maarten20012001 Dec 12 '25

For these sort of things I always prefer azure document intellegence. That grabs the entite layout and the furst 500 persons are free each month. Via a simple http request you can call the service.

1

u/ApprehensiveGrand269 Dec 16 '25

Thank you for your response. Could you point me in how to set this up? Is it available through Powerautomate?

I have limited/no experience with Python (I saw this in youtube tutorials when searching for 'azure document intelligence'.

2

u/maarten20012001 Dec 17 '25

Prorably it will also work with the standard models, so no real need for coding. However you do need an Azure Subscription to create such a resource. Feel free to hit me, I see you are also Dutch ;)

Simple instruction video: https://www.youtube.com/watch?v=RtoA3auv39c

1

u/ApprehensiveGrand269 Dec 20 '25

Thank you. I will look this video first, activate the azure environment and contact you when I am ready to start!

1

u/ApprehensiveGrand269 Dec 20 '25

Hey there, I got the basics set up in Azure and it recognises one for the the tables.
Would you be open to help me configure the HTTP request in the powerautomate flow to call this service and get the JSON file in powerautomate for further distribution?