r/PowerAutomate•
ez1138

Flow to Read/Extract Data from PDFs/HTML/XLS with AI Builder

Hi,

I've built successful flows with the AI builder I'm having an issue with an export from Excel and PDFs that does not have a defined table and has additional rows. What's the best practice for an Excel export (CSV) to be able to extract the data with a table that is not defined as a table that may change in length. The column names are static as are the rows before the table starts. Again, the export is simply a CSV.

Appreciate any insight.

Title
Team
Report Date8/5/26 20:30
LocationNew York, NY
Start Date8/4/26
End Date8/4/26
OperationAll
MethodManual
NumberNameAgeLocation
1John30New York City
2Tom25Los Angeles
3Joe21Milwaukee
4Sally40San Diego
5Julie50Orlando

Posted Aug 5, 2026, 1:32 PM UTC

21
Loading comments…