I'm creating a PowerApp that displays and allows users to navigate data from a SharePoint list. I've created multiple ComboBox Filters and a search bar, and they work fine, but I'm trying to improve them and running into few issues doing so. I've done my best to capture the problems below; please let me know if there is any more information or clarification I could provide that would be helpful. I appreciate thoughts or solution proposals to any of the problems mentioned.
Goal: I'd like to make the dropdowns populate with what categories that remain after all other search criteria (search input and other filter selections) have been applied.
Problems
Problem #0?: Most filters' dropdowns are populated (in the Items property) using the Distinct function, but there are a few that could only be populated using the Choice function, seemingly because a Record could contain multiple entries from each of these particular categories.
I've tried using the updating RecordGallery that displays the filtered Records as a data source for the filter dropdowns, but that always yields Circular Reference errors. Instead, I've tried manually reapplying the Search and Filter Criteria used to populate the RecordsGallery in the "Items" logic to populate each of the filter dropdowns.
Problem #1: This worked for this first ComboBox (let's call it ComboBox1), as long as I excluded the search of ComboBox1 to avoid Circular Reference, but when I tried doing the same for ComboBox2, not only could I not reference ComboBox2, but I could not reference ComboBox1 either without hitting Circular Reference. This pattern continued for the subsequent ComboBoxes. resulting in an implementation that created a sort of cascading effect where selecting an item from ComboBox7 would thin the options in previous ComboBox dropdowns (1-6), but selecting an item from ComboBox1 had no impact on the items in the subsequent dropdowns. Fortunately, all those that used this logic did update based on records that matched the search input (in the searched fields, different from the filter fields), but...
Problem #2: This logic only worked for the ComboBoxes populated using the Distinct function. Those that used Choices could successfully use this method as the function only takes on arg (e.g. Choices(source.column)) and neither replacing the "source" param with a wrapped Search function nor replacing it with a variable that was set to contain the results of said Search function worked. I settled instead to make those boxes searchable, which worked fine, but...
Problem #3: I could not make the ComboBoxes that used the Distinct function searchable, without their dropdowns suddenly becoming empty.
Share
Report
All responses (
Answers (
2,208