Extract Table from PDF but only on certain column

(0) Share

Report

Posted on by foxngn84

Hi All,

I'm trying to extract table from pdf, but i only know how to extract the full table but not on certain column.

I tried to tie it with the column name, but issue happens when it continuous to extract the following table in the pdf, as the column name will not appeared after page 1.

What kind of command I need to specify it extract just column 1 of the table?

Below this is the first page of the pdf table.

While this is the following one where 46 is the brand list already.

Categories:

Power Automate Desktop

I have the same question (0)

All responses (4)

Answers (0)

Suggested answer

eetuRobo 4,204 Super User 2025 Season 2 on at

Like (0)

Report

So do you just want the first column to be inserted into your excel? If so I would just take the Column as a list with "Retrieve data table column into list" -action. Then just paste that and do that to all the datatables you retrieved.

And have condition to check if column header is not header name but value

Your for each loop has couple of problems. You are always opening Excel each loop when I would assume you want to use the same excel to just paste the column info to the next free row.
Also you are not using For each loops CurrentItem anywhere. You should not be using "ExtractedPDFTables" since thats a list of table you are going through in your loop. Use CurrentItem instead which has the currently looped table information in it.

Was this reply helpful? Yes No
foxngn84 95 on at

Like (0)

Report

ThankseetuRobo , yes this is what i hope to achieve, but it should be column 1, which holds the brand name.

I just changed all Datatable.columns[1] if i wanted the brands name right? since 0 is treated as the first column.

Also is it possible for it to not grab the header(column name)? Cause i intend to just grab the data itself only since the excel I prepared already gotten the headers. But then I can live with this flow as well.

Appreciated your help on the solution you posted. Thanks again.

Was this reply helpful? Yes No
Suggested answer

eetuRobo 4,204 Super User 2025 Season 2 on at

Like (0)

Report

Great to hear solution I provided helped you forward.

I just changed all Datatable.columns[1] if i wanted the brands name right? since 0 is treated as the first column.

Yes exactly.

Also is it possible for it to not grab the header(column name)? Cause i intend to just grab the data itself only since the excel I prepared already gotten the headers. But then I can live with this flow as well.

If you use the Retrieve data table column into list -action it should not take the headers with it but just the values as a list which you can just insert to the Excel.

The If condition checks if the Column name contains "INTERNATION" in it and if so it doesn't write that into excel since that would be the column name.
But if it doesn't have "INTERNATIONAL" in the column name then it takes the value to %BrandInColumn% -variable and writes that into next empty cell (since that is a brandname you want to have in your excel)

Was this reply helpful? Yes No
foxngn84 95 on at

Like (0)

Report

Much Appreciated on the help, eetuRobo .

This is exactly what i needed.

Was this reply helpful? Yes No