Answered

Problem with "or" condition in sharepoint flow

(0) Share

Report

Posted on by AM-18051333-0

I'm trying to create a flow that triggers an email when a new item is added to a sharepoint list (its a new user form that details their equipment requirements)

The item has a number of yes/no fields and i want the flow to send an email to an email address if any of the fields values are set to yes. My problem is the OR condition doesn't appear to accept more than 2 values.

This works if one of the values is set to yes in the sharepoint form:

@or(equals(triggerBody()?['DeskRequired'], true), equals(triggerBody()?['DeskphoneRequired'], true))

This doesn't, it always evaluates to false even if the values are set to yes in the sharepoint form

@or(equals(triggerBody()?['DeskRequired'], true), equals(triggerBody()?['DeskphoneRequired'], true), equals(triggerBody()?['DualMonitors'], true), equals(triggerBody()?['Location'], true), equals(triggerBody()?['MiFiRequired'], true), equals(triggerBody()?['SmartCard-Keyboard'], true))

What am i doing wrong?

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

v-yamao-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @CrispyFries,

I made a test on my side with the or function. I have four Yes/No fields in my list.

I configured the function in flow likes below and it worked fine when any of the fields value were set to Yes.

@or(equals(triggerBody()?['Approved_x003f_'], bool('True')),equals(triggerBody()?['Test2'], bool('True')),equals(triggerBody()?['Test3'], bool('True')),equals(triggerBody()?['Test4'], bool('True')))

Hope it can be a reference for you.

Best regards,
Mabel Mao

Was this reply helpful? Yes No
AM-18051333-0 30 on at

Like
a
(0)

Report
Copy link

Link copied!

This worked 🙂 thank you

Was this reply helpful? Yes No