Skip to main content

Notifications

Announcements

Welcome to the Power Platform Communities
Announcing Category Subscriptions!
News and Announcements icon
Power Platform Community / Forums / Power Automate - Power Automate Desktop / How to write a "=IF" f...
Power Automate - Power Automate Desktop
Answered

How to write a "=IF" formulate in the Value to Write of an Excel Flow

(0) ShareShare
ReportReport
Posted on by SM-20092000-0 6
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:
Process Advisor
  • Verified answer
    eetuRobo Profile Picture
    eetuRobo 2,574 on at
    How to write a "=IF" formulate in the Value to Write of an Excel Flow
    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""))")

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Welcome to the Power Platform Communities
Announcing Category Subscriptions!

Quick Links

End of Year Newsletter…

End of Year Community Newsletter…

Tuesday Tip #12 Start your Super User…

Welcome to a brand new series, Tuesday Tips…

Tuesday Tip #11 New Opportunities…

Welcome to a brand new series, Tuesday Tips…

more Community News

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 144,609

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,420

Leaderboard

Featured topics

Flows are not visible for users who sign in with their personal accounts
List of actions cheat sheet for Power Automate Desktop

Product updates

Microsoft Power Platform Community release plans