• Skip to main content
  • Skip to primary sidebar
  • Skip to footer
  • Home
  • Blog
  • Power Platform
    • Power Apps
    • Power Automate
    • Power BI
    • Power Virtual Agents
  • Dynamics 365
  • Azure
  • About Me
Joe Gill Logo

Joe Gill

Microsoft MVP - Power Platform Consultant

Home » Power Platform » Extract Tables from a PDF using Power Automate Desktop

Extract Tables from a PDF using Power Automate Desktop

23rd May 2022 by Joe Gill

extract table from pdf and write as csv file using Power Automate Desktop

I previously did a post that demonstrated how you can use Power Automate Desktop to extract text from a PDF. At the time you were not able to extract tables from a PDF. In Feb 2022 Microsoft announced that they added that capability to PAD so I thought I might give it a quick whirl. To use it simply drag the Extract Table from PDF action to the designer providing the source of the PDF and the name of the variable where the extracted tables are to be stored.

Extract Tables from a PDF using Power Automate Desktop Joe Gill Dynamics 365 Consultant

If you run this action and view the ExtractedPDFTables variable you will see that it contains a list of datatables for the tables it has found in your PDF.

Extract Tables from a PDF using Power Automate Desktop Joe Gill Dynamics 365 Consultant

Here I added an action to write the third table in the PDF as a CSV file by using the variable %ExtractedPDFTables[2].Datatable% (remember lists start at 0, not 1)

Extract Tables from a PDF using Power Automate Desktop Joe Gill Dynamics 365 Consultant

The third table in my sample PDF contains a table of land speed records.

Extract Tables from a PDF using Power Automate Desktop Joe Gill Dynamics 365 Consultant

You can also use a For Each loop to iterate the rows in a data table and call actions. Here I added a database connection to my flow and within my loop added a SQL statement command to insert details of the current row into a table.

Extract Tables from a PDF using Power Automate Desktop Joe Gill Dynamics 365 Consultant

With just a few actions in my Power Automate Desktop flow I was able to extract a table of data from a PDF and insert those details into a database. The automation potential of PAD is enormous. It is also free to use on Windows so there is no reason not to give it a whirl and start automating your mundane repetitive tasks.

Extract Tables from a PDF using Power Automate Desktop Joe Gill Dynamics 365 Consultant

Share This On Social:
  • Tweet
  • Extract Tables from a PDF using Power Automate Desktop Joe Gill Dynamics 365 Consultant

Filed Under: Power Automate, Power Platform

Primary Sidebar

Popular Categories

  • Power Platform
    • Power Apps
    • Power Automate
    • Power Virtual Agents
  • Azure
    • Logic Apps
  • Dynamics 365
  • .NET
  • AI
  • SQL

More to See

Power Platform Requests – Base Request Capacity

17th December 2020 By Joe Gill

Power Automate Desktop

Power Automate Desktop – UI Flow

26th November 2020 By Joe Gill

extract table from pdf and write as csv file using Power Automate Desktop

Extract Tables from a PDF using Power Automate Desktop

23rd May 2022 By Joe Gill

Dataverse Anonymization

25th April 2022 By Joe Gill

Tweets

Footer

Joe Gill

Microsoft Business Applications MVP – Power Platform, Dynamics 365 and Azure.

An architect with over twenty years experience designing and developing technology solutions. Specializing in the Microsoft technology stack including Power Platform, Dynamics 365 and Azure. Microsoft MVP Profile

Connect on Social

Useful Links

  • Home
  • Blog
  • About Joe Gill
  • Power Platform
  • Dynamics 365
  • Azure

Featured Posts

Power Platform Requests – Base Request Capacity

Power Automate Desktop – UI Flow

Synapse Link for Dataverse – Metadata

Extract Tables from a PDF using Power Automate Desktop

Dataverse Anonymization

Dataverse Metadata in Synapse

© 2022 · Joe Gill