Mutiple values in an "if" condition

[Anonymous]

Hi guys, I'm building a flow that is pretty big. I am shrinking the flow by working with "if" expressions.

I would like multiple values ​​in 1 "if" expression, but I keep getting the message "the expression is invalid"

So I have to work with multiple (5) expressions to get the same result. How do I make sure that I get those 5 expressions in 1 with multiple values?

Example of the code:

if(or(equals(body('Reactiedetails_ophalen')?['r4cbf8f096147455892f186c764bea97e'],'Ja (later mailen)'),not(equals(body('Reactiedetails_ophalen')?['r8d63fc9bcd68461fa2fb5973eff4981f'],'Bestaand profiel verhuizen'))),'<br>De foto,"'body('Reactiedetails_ophalen')?['rd0d05f90684349108de6f5fb96f73d14']' 'body('Reactiedetails_ophalen')?['r82d00fa06b164d8fb4ec01705f0a7e0e']' - 'body('Gebruikersprofiel_ophalen_(V2)')?['displayName'],'')

Thanks in advance

[efialttes]

Hi!

I believe a similar issue is discussed here, if so, you need to nest your if() WDL functions.

https://powerusers.microsoft.com/t5/General-Power-Automate/How-to-join-multiple-if-empty-statements-...

Hope this helps

[Anonymous]

So, ehh.... another options?

[efialttes]

OMG... I pasted the wrong link... truly sorry

https://powerusers.microsoft.com/t5/General-Power-Automate/How-to-join-multiple-if-empty-statements-...

[Anonymous]

hi @efialttes,

That is an solution for another question i was struggle with. Thanks in advance. But it is not the solution for this question.

I try to explain my problem more below.

When someone adds an picture in forms, power automate adds the next line of text in an email it send at the end of the flow.

<br>De foto, first name last name - displayname, is geupload naar SharePoint (https://companyname.sharepoint.com/etc. etc.

• Red text = a solid line of text
• Blue text = variables from ms forms
• Green text = variables collected earlier in the flow.

Picture below is the example in a variable.

If you have any questions, please, feel free to ask.

Thanks in advance

[efialttes · Accepted solution]

---

Hi!

So this is serendipity, right?

Now, on your current challenge:

If you have any questions, please, feel free to ask.

Thanks in advance

---

So the problem is the expression you shared as example is invalid, right? I mean this one

if(or(equals(body('Reactiedetails_ophalen')?['r4cbf8f096147455892f186c764bea97e'],'Ja (later mailen)'),not(equals(body('Reactiedetails_ophalen')?['r8d63fc9bcd68461fa2fb5973eff4981f'],'Bestaand profiel verhuizen'))),'<br>De foto,"'body('Reactiedetails_ophalen')?['rd0d05f90684349108de6f5fb96f73d14']' 'body('Reactiedetails_ophalen')?['r82d00fa06b164d8fb4ec01705f0a7e0e']' - 'body('Gebruikersprofiel_ophalen_(V2)')?['displayName'],'')

I believe you need to use concat() WDL function to concatenate static text with dynamic content, and also use the comma separator. Let's analyse this new example:

if(equals(variables('MyBoolean'),true),concat('Myboolean is ',variables('TRueString'),'.'),concat('Myboolean is ',variables('FalseString')),'.')

We built the expression with three dynamic contents selected from the dynamic content menu:

-the value of a variable called 'MyBoolean' of type boolean (true/false)

-the value of a variable called 'TrueString' of type string

-the value if a variable called 'FalseString' of type string also

Now, if() evaluates the following subexpression:

equals(variables('MyBoolean'),true)

THe output string when evaluation result is true will be the built by the following subexpression

concat('Myboolean is ',variables('TRueString'),'.')

THe output string when evaluation result is false will be the built by the following subexpression

concat('Myboolean is ',variables('TRueString'),'.')

Now on your original example, I would try with the following expression instead

if(or(equals(body('Reactiedetails_ophalen')?['r4cbf8f096147455892f186c764bea97e'],'Ja (later mailen)'),not(equals(body('Reactiedetails_ophalen')?['r8d63fc9bcd68461fa2fb5973eff4981f'],'Bestaand profiel verhuizen'))),concat('<br>De foto,"',body('Reactiedetails_ophalen')?['rd0d05f90684349108de6f5fb96f73d14'],' ',body('Reactiedetails_ophalen')?['r82d00fa06b164d8fb4ec01705f0a7e0e'],' - ',body('Gebruikersprofiel_ophalen_(V2)')?['displayName']),'')

Hope this helps

[Anonymous]

Wonderful! Learned something today thanks to you!