I have a trigger condition (shown below) to filter a SharePoint Item by Column 'Gate Review Status' is 'Complete'. I have this expression: @equals(triggerOutputs()?['body/Gate_x0020_Review_x0020_Status/value'], 'Complete').
I've also tried as
@equals(triggerBody()?['Gate_x0020_Review_Status']?['value'],'Complete'). Every time my test doesn't fail, but it just keeps running. If I take the
Solved! Go to Solution.
Take a look at the incoming JSON when the trigger fires. I've found that you can't do a trigger condition on a complex object like a choice column. But if you look closely you will see a section of the incoming JSON similary to the one below. This highlights a Status Choice column. As you can see there is a Status#Id property. This is the index of the selected choice. Although you can't filter the trigger on the value of Status you can filter on this Id.
Not the ID of the Status field. There should be a property in the first level that is a simple integer called something like 'Status#Id' where Status is the name of the field. The trigger query can't expand the complex object but it can access the first level simple properties.
Check out the new Process Advisor community forum board!
Check out new user group experience and if you are a leader please create your group
On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks
Check out how to claim yours today!