Unanswered

Annoying error message when hit with null data in a formula

(0) Share

Report

Posted on by Community Power Pla...

Hello Powerapps community,

How would one take care of data that is there only sometimes, but otherwise null that is inside a formula without recieving an error message in the app?

I have this formula:

And I tried this to get rid of the error message:

With no success.

The error message is a red bar that shows up at the top of the powerapp saying: "Expected a valid date value as the parameter to 'TimezoneOffset' function, recieved value: null.".

I am expecting the value null sometimes, but when I dont expect null, the I want to use the equation I am trying to apply (the first screenshot).

Any Ideas?

Thank you,

Shubhankar Singh

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (0)

Leo09 212 on at

Like (0)

Report

Hi @Anonymous,

What is your data souce when encountered this error?

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

The database being used is an SQL database

Was this reply helpful? Yes No
hpkeong 2,944 on at

Like (0)

Report

Hi @Anonymous

May you try:
ErrorMessage.Visible: If(IsBlank( A ), B, false).
Please add a false to ensure that it returns false and never show-up even it is nul.

If not, just remove the ErrorMessage box as it is useless to you.

Hope this idea works.
🙂

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

What is the A , B arguments???
Im having the same problem

Was this reply helpful? Yes No
sarmen01 2 on at

Like (0)

Report

I think this might be a new Problem. Im also getting the same problem, but my data is not a null.

Was this reply helpful? Yes No