cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
chelclayne
New Member

Help with Trigger Conditions with SharePoint

Hi,

 

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()?['body/Gate_x0020_Review_x0020_Status/value'], 'Complete'). 

 

I tried 

@equals(triggerBody()?['Gate_x0020_Review_Status']?['value'],'Complete'). Every time my test doesn't fail, but it just keeps running. If I take the 

 

chelclayne_0-1611339681581.png

 

1 ACCEPTED SOLUTION

Accepted Solutions
chelclayne
New Member

this was the expression that ended up working...

 

@equals(triggerOutputs()?['body/GateReviewStatus/Value'],'Not Ready')

View solution in original post

4 REPLIES 4
Pstork1
Dual Super User III
Dual Super User III

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.

image.png



-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

chelclayne_0-1611343819516.png

 

I'm not having any luck with that, either.

 

Pstork1
Dual Super User III
Dual Super User III

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.

image.png



-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
chelclayne
New Member

this was the expression that ended up working...

 

@equals(triggerOutputs()?['body/GateReviewStatus/Value'],'Not Ready')

View solution in original post

Helpful resources

Announcements
Process Advisor

Introducing Process Advisor

Check out the new Process Advisor community forum board!

MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

Users online (21,960)