Power Apps filter multiple selections - Exact or All options - Try again

In this video, we get nerdier than usual and explore how to filter multi selections with the help of ForAll and GroupBy. We also have a bonus lesson on breaking down a formula to show it complex to simple to help you better learn.

Sorry for duplicate upload. The first one wouldn't render in HD for some reason. This one does.

[Power-Platform]

Finally we got "AS" !!! No more Disambguity or however you spell it!!! THANK YOU SHANE!

[marcocruz]

Who knew I’d get excited to see a video on PowerApps on a Tuesday morning. Awesome Shane!

[louiscutmore]

How did I miss this!?
Thank you for breaking it down - you make complicated stuff simple. Amazing!
The bonus stuff was 👌

[tenisviejos]

Hi Shane; thanks for this new video. Undoubtly, this is the simplest, yet most powerful way to avoid name collisions and avoiding duplicates. It's brilliant, this will help a lot to simplify some complex formulas we have to use when filtering data. Thank you!

[jeffreymartin]

Great Job Shane! Really like your videos as it helps me explain things a little easier to my friends and colleagues I teach every other Saturday in what I have called Power Stack Saturday. Your videos help to add additional functionality into the Apps we build together...great inspiration! Thanks for sharing!

[susannejoest]

excellent, just what the doctor ordered. Love your videos.

[AdiCristea]

Better :). (1080p)
For the OR delegation issue (12:18), how would you solve the problem when there are more than 2000 items in your DB? My thought would be to have a true/false column in SQL which before the ForAll is set to false, within the ForAll loop that "!(ItemName...)" becomes "ThatColumn" and also if ThatColumn is false then Patch that record's ThatColumn to true (for next iterations). I know is not elegant enough and it's expensive, but if it was for a +2000 records how else would you do it?

[patrickcooley]

Shane, nice side-bar on the GroupBy function. I have used it but didn't fully understand what was going on...now I do. I also liked the AddColumn ending...helpful!

[maciejwitos]

I love you Man! Awesome video! Great help.

[pedroeleftheriou]

thank you Shane ! our PowerApps Guru! another great class, valuable tips!

[RadoDerdak]

Awesome. Hi, Shane. Some time ago, I had a customer complaining about the speed of an canvas app running on a tablet or mobile phone, and at that time I was looking for, among other things, memory optimization. Id didn't help :) cause it was more or less issue with architecture, but anyway...

Looking at your video and explaining the Add and Rename columns (exactly 26:01) - do you meybe have some information links/materials how PowerApps is managing memory in terms of cleaning memory for unused variables, collections etc?
In your example you have created 3 collections but using only the last one. So in terms of optimalization, PowerApps could clean up the memory and delete first and second collection.

Hope it make sence... :)

[gaetanoguy]

Hi Shane, have a question for you. Starting at the 8:00 minute mark in your video how can you set the “Filter any match” to use a data source from SharePoint and an Options Collection. For example, you select Dog, Chicken Young (OptionNames) in the Options Collection, and then the Gallery would show all matches from a SharePoint table with the same column call (OptionNames).

[jean-francoislafrance]

Hello Shane! Thank you so much for these videos, I find myself waiting anxiously each week as they are phenomenal!
I do have a question however... I need to filter through multiple Sharepoint Columns (let's say Geography, Sector and Funding Type). My "ColOptions" currently has the OptionName, IsChosen and an additional column called Type (which would be either Geography, Sector or Funding Type). I have 3 galleries where I've set up your patch for check and uncheck.
Would you suggest I create a new multiple line text column in my data source where I would concatenate any and all filterable values and run the Filter only exact match code? Or is there a more elegant solution?
Thanks in advance!

[pepex]

Hi Shane, great video !! I only have one question. I have many checkboxes on one screen1, which lead to another screen2, but when I want to cancel what I have on screen2 I also have to cancel the checkbox that I pressed so that it remains unchecked when I return to screen1.
I have tried various ways including collections, but I have not got the result I need =(

Greetings from Chile

[svenakkermans]

Thanks for the great video! Really helped me out :)

[messycook]

Is there any way you can do a quick video utilizing Sharepoint data? I’m not understanding your answer to Jean-Francois below. Thanks!

[HansMorano]

Hi Shane, would this work on Dataverse Multi-Select choices as well?

[paulbruen]

Hi Shane - Great video. Just one question. On your Group By screen under the gallery for colCharactersGrouped, what should go in the Text rows within the galley results? Thanks..

[queren]

Great video! Thanks for sharing, Shane! A quick question: if I have two option collections, for example, one for item type and one for last name, how to filter any match items or last names? Thanks very much!

[CharcoalBadger]

Hey Shane, your videos have been super helpful!. I was curious since you have so many videos if you ever did a powerapps filter a gallery by Month tutorial. I am going through your content hoping for some help towards it but to no avail. Great content as always!