Skip to main content

Notifications

Community site session details

Community site session details

Session Id : aZ4pBFw0pEhPL8OKM0Ga3W
Power Apps - Microsoft Dataverse
Unanswered

Fx column in model driven app using If statement gives an error

Like (0) ShareShare
ReportReport
Posted on 20 Apr 2023 19:19:59 by 4

I'm trying my first fx columns in a model driven app. The first columns worked fine now I try an if statement with date only fields. I wan to check if a field is blank to decide which value to show in the field. I am sure that the = blank() is wrong but what would be the correct statement to check if a field is empty?

If( 'Extended Warranty' = Blank(), 'Product Warranty Expiry', 'Extended Warranty')
  • AxelGsohn Profile Picture
    4 on 21 Apr 2023 at 10:34:36
    Re: Fx column in model driven app using If statement gives an error

    I found the cause for the error. It was in the field Extend warranty which is using the product warranty in it's formula and that causes the exception.

  • AxelGsohn Profile Picture
    4 on 21 Apr 2023 at 08:20:24
    Re: Fx column in model driven app using If statement gives an error

    Hi Lauren,

    thank you for the quick reply. I tried that way also but it always gives me an error. I get the slight feeling that there is something in the environment that is not correct. Just for the record I get the error only when using the blank or IsBlank in a different field I have a if statement and that works.

    The error is one of the brilliant kind: "Something went wrong. Please try again later."

     

  • LaurenWithers Profile Picture
    82 on 20 Apr 2023 at 21:01:23
    Re: Fx column in model driven app using If statement gives an error

    You can use The IsBlank function which tests for a blank value or an empty string.

    If( IsBlank( 'Extended Warranty' ), 'Product Warranty Expiry', 'Extended Warranty')

     

    Please thumbs up if it helped or mark as solution if it worked for you 🙂 

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

Quick Links

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Markus Franz – Community Spotlight

We are honored to recognize Markus Franz as our April 2025 Community…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,670 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 66,015 Most Valuable Professional

Leaderboard

Featured topics