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 / Trying to extract data...
Power Automate
Answered

Trying to extract data from PDF Table(And pass as JSON string in API to update in cloud DB)

(0) ShareShare
ReportReport
Posted on by 2

My purpose is:

I need to extract data from PDF Table(Ex. Bank Statements) and pass this as JSON Data through API to update database Table in cloud.

 

As a first step:

I am trying to extract data from PDF documents which is giving me a JSON string with this flow. But I need to extract the individual items of the table or only the required JSON items, for which I gave expressions for each item, in the apply to each loop.

ReemaB_0-1656308751051.png

 

Followed this tutorial for the same in which at the end he gets Item, Quantity, Rate, Amount values from the table using expressions.

https://www.youtube.com/watch?v=GW5iUV2rRGQ

 

But in my excel Book I am just getting JSON strings. Am I missing on anything or doing anything wrong here?

ReemaB_1-1656308883440.png

 

But he gets the Individual values for each Item in Table as below:

https://youtu.be/GW5iUV2rRGQ?t=1742

ReemaB_2-1656308985969.png

 

How do I achieve the same. Or are there any other approaches to achieve the same.

 

 

 

 

Categories:
I have the same question (0)
  • Verified answer
    v-yujincui-msft Profile Picture
    Microsoft Employee on at

    Hi @ReemaB ,

     

    It seems that you only have one Apply_to_each Action in your Flow instead of two.

    vyujincuimsft_2-1656647065177.png

    vyujincuimsft_0-1656646767061.png

    vyujincuimsft_1-1656646820420.png

     

     

    Best Regards,

    Charlie Choi

  • ReemaB Profile Picture
    2 on at

    Hey yes, gotcha!

     

    Thanks Charlie for the headsup. 👍

  • takolota1 Profile Picture
    4,980 Moderator on at

    You could try this template using AI Builder to extract any PDF data to a JSON object:

    https://powerusers.microsoft.com/t5/Power-Automate-Cookbook/Extract-Data-From-PDFs-and-Images-With-GPT/td-p/2201345

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 March Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Haque Profile Picture

Haque 605

#2
Valantis Profile Picture

Valantis 340

#3
11manish Profile Picture

11manish 284

Last 30 days Overall leaderboard