Ms excel extract transform load pdf

broken image

The sample extracted table results are posted below the picture. I ran a demo flow to see what result it would show for a simple table. I recently updated our Power Automate Desktop and noticed a new feature for PDF extraction. Some invoices may have more rows of data and some may have less.

broken image
broken image

The other 'how to' challenge I am anticipating is how to dynamically save the values from the PDF table to be then used as variables to enter a web form since the number of List records may vary per invoice. I figure a type of loop would be necessary here to process each row of data. The PDF tables may contain multiple rows of data depending on the number of product items in the Invoice. The scope of the requirement is that when a new invoice is issued to a customer, a copy of the relevant details is sent to an Email inbox with the PDF attachment containing the table details of the product items, their description, price, and total.

broken image