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
With a little tweaking I was able to make it work with the Choices option in the variable. When I tried Distinct and made the necessary changes it wouldn’t work. Also with the “All” option I got a blank line then All followed by the items in the column. If you selected “All” the results were blank. If the option was left blank I got all entries. I replaced “All’ with Blank() and that worked just fine. Thanks for the video it was a GREAT help!!!
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?
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
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?
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
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)
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)
@@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.
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
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!
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
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
Thank you Randy, your solution is very helpful. Especially the non-collection approach is exactly what I'm looking for!
Spend hours to find this solution on internet. Finally found this video. Thank you.!!
Does it work in dataverse?
This was awesome. I used this concept on a combo box though but works like a charm. Thanks mate!
Thank you so much! I was struggling greatly with my app and this just solved my 2 week headache! Greatly appreciated
With a little tweaking I was able to make it work with the Choices option in the variable. When I tried Distinct and made the necessary changes it wouldn’t work. Also with the “All” option I got a blank line then All followed by the items in the column. If you selected “All” the results were blank. If the option was left blank I got all entries. I replaced “All’ with Blank() and that worked just fine.
Thanks for the video it was a GREAT help!!!
OH THIS IS SO MUCH BETTER THAN COLLECTIONS! THANK YOU
Exactly what I was looking for. Worked first time too! Thanks so much.
Brilliant! I actually got this two work with TWO filters simultaneously, which is awesome. Now to add the Search feature in . . .
How? Please explain
Hi Randy, this is great. a quick question : what changes we need to do if the choice column allow multiselect?
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?
Thank you, just what I needed and brilliant, too :)
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
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?
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
Any tips on getting this to work with a Salesforce datasource? Thank you.
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
Very insightful video. Thanks for sharing
Great video! Helped me a lot!
Hi Randy, would you consider making a video of when not to use a variable?
Does it work in dataverse?
Awesome stuff!
Hello! Can i add new choice in Dropdown list ?
Stupendous. Thank you.
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)
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)
@@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.
@@randyhayes891 I have one more question, how would this work if the calculated category is a multi select column?
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
It's difficult to work out what is being edited at certain point because the tree view is off screen.
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!
Thank you so much!
That was brilliant!
Thank you so much
Thank you, good contents.
Wow,, this was really good,, thank you
How to add All to Multiple Select Combo Box?
Great, excellent video
regards
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
I wish he would show his whole screen and stop zooming in
Sorry Andy it's 2024, 18 minutes isn't a Quick Tip
Too fast and not well explained. Nothing for beginners. 😢
Slow down
Too fast.