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
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
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?
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
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!
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?
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
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