Announcements
Hello Powerapps,
I want to search a collection's column and see if there are blanks in columns or zero.
How Would I do this?
Thanks PowerApps,
AskingQuestions
This simple Filter formula should do the trick. If the 0 is a number and not text then remove the double quotes from "0".
Gallery > Items:
Filter('DataSourceName', 'ColumnName' = Blank() || 'ColumnName' = "0")
HI @Jeff_Thorpe,
I was hoping that this could be a boolean operator that I could put in a text label.
Sorry, I wanted it to give me true when there was not any blanks or zeros.
Thank You,
Is the text label showing the results of the collection. If so , then the label text property would look something like this:
If(IsEmpty(Filter('DataSourceName', 'ColumnName' = Blank() || 'ColumnName' = "0")), "True", "False")
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.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
WarrenBelz 358 Most Valuable Professional
11manish 214 Super User 2026 Season 2
Mohsin Ali 185
