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

Like (0) Share

Report

Posted on 27 Jun 2022 05:58:24 by ReemaB

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.

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?

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

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

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

All responses (3)

Answers (1)

takolota1 4,859 Super User 2025 Season 1 on 22 Jun 2023 at 16:34:49

Like (0)

Report

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

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
ReemaB 2 on 01 Jul 2022 at 06:04:27

Like (0)

Report

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

Hey yes, gotcha!

Thanks Charlie for the headsup. 👍
Verified answer

v-yujincui-msft on 01 Jul 2022 at 03:45:15

Like (0)

Report

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

Hi @ReemaB ,

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

Best Regards,

Charlie Choi