web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate How do I conditionally...

Power Automate

Unanswered

How do I conditionally iterate through a datatable?

(0) Share

Report

Report

Posted on by Community Power Pla... Microsoft Employee

In short, I want to perform iterative actions with data in a datatable, only if a certain value exists in one of the columns. I've set it up as follows:

For each "Current Item" in DataTable

If "Column" = "Value"

- perform action 1

- perform action 2

End

However, the flow simply skips over the the "IF" steps and ends, despite the fact that there are records in the DataTable with "Value" in the "Column" field.

Categories:

Power Automate Desktop

All responses Img

All responses (2)

Answers Img

Answers (0)

Sort by

kinuasa 803 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
Hi,
It is necessary to specify a column name or index when using the IF action.

Regards,
kinuasa

*Below is a sample code. Please copy and paste to use.
SET DataTable TO { ^['Name', 'Position', 'Office'], ['Ashton Cox', 'Junior Technical Author', 'San Francisco'], ['Bruno Nash', 'Software Engineer', 'London'], ['Cedric Kelly', 'Sales Assistant', 'New York'] } LOOP FOREACH CurrentItem IN DataTable IF CurrentItem['Office'] = $'''New York''' THEN Display.ShowMessageDialog.ShowMessage Message: CurrentItem Icon: Display.Icon.None Buttons: Display.Buttons.OK DefaultButton: Display.DefaultButton.Button1 IsTopMost: True ButtonPressed=> ButtonPressed END END
Nived_Nambiar 18,138 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Anonymous

Kindly check whether there is any space in the value, so while comparing, Trim that space

Hope this helps !!!

thanks & regards,
Nived N

Join the conversation