How to differentiate between zero-length string and null in data source?

[Meneghino]

IsBlank("") returns true, so how can we differentiate between "" and NULL in a data source text field?

Many thanks for any input.

PS If you have similar issues, please vote up this idea:

https://powerusers.microsoft.com/t5/PowerApps-Ideas/Function-to-produce-blank-value/idi-p/14353

[timl · Accepted solution]

Hi @Meneghino,

I notice that the CountA function enables you to count non null values.

With my SQL Server data source, I'm able to distinguish between blank and null values using syntax that looks like this:

CountA(Table({NullTest: <StringToCheck>})

Maybe you could try something similar?

[Meneghino]

Thank you @timl

Very impressive, wish I could give you more kudos.

Pity that we have to do these things with work-arounds though...

[timl]

Glad you found that useful! Yes, it's a pity about having to use these work-arounds.