Loop through PDF Pages to extract data into excel

(1) Share

Report

Posted on by Community Power Pla...

Screenshot 2022-06-09 180223.png

Hello Everyone,

I am trying to build a flow, on Power Automate Browser, where the flow:
- Receives pdf from email

- Loops through each page and simultaneously uses AI Model (Extract information from forms) that I built, to extract desired information from each of those pages.

- Extracts those info into excel.

Issue that I am facing:
- I am unable to add a loop function where the flow loops through each pdf pages. Some of the pdf have 400-500 pages and want the flow to extract information from each page.

Attaching a screenshot of the existing flow. Please Note, I have not used the email and excel activity yet. Just wanted to test out the loops first.

Appreciate if you can attach some screenshots of the workflow as it would help me understand better.

Kind Regards.

Categories:

General topics

I have the same question (0)

All responses (6)

Answers (0)

TYL 1,091 Super User 2024 Season 2 on at

Like (1)

Report

I also face this problem! Looking forward to the solutions 🙌

Was this reply helpful? Yes No
TYL 1,091 Super User 2024 Season 2 on at

Like (2)

Report

I found the solution!

Please look at:
https://docs.microsoft.com/en-us/ai-builder/form-processing-multipage

The template under the header 'Use a cloud flow to process all pages in the document' did it for me! Hope it works for you as well!

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Hi, I have just checked and there seems to be a 'Continue' variable there (in Do Until activity). Can you share what code/expression you have used since it is not available in the document

Was this reply helpful? Yes No
TYL 1,091 Super User 2024 Season 2 on at

Like (0)

Report

I haven't used any actually. I just took their template and filled it in with my stuff.

Don't try to replicate, I did that and it went wrong. Just use their template 👍

Was this reply helpful? Yes No
CameronTCD 108 on at

Like (1)

Report

@Tjan , looking for this but can't seem to find it. Must've been updated and removed.
Could you potentially post the process? Trying to do the exact same thing as OP but I can't seem to find a solution for running a model over hundereds of PDF pages.

Was this reply helpful? Yes No
Phoenix1010 3 on at

Like (0)

Report

Have the same needs 😥
Can anyone help?

Was this reply helpful? Yes No