Power Platform Community Forum Thread Details

Hello,

I'm new to PAD but finding it very intuitive / easy to use so far, especially as not working in a traditional tech role.

I'm just having an issue querying a datatable & forming a conditional I can't figure out. Forgive me if this should be simple stuff!

For arguments sake, lets say I've extracted the above datatable from the web.

I want to write a conditional statement that says IF Price = $20, then Set Variable to the product code on the same row.

In that data i'll be using there may be more than one price @ $20 (each with a different product code), so I assume there's a way to do this for the first row it finds, set the variable and then i can loop it back to extract new data and work on the first row it finds when the conditions are met.

Hopefully this makes some kind of sense.

Thanks!

Categories:

Power Automate Desktop