Power Platform Community Forum Thread Details

I am trying to build flow that triggers when a row is modified in Balance Sheet. After the trigger action I am using a List row action with the same table to obtain the complete list of records with the following filter
new_restaurant eq @{triggerBody()?['_new_restaurant_value']} and new_year eq @{triggerBody()?['new_year']} and new_period eq @{triggerBody()?['_new_period_value']} and new_calculated eq false
Everything seem to be correct but when i test the flow I have an error telling me that new_restaurant is not recognized. new_restaurant is the correct name of the logical name of the field. I would like to know if it is necesasry to do something special when you are trying to use List rows with same table.

balancesheetdata.csv

Categories:

Building flows

Are you sure it isn’t ‘new_restaurantid’ ??

it looks like you are comparing to a lookup value, which would be a GUID. If you are comparing against the primary field of the Restaurant table, it normally ends in ’id’.

new_restaurant eq @{triggerBody()?['_new_restaurant_value']}

the comparison above is on the left the logical name and on the right a GUID. If this is a lookup and not on the table where this is the primary identifier field, then your Odata query should be:

_new_restaurant_value eq @{triggerBody()?['_new_restaurant_value']}

Last recommendation is to install and use DataverseRestBuilder and use the UI to create your power automate criteria. It will format everything for you - https://github.com/GuidoPreite/DRB/releases