Unanswered

Problem with "or" condition in sharepoint flow

(0) Share

Report

Posted on by CrispyFries

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)

Verified answer

v-yamao-msft on at

Like (0)

Report
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
CrispyFries 26 on at

Like (0)

Report

This worked 🙂 thank you

Was this reply helpful? Yes No