Notifications
Announcements
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
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.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
In our never-ending quest to improve we are simplifying the forum hierarchy…
We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
WarrenBelz 796 Most Valuable Professional
Michael E. Gernaey 327 Super User 2025 Season 2
Power Platform 1919 268
