Skip to main content

Notifications

Power Automate - Building Flows
Unanswered

Error creating Flow with trigger when a row is added, modified or deleted with modified selection

(1) ShareShare
ReportReport
Posted on by 14
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.
  • ivan_apps Profile Picture
    ivan_apps 2,187 on at
    Error creating Flow with trigger when a row is added, modified or deleted with modified selection
    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
     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,508

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,839

Leaderboard