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
Solved! Go to 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?
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?
Thank you @timl
Very impressive, wish I could give you more kudos.
Pity that we have to do these things with work-arounds though...
Glad you found that useful! Yes, it's a pity about having to use these work-arounds.
User | Count |
---|---|
175 | |
111 | |
86 | |
44 | |
42 |
User | Count |
---|---|
229 | |
118 | |
116 | |
74 | |
67 |