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 / Getting specific value...
Power Automate
Unanswered

Getting specific values from PDF table into a single excel row

(0) ShareShare
ReportReport
Posted on by 2

Hi!

 

I am trying to create a PDF parser for project reports (structured), and I want the extracted data (both text, numbers and table entries) from every report to be added on a single row in an excel spreadsheet, as a reporting overview for our CFO. In other words one row per project, with all the relevant data on that row. I successfully did this a year ago by only looking for 'Text fields' in ai builder, and I got everything working in power automate, but the ai model had low accuracy.

 

When I now try to change the ai model to read numbers as numbers, and the tables as tables instead of just text fields, the accuracy of the model is a lot better (naturally). But I don't understand how I can access the individual table entries in my flow in order to copy them to a specific column in my spreadsheet..? All the other extracted data is available as dynamic content, but the table entries are not. Do I need some intermediate step to "unpack" the tables? I know that the ai model correctly extracts the tables, I just don't know how to access the specific table entries in an "add/update a row in a table" action.

 

Thanks in advance

Categories:
  • Perder123 Profile Picture
    2 on at

    I have found that I can initialize an array variable, and append the values from a specific extracted table column into this array. Then I can use the array index# to copy the individual cell entries. However, I don't think this is a reliable method, as it returns an error if I have set it up to copy a certain amount of entries. If one of the table cells are empty, there will be one less entry, and the flow will fail.

     

    Surely there is a better way to achieve this? my understanding of PA and Ai Builder is quite basic, so apologies in advance if I am asking dumb questions

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Leaderboard > Power Automate

#1
11manish Profile Picture

11manish 275 Super User 2026 Season 2

#2
Mohsin Ali Profile Picture

Mohsin Ali 235

#3
David_MA Profile Picture

David_MA 178 Super User 2026 Season 2

Last 30 days Overall leaderboard