Power Platform Community Forum Thread Details

I am using Power Automate Desktop and wanting to add a formula in to 1 of the cells of a worksheet. I currently have it opening the excel worksheet, but when i do a "Write to Excel Worksheet" action, i get an error "'IF' is an unknown or unsupported function". I know I can do formulas, so not sure what i am doing wrong. The formula is

=IF(ISBLANK(F2),"N/A", IF(H2<F2, "Yes","No"))

Thanks

Categories:

Power Automate Desktop

You have Power Fx enabled and that's why you cant just write the excel formula to the "Value to write" since it thinks you are writing a Power Fx function (that starts also always with equal sign).

Easiest way would be to just switch to not using Power Fx flow (create new flow where Power Fx is not enabled)
Or if you need to use Power Fx use Power Fx Text formula around the Excel formula:
=Text("Here the function")

So like this:
=Text("=IF(ISBLANK(F2),'N/A', IF(H2<F2, 'Yes','No'))")

EDIT:
This might work better:
If you need to have the double quotes then you need to put then twice everytime so that Text function doesn't think you end the text:

=Text("=IF(ISBLANK(F2),""N/A"", IF(H2<F2, ""Yes"",""No""))")