web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps If IsBlank formula not...

Power Apps

Answered

If IsBlank formula not behaving as expected

(0) Share

Report

Report

Posted on by Daniela

13

I have a patch function which should write in a Sharepoint List the value for "Compiled" if it is not blank, or the value for "Median" if else.

I wrote the following statement for the patch:

Patch(results;First(Filter(results; ID= compiled_ID ) ); { evaluation: If(IsBlank(compiled);median;compiled)})

For some reason, it only works on reverse:

Patch(results;First(Filter(results; ID= compiled_ID ) ); { evaluation: If(Not(IsBlank(compiled));compiled;median)})

Does anyone have an explanation for this? Is it a known bug?

Thanks!

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

GarethPrisk 2,828 on at

Like (0)

Report
Copy link

Link copied!
It may depend on the column type, and what value it may have within it. There are scenarios where a string like "" is actually there, and that's not actually a blank value.

Another option, is to leverage Coalesce (which uses first non-null value).

Patch(results;First(Filter(results; ID= compiled_ID ) ); { evaluation: Coalesce(compiled;median)})

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-isblank-isempty

I have seen some mixed behavior with IsBlank, IsBlankOrError, etc. but it's usually traceable (i.e. has a reason for not working - maybe data mismatched, data source varations, etc.). It's definitely preferable to having to write complicated statements to get the output you want.

Was this reply helpful? Yes No

Join the conversation