Skip to main content

Notifications

Community site session details

Community site session details

Session Id : fs7VYotwO9vKUrweDpwpgM
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

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Power Apps - Microsoft Dataverse

#1
stampcoin Profile Picture

stampcoin 17

#2
mmbr1606 Profile Picture

mmbr1606 15 Super User 2025 Season 1

#3
ankit_singhal Profile Picture

ankit_singhal 11 Super User 2025 Season 1

Overall leaderboard

Featured topics

Loading started