PowerApps - Add an "All" to your Dropdown Lists - Dynamically!

[@zdeltap]

This was awesome. I used this concept on a combo box though but works like a charm. Thanks mate!

[@gauravguliani358]

Randy is the most skillful Power Apps person I ever came across Add to it the fact he loves helping and is so calm I truly miss working on Power Apps because it allowed me to be in touch with him Miss you Sir, wishing you good Luck

[@CSJMyDrive]

Spend hours to find this solution on internet. Finally found this video. Thank you.!!

[@tricacole]

Does it work in dataverse?

[@duythinh252]

Thank you Randy, your solution is very helpful. Especially the non-collection approach is exactly what I'm looking for!

[@gserrano1088]

Thank you so much! I was struggling greatly with my app and this just solved my 2 week headache! Greatly appreciated

[@Wessex_broadcast]

OH THIS IS SO MUCH BETTER THAN COLLECTIONS! THANK YOU

[@travman162]

Brilliant! I actually got this two work with TWO filters simultaneously, which is awesome. Now to add the Search feature in . . .

[@kyleyurkow1169]

How? Please explain

[@ASHISHKUMAR-fi2kn]

Thanks for the video Sir. I'm stuck in one scenario, I have a combobox which is connect to a data source and based on the item selected in that combo box items are filtered in gallery. I want to select all the items in that combo box automatically when the page load where the combobox is placed. How I can achieve that?

[@zerocool200380]

Hi Randy, this is great. a quick question : what changes we need to do if the choice column allow multiselect?

[@nonoobott8602]

Very insightful video. Thanks for sharing

[@federicovalencia8615]

Randy, how the script should be re-write if all the records were associated with, let’s say, a different “customer” ? In other words, in my gallery, when filter , it brings records associated with another customer. Hopefully I have explained correctly so you can guide me. Thank you

[@kamranpatel2998]

Hi how can we make it auto selected if its a check box control in which 'Select All' option is selected all options should get select in power apps

[@markm7013]

Exactly what I was looking for. Worked first time too! Thanks so much.

[@golababa1]

Great video! Helped me a lot!

[@janfranck5346]

Thank you, just what I needed and brilliant, too :)

[@venkatagavili6249]

Great video Randy How can I limit user from selecting ALL and also other values in a choice columns meaning - if the user selects ALL - they should not be able to select other values in choice list - it is a multi value selection field

[@FabianoSchimidt]

Hello Randy! Great video! I'm trying to adapt this solution to my need, but it's not working. My Dropdown control doesn't use the Choices function, its Items property has this formula: Distinct(Filter(Cursos;Habilidade=ddHabilidade.Selected.Result);Comportamento) "Habilidade" and "Comportamento" are two columns from the "Cursos" data source and there is a cascading lookup relationship between them. The ddHabilidade dropdown shows its values ​​depending on the value ​​selected in the previous dropdown which is linked to the "Comportamento" column. There are four possible options in the "ddHabilidade" dropdown and I need to add an "All" option before them. Do you think your approach can be applied in this scenario?

[@othmanekassaoui6978]

Hello! Can i add new choice in Dropdown list ?

[@antonioskokiantonis7051]

Awesome stuff!

[@cwwp8]

Any tips on getting this to work with a Salesforce datasource? Thank you.

[@tricacole]

Does it work in dataverse?

[@gcooper642]

It's difficult to work out what is being edited at certain point because the tree view is off screen.

[@ronbakker1300]

Hi Randy, would you consider making a video of when not to use a variable?

[@jamesanderson1925]

Hey, I can get the All option to display in the dropdown now but nothing shows in the gallery with the all selected. Using this: Sort(Filter('Book Club', 'calculated category'=Dropdown1.Selected.Value),Title)

[@randyhayes891]

Take at look at about 5:45 in the video. Your formula needs to account for the All - Your formula should be: Sort(Filter('Book Club', Dropdown1.Selected.Value="All || 'calculated category'=Dropdown1.Selected.Value),Title)

[@jamesanderson1925]

@@randyhayes891 Amazing! I had built a little internal library app where you can check out books that we have and they were categorized but I never got the All to work. Now it shows all books and you can narrow it down.

[@jamesanderson1925]

@@randyhayes891 I have one more question, how would this work if the calculated category is a multi select column?

[@gcooper642]

Thank you! I was so confused. I thought this was on the Dropdown, not the Gallery. That exact timestamps shows what is being editing. I've been going round in circles.@@randyhayes891

[@tamirysoliveira7915]

That was brilliant!

[@GeekUpdates]

How to add All to Multiple Select Combo Box?

[@ttttrigg3r]

Thank you so much!

[@pauloflaherty6757]

Nice video - content and production. I inherited some Apps that liberally use the Collection way of adding All/Any to dropdowns for filters and it is indeed a support/maintenance nightmare. Would be nice if there were just a 'Union' function to combine two or more tables of records - maybe they will get to that in another few years!

[@pasfoundation4927]

Stupendous. Thank you.

[@prajwalskateel]

Wow,, this was really good,, thank you

[@dimadubnevych9164]

Well. it seems to be too difficult as for such common situation. Again we face with a low-code solution which should make life easier, but instead stuck at the first common case and need to google it

[@PowerAppsGuruThailand]

Thank you, good contents.

[@reginaldoelgueta9061]

Great, excellent video regards

[@vishnuraju1901]

Thank you so much

[@andredoestech]

I wish he would show his whole screen and stop zooming in

[@1966rapunzel]

Sorry Andy it's 2024, 18 minutes isn't a Quick Tip

[@doja3527]

Too fast and not well explained. Nothing for beginners. 😢

[@jae13204]

Too fast.