web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / [HELP] Extracting PDF ...
Power Automate
Unanswered

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

(0) ShareShare
ReportReport
Posted on by
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 (RED NOT OK/ORANGE/Light green / Very green = OK)
 

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 and corresponding score. 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?

Schematic overvie...

Your file is currently under scan for potential threats. Please wait while we review it for any viruses or malicious content.

Categories:
I have the same question (0)
  • Michael E. Gernaey Profile Picture
    53,978 Moderator on at
     
    I do not know if the picture (which unfortunately didnt come through) is supposed to be the output schema of your AI Builder, but that JSON is what I would need to see to help you, as you will need to iterate through that, but without seeing a sample exactly full output it's hard to guess.
     
    Once I see that I can tell you exactly what to build it as.
     
    Cheers
     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the April Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Vish WR Profile Picture

Vish WR 959

#2
Valantis Profile Picture

Valantis 872

#3
Haque Profile Picture

Haque 589

Last 30 days Overall leaderboard