web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Model Driven Power App...
Power Apps
Unanswered

Model Driven Power App Grid Header Filter Is Not Treating Zero as a Legitimate Value

(0) ShareShare
ReportReport
Posted on by 4

I have built a model-driven Power App for a client. I am making extensive use of subgrids and the Power App Grid Control. Testers report that they are unable to use the column header filters on grids to filter numeric columns for values equal to 0, which is a legitimate value these columns can have. They reported it on a calculated currency column, but I have also seen it on rollup whole number columns and simple currency columns. The problem also applies to the other filter operators (less than, less than or equal to, etc.).

 

The screenshot is from a simple demonstration app I created in a non-client tenant, but it shows the same behavior the client is seeing. The filter does not consider 0 a legitimate value to filter on, even though it is a legitimate value for the column to have. This example is on a primary table grid, so it's happening even when I'm not using the Power Apps grid control on a subgrid. The record MP-1000 has a Model Price of $0.00.

 

This behavior does not happen when I edit the filters on the view; I can filter on values equal to 0 there. It's only on the column header filters on subgrids and primary table view grids. Update: On subgrids, it only happens when viewing the subgrid using the Editable Grid or Power Apps Grid components. When viewing it as a read-only subgrid, the column header filters accept zero as a value. 

 

How can I get the column header filters to recognize 0 as a value on a numeric column? Thanks!

 

Screenshot 2023-11-13 172939.jpg

Categories:
I have the same question (0)
  • mslater28 Profile Picture
    2 on at
    Re: Model Driven Power App Grid Header Filter Is Not Treating Zero as a Legitimate Value

    We are getting the same error trying to filter a number column using any number, not just zero.  Were you able to solve this issue?

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.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 836 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 327 Super User 2025 Season 2

#3
MS.Ragavendar Profile Picture

MS.Ragavendar 231 Super User 2025 Season 2

Last 30 days Overall leaderboard