web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id : ig6G2En+XUcqAqUiSty6Wf
Power Automate - Power Automate Desktop
Unanswered

How to loop multiple table in each pdf with all pdf in folder then copy to excel

Like (0) ShareShare
ReportReport
Posted on 23 Nov 2023 03:41:48 by

Hi all, please help me with this case 

my scenario is  :
I have 1 folder that consist of multiple PDF  file , each pdf file have multiple table.
I need to extract all multiple table  in each of all pdf file in that folder then copy to each file to multiple excel sheet 

Thank you in advance for your help     

 

 

best regard 

 

firstch

 

I have the same question (0)
  • UshaJyothiKasibhotla Profile Picture
    160 Moderator on 24 Nov 2023 at 09:24:54
    Re: How to loop multiple table in each pdf with all pdf in folder then copy to excel

    try the following steps

    use get files from folder activity to fetch the files from the folder

    use for each activity to loop through the files

    inside the foreach acitivity

    use open application to open the PDF file

    then use extract table from pdf activity to fetch tables from pdfs 

    check the tables.count in the pdf 

    oop through the tables using for each

    then use write to the excel sheet activity for entering the table into the sheet

     

    This is an outer view for your scenario. let me know if you got struck

    Hope this helps

    Usha.

     

  • UshaJyothiKasibhotla Profile Picture
    160 Moderator on 24 Nov 2023 at 09:37:02
    Re: How to loop multiple table in each pdf with all pdf in folder then copy to excel

    This is flow for one file to extract table 

    if any pdf contains more than one table then we can call by index and write each table into the each excel sheet

     

    UshaJyothi20_0-1700818614966.png

    Hope this helps

    Usha.

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Chiara Carbone – Community Spotlight

We are honored to recognize Chiara Carbone as our Community Spotlight for November…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 666 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 382 Moderator

#3
developerAJ Profile Picture

developerAJ 254

Last 30 days Overall leaderboard
Loading complete