Announcements
Hi,
I have a combobox that is populated with numbers that correspond to a location name. Is there anyway of using Switch of If to change the number to a location name but still have it filter the gallery by the number?
Thanks
Hi @jneuen ,
Assuming that in your data source you have both a LocationNumber and LocationName column (or whatever the name of the column are that have the location numbers and names in it), changing the DisplayFields (and SearchFileds) property of the combo box to ["LocationName"] should not impact any filter statements which reference combo box selection.
The source data doesn't contain the location name, tried a calculated column but that ran into delegation issues
In that case I suggest to use the AddColumns function in the Items property of the combo box:
AddColumns( NumberDataSource, "LocationName", LookUp( NameDataSource, NumberColumn = NumberDataSource.NumberColumn, Name ) )
This adds a virtual column to your data with the location name in it which you can use to display in the combo box.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Jump in, show your community spirit, and win prizes!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Valantis 431
WarrenBelz 360 Most Valuable Professional
Kalathiya 280 Super User 2026 Season 1
