Answered

Trigger Conditions - Or expressions

(1) Share

Report

Posted on by Ivey West

I'm trying to set trigger conditions for a flow. The flow is triggered on a Sharepoint: When an item or file is modified condition. I want to set the trigger such that it fires as long as the editor of the change isn't one of five people. I thought that I'd gotten the right expression worked out, but after testing overnight, turns out the trigger condition wasn't filter anything thing out, including 12 items that were edited by one of the five people included in the expression below (Names replaced with Last,First for posting).

@or(not(equals(triggerBody()?['Editor/DisplayName'],'Last, First')),not(equals(triggerBody()?['Editor/DisplayName'],'Last, First')),not(equals(triggerBody()?['Editor/DisplayName'],'Last, First')),not(equals(triggerBody()?['Editor/DisplayName'],'Last, First')),not(equals(triggerBody()?['Editor/DisplayName'],'Last, First')))

Appreciate any insight!

Categories:

Building flows

I have the same question (0)

All responses (9)

Answers (1)

Sort by

Suggested answer

stampcoin 5,148 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!
@Community member Hi,

You can try this one :

not( contains( createArray( 'user1@example.com', 'user2@example.com', 'user3@example.com', 'user4@example.com', 'user5@example.com' ), triggerOutputs()?['body/Editor/Email'] ) )

Was this reply helpful? Yes No
Ivey West 17 on at

Like (0)

Report
Copy link

Link copied!
@stampcoin

I'm getting a The power flow's logic app flow template was invalid. The template condition expression 'not( contains( createArray( 'example@example.com', 'example@excample.com', 'example@example.com', 'example@example.com', 'example@example.com' ), triggerOutputs()?['body/Editor/Email'] ) )' at line '1' and column '1105' is not valid template language expression.

Edit: CoPilot tweaked the expression to what's below, but the expression still allowing the condition to be trigger even with one of those email addresses.

@not(contains(createArray('email1', 'email2', 'email3', 'email4', 'email5'), triggerBody()?['Editor/EMail']))

Edit 2: Unless Test/Automatic bypasses the trigger condition? Because it didn't work in testing, but now seems to be that I've turned it on....

Was this reply helpful? Yes No
Verified answer

stampcoin 5,148 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@Ivey West Hi,

thanks for the feedback.

How did you use this ?

see below if use it in condition.

Left =

createArray(

'user1@example.com',

'user2@example.com',

'user3@example.com',

'user4@example.com',

'user5@example.com'

)

right = triggerOutputs()?['body/Editor/Email']

Was this reply helpful? Yes No
Ivey West 17 on at

Like (0)

Report
Copy link

Link copied!
@stampcoin

I think the issue was on my end. I had the flow turned off and was testing past runs that included one of my specific editors, and they were going through.

The minute I turned the flow on and started testing with live data, it seems to be working.

This was the expression formatting that worked for me (essentially what you gave me the first time, compressed down to one line since I can't expand the input field.

@not(contains(createArray('email1', 'email2', 'email3', 'email4', 'email5'), triggerBody()?['Editor/EMail']))

I've got to get some more live data -- probably on Monday -- to flow though, but I'm assuming I'll be able to mark as suggested answer then. Thanks again, that's twice you've saved my bacon this week!

Was this reply helpful? Yes No
stampcoin 5,148 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

@Ivey West Hi,

Sure, that's sound great.😊,

Feel free if you get a question.

Was this reply helpful? Yes No
stampcoin 5,148 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@Ivey West Hi,

Have you got a chance to check it ?

Was this reply helpful? Yes No
Ivey West 17 on at

Like (0)

Report
Copy link

Link copied!

@stampcoin

Yes, but still working through some issues. Is the trigger condition input case sensitive?

I have one user whose email is all caps for some reason; and hers are still leaking through. I’ve put the expression in a compose action, and it’s resolving as true, but hers are still running through the flow.

Was this reply helpful? Yes No
stampcoin 5,148 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@Ivey West Hi,

The email address is case sensitive, so please use

toLower()/toUpper() to format the addresses.

Was this reply helpful? Yes No
Poweruser811 36 on at

Like (0)

Report
Copy link

Link copied!
I'm having the same issue. But I only have 1 email that I want to exclude. How can I use this expression for 1 user? Thank you!

@not(contains(createArray('email1', 'email2', 'email3', 'email4', 'email5'), triggerBody()?['Editor/EMail']))

Was this reply helpful? Yes No