Showing results for 
Search instead for 
Did you mean: 
Helper I
Helper I

Filter Formula Not working for all for all categories in a gallery



I have recently created an app that allows the user to select a certain division followed by selecting a specific category for the division that then leads the user to a list of sub-categories (with a link) that is correlated to that specific division and category. The formula I used for this process was: Filter(Table3_5, 'Category ID' = CategoryGallery_1.Selected.'Category ID', Division = DivisionGallery.Selected.Division). It was successful for all the divisions except for two of them; the subcategories list does not show up for these two divisions. Instead it leads me to a blank vertical gallery. I have tried exporting the data again into the app and nothing seems to be working. How do I go about resolving this issue? I have attached pictures below of my data and what my app should look like versus what is occuring when a user selected on the two unresponsive divisions.


Helper I
Helper I


Hi @Ryan_LaCroix ,

That's a little strange...

Are you sure the two situation filtered items not empty?

Do you have delegation warning?

Are the three tables' record's number larger than 2000?


Best regards,

Community Support Team _ Phoebe Liu


Community Support Team _ Phoebe Liu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi @v-yutliu-msft ,


No the two situation filtered items are not empty and I do not have delegation warning nor is my table larger than 2000. It is a strange situation, I have attached another picture with my data table that shows the records for the two missing items (FHP and FKC). I even tried moving around the data in the excel file and switching the ID number's of the two items but nothing seems to be working. Do have any other suggestions?


Helpful resources

Ignite 2022


Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Power Apps Africa Challenge 2022

Power Apps Africa Challenge

Your chance to join an engaging competition of Power Platform enthusiasts.

Super User 2 - 2022 Congratulations

Welcome Super Users

The Super User program for 2022 - Season 2 has kicked off!

September Events 2022

Check out all of these events

Attend in person or online, there are incredible conferences and events happening all throughout the month of September.

Users online (2,077)