Hi there,
I am putting a flow together that triggers upon a row being added (dataverse). Once it is created, I want to look at a column value on that row and then pull a list of rows (different table) and filter the rows where a column equals the value of the column captured on the triggering row.
To put it into context, I have two tables; Measure and Project. When a measure is created, there is a column called 'Project Reference' populated. I want to then list all the Project rows where its name matches the reference number from the newly created measure record.
My original thought was to run the flow on create of a measure record, then list the Project records with a filter, however, I keep getting an error. Any assistance on how I compare the values would be much appreciated.

Report
All responses (
Answers (