Unanswered

How can I reference a column value from an extracted datatable?

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hello,

Trying to create an "if" statement for a looped process based on information in a web-scraped datatable. I've tried the following variable references with no luck:

(For reference: %WebDataTable% is the variable name for the web-scraped datatable, and %ColumnVariable% and %RowVariable% are variables which return a specific number)

- %WebDataTable[ColumnName]% = "Value"

- %WebDataTable["ColumnName"]% = "Value"

- %WebDataTable['ColumnName']% = "Value"

- %WebDataTable[RowNumber][ColumnNumber]% = "Value"

- %WebDataTable[%RowVariable%][%ColumnVariable%]% = "Value"

- %WebDataTable[RowVariable][ColumnVariable]% = "Value"

Just trying to pull all records in the datatable in which the column value I have in mind is equal to specific word - basically a filter of sorts.

Thanks for any assistance.

Categories:

Power Automate Desktop

I have the same question (0)

All responses (3)

Answers (0)

Sort by

OkanMTL 703 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello,

You can turn the column you have the 'value' of into a list, with the activity: retrieve datatable column into list and its values. Where you can filter on column, if the column does not exist it will give an error. But here you can do some try/catch/iferror activities.

Good luck

Was this reply helpful? Yes No
Pavel_NaNoi 1,074 on at

Like
a
(0)

Report
Copy link

Link copied!

Its actually so painful that you can't pull out column values out of data-tables, only out of data-rows at the moment 😓

Was this reply helpful? Yes No
ospina_faber 2 on at

Like
a
(0)

Report
Copy link

Link copied!

- %WebDataTable[RowVariable][ColumnVariable]% = "Value"

this is the right way, but you need to convert RowVariable to Number, you can use Text To Number Action.
ColumnVariable would be the name of the column 'ColumnName' or IndexColumn (number).

Was this reply helpful? Yes No