Hello everyone,
I have a gallery reading from a sharepoint list (Business_Partners). As this list maps 83x83 entities (each entity is maped to the other 82 entities) I created a little filter on the gallery to show this relationships. The user selects a country and the gallery displays all possible combinations (from the sharepoint list).
My issue is, when starting the app and selecting the Entity on the dropdown box (left), the gallery does not update unless I select an element from the Business Partner Combobox (right). The Gallery items are a filtered version of the sharepoint list, and such filtering is based on both selections:
"
If(
IsEmpty(Combobox_Destination.SelectedItems.Dest_Country),
Filter(Business_Partners, Origin = Dropdown_entity.Selected.Result),
Filter(Business_Partners, Origin = Dropdown_entity.Selected.Result And Dest_Country in Combobox_Destination.SelectedItems.Dest_Country)
)
"
I believe this is a performance issue and when I select a value in the combobox, Powerapps is "forced". If I select a combobox value and unselect it, the expected full list is showed.
Anyone have any idea on how to improve the performance? Or perhaps a different way to approach this?
Thanks!
