I'm using the following in a Combo Box. It returns a list of names in alphabetical order (based on the Location chosen in another Combo Box). However, any new names added appear at the bottom rather than filling-in in alphabetical order. How do I update the condition so that all names, existing and newly added, always appear in alphabetical order?
DefaultSelectedItems: Filter(MemberCollection, Location=LocationComboBox.Selected.Title)
All content (every name) is present. However, the issue of all new names being forced - or defaulting to the bottom, still exists.
No, there is no errror showing. All name retrieved - just no shuffle. Also, the 'List' have also been aphlabetized by the FullName. I'm not sure why the Combo Box wants to then take what it alphabetized in the List and place it out of order in the Combo Box.
I even remade the Collection. No change.
Check out new user group experience and if you are a leader please create your group
Did you know that you can visit the Power Query Forum in Power BI and now Power Apps
Participate in the Power Virtual Agents Community Challenge
Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.