What is wrong with this If expression?

[pepep]

if(body('Get_record_(Preview)_2')?['internalemailaddress']='peter@peter.com','360667578072','1')

I want to achieve that if the dynamic tag 'internalemailaddress' equals peter@peter.com then return 360667578072 else return 1

I get the message that it is invalid..

[v-xida-msft · Accepted solution]

Hi @pepep,

Could you please share a screenshot of your flow's configuration?

I think there is something wrong with the formula that you provided. The "=" operator is not supported within the expressions (WDL expression) of Microsoft Flow currently.

Please take a try to modify your formula into the following formula:

if(equals(body('Get_record_(Preview)_2')?['internalemailaddress'],'peter@peter.com'),'360667578072','1')

More details about using expressions within flow actions, please check the following formula:

Use expression in flow actions

More details about the WDL expression within Microsoft Flow, please check the following article:

https://docs.microsoft.com/en-us/azure/logic-apps/logic-apps-workflow-definition-language

Best regards,

Kris

[pepep · Accepted solution]

Hi @v-xida-msft,

Thank you so much! I've read the wiki on how to use the formula's and your suggestion did the trick.

Now extended it with a few more if-statements in the formula.

Lesson 1: read the f* manual 🙂

[Eirik1337]

This is expression is invalid in my Flow:

If(true, "OK", "Not OK")

Used in a SharePoint "Update item" text box.

[Vasco]

I'm sorry but it doesn't work with me.

if(equals(body('Obter_detalhes_da_resposta')?['Pergunta'],'10'), 'Yes', 'No')

or

if(equals(item()?['Pergunta'],'10'), 'Yes', 'No')

I get 'No' all the time.

I'm trying to get data from Forms.

Thanks.

[_Ken]

Try changing double quotes to single quotes.
if should be in lower case.

if(true,'OK','Not OK')

[_Ken]

Have a look in the OUTPUTS after running the flow.
Pay specific attention to if your variable returns 10 or '10'
Formula is comparing with the string '10' and not the integer 10

[LuisaCypPieper]

Have you found a solution for this @Vasco ?

I'm trying to do the same thing, using If to make a conditional using data from Forms

Desde já agradeço 🙂

[Vasco]

Sorry, I gave up.

Good luck.

[_Ken]

Try posting your formula and output from Forms here. Then we can have a look.

[LuisaCypPieper]

Hello Ken! https://powerusers.microsoft.com/t5/Building-Flows/Define-to-who-I-want-a-task-to-be-assigned-to-in-...

I've done this post, went a bit further from where I were in the beggining, but I still can't make him identify that Spain" (output) = 'Spain'

[_Ken]

I replied in your linked post.