How to filter multiple selection dropdown in Power Apps (Without Delegation Issues!)

Подписаться 586

Просмотров 15 тыс.

50% 1

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

Опубликовано:

6 ноя 2021

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 20

@moinamalek3059 Год назад

You have the hottest voice😍 I listen to it every night before sleeping

@lpdowdell 2 года назад

Love the 'soft' explanation without the fluff

@filiphruska4979 11 месяцев назад

Saved my life by showing me i can manually define the choices so than it will works in power apps

@nandnandan8313 Год назад

Bro this was amazing. I was searching for this on the entire web and you came to save us! Keep it rolling bro...

@adityadeshmukh3150 2 года назад

Simply Awesome...!! 🙂👍

@alexpena9419 Год назад

Thank you! This really helped me.

@guiabcbatata 2 года назад

Thanks a lot!

@punamkadam1760 2 года назад

Awesome video

@kizzasamuel4510 4 месяца назад

Thank you so much, I struggled with combo box multiple selection filters

@durgeshbait2875 Год назад

Thanks a lot

@santiagoalvarez1863 3 месяца назад

thank you

@natureshore 4 месяца назад

you are good. any more videos coming soon? salut!

@MrOwenjames24 5 месяцев назад

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

@danielschaupp3330 6 месяцев назад

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?

@mohitparmar1660 10 месяцев назад

How i do in SQL view Table in combo Box ?

@stayalive1017 2 года назад

What if you have 100 items in the dropdown do you have to hardcode everyone of them in the condition?

@Power-Apps 2 года назад

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.

@ming-nomadictrotter 2 года назад

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.

@Power-Apps Год назад

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!