Unanswered

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

(0) Share

Report

Posted on by AxelGsohn

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')

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (3)

Answers (0)

LaurenWithers 82 on at

Like (0)

Report
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 🙂

Was this reply helpful? Yes No
AxelGsohn 4 on at

Like (0)

Report

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."

Was this reply helpful? Yes No
AxelGsohn 4 on at

Like (0)

Report

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.

Was this reply helpful? Yes No