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.
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?
Community Support Team _ Phoebe Liu
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?
Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.
Register today for two amazing days of learning, featuring intensive learning sessions across multiple tracks, led by engaging and dynamic experts.
The European SharePoint Conference returns live and in-person November 28-December 1 with 4 Microsoft Keynotes, 9 Tutorials, and 120 Sessions.
We are excited to announce a new way to share your ideas for Power Apps!