Do you know how you could create this but the gallery only displays items which consist of all selected values. E.g., I have a column which is multiple selection and contains IT, Finance, Marketing on a single item. I select, IT, Finance, and Marketing in the filter - I only want to show items with all 3 values
How would you do it if for example Peter Parker works in multiple areas (more than 1 choice) in your sharepoint database. Would the filterprograming be different?
Hey Ernesto thanks for the question! Unfortunately the only way I know of avoiding delegation on this multi selection dropdown is to hardcode everyone of them using the FirstN-Last approach. An easy way to create a long version of the formula is to use excel.
Yes I completely agree! However, this is the best method I've found to enable delegation for filtering the combobox with multiple selections. One way to future proof it is to write more of the function to prepare for future additions. Thank you for watching!
You have the hottest voice😍 I listen to it every night before sleeping
Love the 'soft' explanation without the fluff
Finally a good solution!!!! Thanks man!!
Bro this was amazing. I was searching for this on the entire web and you came to save us!
Keep it rolling bro...
Saved my life by showing me i can manually define the choices so than it will works in power apps
Thank you so much, I struggled with combo box multiple selection filters
Simply Awesome...!! 🙂👍
Thank you! This really helped me.
Thanks man 🙏🏽
Thanks a lot
Awesome video
Do you know how you could create this but the gallery only displays items which consist of all selected values. E.g., I have a column which is multiple selection and contains IT, Finance, Marketing on a single item. I select, IT, Finance, and Marketing in the filter - I only want to show items with all 3 values
Thanks a lot!
How would you do it if for example Peter Parker works in multiple areas (more than 1 choice) in your sharepoint database. Would the filterprograming be different?
you are good. any more videos coming soon? salut!
thank you
How i do in SQL view Table in combo Box ?
What if you have 100 items in the dropdown do you have to hardcode everyone of them in the condition?
Hey Ernesto thanks for the question!
Unfortunately the only way I know of avoiding delegation on this multi selection dropdown is to hardcode everyone of them using the FirstN-Last approach. An easy way to create a long version of the formula is to use excel.
This doesn't seem sustainable if new selections will be added in the future. It means that the filter will have to be edited as well.
Yes I completely agree! However, this is the best method I've found to enable delegation for filtering the combobox with multiple selections.
One way to future proof it is to write more of the function to prepare for future additions. Thank you for watching!