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
