Conditional Triggers with SharePoint

(0) Share

Report

Posted on by CU01081947-0

716

Hello Power Automate Community,

I hope you can help please.

I'm using the SharePoint connector trigger called "When an item is created or modified".

I only want this Flow to run on a certain condition, which is:

When an item is modified

And

The field StatusReason = Send Approval Email Owner

The StatusReason field in SharePoint is a Choice field.

The output of the trigger for StatusReason on a specified record is this:

"StatusReason": {
"@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
"Id": 4,
"Value": "Send Approval Email Owner"
},
"StatusReason#Id": 4,

What conditional trigger do I need please to only run the Flow when StatusReason = Send Approval Email Owner?

Any help would be greatly appreciated. Thanks very much,

Garry

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (2)

Verified answer

efialttes 14,756 on at

Like (1)

Report
Copy link

Link copied!
Hi!

I would try with

@equals(triggerBody()?['StatusReason']?['Value'],'Send Approval Email Owner')

Hope this helps

Was this reply helpful? Yes No
CU01081947-0 716 on at

Like (0)

Report
Copy link

Link copied!

Hello @efialttes,
Thanks for the reply. When I add your conditional trigger in the Flow's trigger it then never runs.
I also tried adding a conditional trigger from @ScottShearer, which is found on his blog, but again the Flow never runs. Thanks Scott.
As soon as I remove the conditional trigger it runs.
Odd behaviour, I must be doing something wrong.
Thanks very much,
Garry

Was this reply helpful? Yes No
Verified answer

CU01081947-0 716 on at

Like (1)

Report
Copy link

Link copied!

Hello @efialttes,
Your solution was correct, so I've marked it.
The issue was that no conditional trigger was running.
When I looked at @MattWeston365 excellent post, cheers Matt, I saw in the "Settings" of the trigger he had "Split On" enabled and then "Array" enabled. That, strangely was not enabled in my trigger. Once I enabled it your conditional trigger worked.

Thanks for your help,
Garry

Was this reply helpful? Yes No
efialttes 14,756 on at

Like (1)

Report
Copy link

Link copied!

@GarryPope

I also marked your last post as Solution.

Thanx for sharing! People like you make this community great 👍

Was this reply helpful? Yes No