If Equals

[sjordyn]

Hello Everyone, 

I have been working with PowerBI for a few years but I am not great with expressions and equations. 

This is a very large flow so there would be too many screenshots but to give you an idea here is my workflow. 

The information is gathered in Microsoft Forms --> then added into an Excel --> and then sent out in an email. 

Few things to note: There is a question in the form that asks if there a "change fee -yes or no" ; if yes they enter an amount.

CF = Change Fee

This is the current formula that I am using but the change fee isn't always 50.00. In general terms, if there is a change fee I want to replace the 50.00 with Change fee amount entered in the form (to then be put in the email)

**Note above this equation I do have a compose to format the change fee amount into a number format. 

I have tried the following (and a few other combinations) but I get the message "expression is invalid". I think I am missing something in the formula but just cant figure it out. 

if(equals(body('Purchase_Add_Row')?['CF - Y or No'], 'yes'), '0.00', 'outputs('CF_Base')')

if(equals(body('Purchase_Add_Row')?['CF - Y or No'], 'yes'), '0.00', '(outputs('CF_Base'))')

if(equals(body('Purchase_Add_Row')?['CF - Y or No'], 'yes'), '0.00', 'result(outputs('CF_Base'))')

I know this probably could be done as a condition but there is multiple different things (change fee, or cancellation fee, etc.) and I already have enough conditions I don't want to over complicate the flow. 

Any help would be appreciated. 

Thank you, 

Samantha 

[SudeepGhatakNZ · Accepted solution]

@sjordyn 

You dont need the single quotes, try

if(equals(body('Purchase_Add_Row')?['CF - Y or No'], 'yes'), '0.00', outputs('CF_Base'))

[Nived_Nambiar]

Hi @sjordyn 

One question- so when charge fees is equal to no- you want to value of expression's output to be 0.00 ?

Thanks & Regards,

Nived N 🚀

LinkedIn: Nived N's LinkedIn
YouTube: Nived N's YouTube Channel
Blog: Nived Nambiar's Blogs

🔍 Found my answer helpful? Please consider marking it as the solution!
Your appreciation keeps me motivated. Thank you! 🙌

[sjordyn]

Thank you! 

I swear I tried that before posting but I am assuming I may have had a ' or , or ) in the wrong place. 

The above was super helpful -- thank you!