How to filter multiple selection dropdown in Power Apps (Without Delegation Issues!)
ฝัง
- เผยแพร่เมื่อ 6 พ.ย. 2021
- In this video you will learn how to Filter a gallery with a Multiple Selection dropdown using Microsoft Power Apps.
The use case being able to filter a gallery of potentially thousands of rows with a multiple selection dropdown and being Delegable.
More Information on delegation here: docs.microsoft.com/en-us/powe...
This will be a step by step guide on creating the visual with it's logic so you may customize to your needs.
I'd love to hear feedback and suggestions in the comments.
More videos to come!
Let’s connect on social:
LinkedIn: www.linkedin.com/in/arslan-muhammad-a7a09a106
#PowerApps
You have the hottest voice😍 I listen to it every night before sleeping
Love the 'soft' explanation without the fluff
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
Thank you! This really helped me.
Simply Awesome...!! 🙂👍
Thanks a lot!
Awesome video
thank you
Thanks a lot
you are good. any more videos coming soon? salut!
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?
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!