New Extract Tables from PDF feature

Like (0) Share

Report

Posted on 25 Feb 2022 15:43:48 by arslanarif

Good Day. Thank you for your interest.

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. The PDF tables may contain multiple rows of data depending on the number of product items in the Invoice. It may be (1,2,3 rows of data...etc). I figure a type of loop would be necessary here to process each row of data. 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. Some invoices may have more rows of data and some may have less.

I recently updated our Power Automate Desktop and noticed a new feature for PDF extraction. It's labeled "Extract tables from PDF". You can view it below. I ran a demo flow to see what result it would show for a simple table. The sample extracted table results are posted below the picture.

Since I am new to power automate desktop, what would be the best way to use save these values and use them in to populate a web form in part of a Web UI automation?

Any lead way guidance on this request would be greatly appreciated. Best Regards,
Sunny

Extracted Tables Result:

#	Description	Quantity	Unit Price	Subtotal
0	Full Time Live Academy	1.0000	$3,995.00	$3,995.00
1	Curriculum Support	1.000	$650.00	$650.00

All responses (2)

Answers (1)

XSpence8 29 on 16 Aug 2024 at 20:43:37

Like (0)

Report

New Extract Tables from PDF feature

Hi @VJR

The screenshots cited in your response are not all appearing.

I am trying this as you described and returning status errors on the ExtractedPDFTables output:

Any insight would be appreciated. Thank you!
Verified answer

VJR 7,635 on 28 Feb 2022 at 04:29:09

Like (2)

Report

Re: New Extract Tables from PDF feature

Hi @arslanarif

- As an example this is how the table in my PDF looks like

- After the "Extract tables from PDF" action is executed you will see the output in a datatable variable

Open the variable and click on More

Keep clicking the More buttons until you see the final table as below

Refer red marked below. That is what you need to make use of in the "For each" action.

Below is how the overall flow looks like

I have marked all the important items in red.

You can use the CurrentName and CurrentPosition variables to update them to the webpage.

In the "Extract table from PDF" make sure to turn on this setting if not already On.