Pull data from multiple tables in PDF documents to excel or in to a PowerApps table

Documents
1

Hi,

I've been looking for a way to pull information from PDF documents that are received in to Excel or PowerApps if its easier.

The PDFs can contain multiple pages and the tables that need to be pulled have to be formatted and have columns added to them.

This will basically be used as a master sheet/database and as more PDFs are received they will be appended on to this.

I've been playing around with Python scripts and VBA to do it but then was suggested to try Plumsail with Power Automate but dont really know where to start? Any help would be amazing. thanks

2

Hi @jdinsight,

Try to use this action Get Form from PDF.

It returns data from fillable PDF as JSON and then the data can be used with any action from Power Automate.

Also, check the articles. You can adjust the cases according to your needs

Please let us know if it helps.

Best regards,
Petr
Plumsail team

1 Like