Skip to main content

Notifications

Community site session details

Community site session details

Session Id : lt77k+GgiBnTdeRTVKHOay
Power Automate - General Discussion
Unanswered

Loop through PDF Pages to extract data into excel

Like (1) ShareShare
ReportReport
Posted on 9 Jun 2022 10:04:07 by

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:
  • Phoenix1010 Profile Picture
    3 on 21 Oct 2023 at 16:38:33
    Re: Loop through PDF Pages to extract data into excel

    Have the same needs 😥
    Can anyone help?

  • CameronTCD Profile Picture
    108 on 02 Feb 2023 at 14:46:01
    Re: Loop through PDF Pages to extract data into excel

    @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.

  • Tjan Profile Picture
    1,087 Super User 2025 Season 1 on 09 Jun 2022 at 20:06:26
    Re: Loop through PDF Pages to extract data into excel

    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 👍

  • Community Power Platform Member Profile Picture
    on 09 Jun 2022 at 18:23:42
    Re: Loop through PDF Pages to extract data into excel

    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

     

  • Tjan Profile Picture
    1,087 Super User 2025 Season 1 on 09 Jun 2022 at 17:39:42
    Re: Loop through PDF Pages to extract data into excel

    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!

     

  • Tjan Profile Picture
    1,087 Super User 2025 Season 1 on 09 Jun 2022 at 17:14:11
    Re: Loop through PDF Pages to extract data into excel

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

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

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Markus Franz – Community Spotlight

We are honored to recognize Markus Franz as our April 2025 Community…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,702 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 66,015 Most Valuable Professional

Leaderboard