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?
Check out the News & Announcements to learn more.
Did you know that you can visit the Power Query Forum in Power BI and now Power Apps
Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.
DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.