Answered

Check specific column contents before writing to Excel

(0) Share

Report

Posted on by StanM

Hi,

I am extracting a table from a PDF and writing it to an Excel sheet. I am writing 1 row at a time by looping through the table. I am using the following variable:

%ExtractedPDFTables[0].datatable[rowNumToWrite]%

I iterate rowNumToWrite until I have written all rows.

There are 8 columns in the row and I want to check if a specific column (for example column D) is empty or not. If empty, I do not want to write the row.

How can I specify in an IF group the column I want to test?

On a side note, is there any good documentation that lists all the "add ons" you can append to a variable? For the ExtractedPDFTable variable, I only found by searching far and wide that you can put .datatable and row# after it. When I check the variable in the PAD editor and drill down it only offers "count".

Categories:

Power Automate Desktop

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

Agnius Bartninkas Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!
If you have a specific column name or index, you can use

%DataTable[rowIndex][columnIndex]%, where columnIndex is either a numeric value entered directly, or a variable containing a numeric value

%DataTable[rowIndex][columnNameAsVariable]%, where columnNameAsVariable is a variable that contains a column name as a string

%DataTable[rowIndex]['columnName']%, where columnName is a string entered directly that represents a column name.

So, in your case, if you wanted to check column D (which is the 4th column, so we need index 3, as indexes are 0-based), you would need to use %ExtractedPDFTables[0].datatable[rowNumToWrite][3]% in your condition.

As for some reference on variable data type properties, there's an article covering all of them here: https://learn.microsoft.com/en-us/power-automate/desktop-flows/datatype-properties

-------------------------------------------------------------------------
If I have answered your question, please mark it as the preferred solution. If you like my response, please give it a Thumbs Up.

I also provide paid consultancy and development services using Power Automate. If you're interested, DM me and we can discuss it.

Was this reply helpful? Yes No
StanM 23 on at

Like (1)

Report
Copy link

Link copied!

@Agnius once again, you have helped me! Thanks very much.

Was this reply helpful? Yes No