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 |
