Power Apps filter multiple selections - Exact or All options - Try again
HTML-код
- Опубликовано: 1 авг 2024
- 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 Apps Training at training.PowerApps911.com 
Наука
Who knew I’d get excited to see a video on PowerApps on a Tuesday morning. Awesome Shane!
Thanks Marco. Hope it was worth the excitement!
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!
Awesome Jeffrey. Keep up the good work of helping others. 🤩
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!
Awesome 😎
Finally we got "AS" !!! No more Disambguity or however you spell it!!! THANK YOU SHANE!
I am so excited about it! So excited 😆
@@ShanesCows Great video Shane. So from what I'm learning, would the As be applicable when doing a Patch? - Instead of renaming columns from ID to EID as I've seen in some videos? Fairly new to PowerApps but this seems great to make it more straight forward.
Inside a ForAll? Yes. 😻 I need to do a video
How did I miss this!?
Thank you for breaking it down - you make complicated stuff simple. Amazing!
The bonus stuff was 👌
Glad you enjoyed it!
I wasn't ready a year ago. NOW I'm ready!
thank you Shane ! our PowerApps Guru! another great class, valuable tips!
My pleasure!!
Great job, again. Thank you Shane!
You are welcome, glad you enjoyed it.
excellent, just what the doctor ordered. Love your videos.
Glad to help. 😀
I love you Man! Awesome video! Great help.
Glad it helped!
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!
Glad it was helpful! I love sneaking in little things. 😀
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!
I haven’t. Sorry. 😑
Thanks for the great video! Really helped me out :)
Glad it helped!
Top work very helpful
Glad to help Mark
Fantastic video. I've been struggling to find an equivalent for the SQL distinct. Thanks
Glad it was helpful!
thx. great job
Thank you too!
Hi Shane, This is brilliant, and working a treat. I have one question though, is there a way of excluding one of the column choices when you collect them on visible. So if I have documents of varying status, Draft, Issued, Archived, but I don't want the Issued ones to be a choice. Can I remove it from the collection?
Great video
Glad you enjoyed it
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!
I would run each option set separately. Then when you press filter loop through the data to make a new collection that has all of the results. An extra step but not much more complicated
@@ShanesCows I'm doing something similar where I need multiple filters and this is a great example (all videos you do are great). What I'm currently having a problem with is my colOptions (gallery with checkboxes). It is not getting all my values from my SharePoint list. On my Collection of Options button, it's a little different than your example, because I wasn't getting the values and when I did it was duplicating them, so this is what I've done: ClearCollect(colOptions, AddColumns(ForAll(Distinct(PIT, 'Contract Type'),LookUp(PIT, 'Contract Type' = Result)), "OptionName", 'Contract Type', "IsChoosen", true))
and I read that it could be a delegation issue because of the ForAll instead of Filter. Is that correct?
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... :)
Hey Rado - Your question does make sense but I don't have anything to share to help you. The App Checker has performance suggestions that may give you hints if you have unused things.
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!
Que I am not following. Sorry
@@ShanesCows Sorry, I mean if we can filter the items by multiple sets of options. In the example, you filter by item type, what if we add another option gallery, such as the last name. Then we have two option galleries. If we check Pet in the first item type gallery and check Young in the second last name gallery, how do we filter the item to show gallery to only display who are pets and last name is also Young (that will be Chewy)? I am building a report combining the techniques from this video and another one of yours, converting HTML to PDF. But my report requires many filters, such as manager name, location, year, and project type. I am wondering if we can add multiple filters. Hope it makes sense.Thank you so much!!!
Hi Shane, I'm new to PowerApps and and picking up a lot from your video's. Question how did you setup the Options Collections checkboxes. Can that options collections come from the column that's in the data source?
Maybe this video will help? ruclips.net/video/0xZ4fMJbLvk/видео.html
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?
Not sure Adi I need to think about this more. 🤔
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..
Let me check. ThisItem.LastName is my first label. Basically, any of the columns that you grouped by are available.
Reminder you can download the working apps by subscribing here training.powerapps911.com/courses/video-library 😁
@@ShanesCows Thanks. Think I tried the one ting that didn't work! Got it now. (ThisItem.LastName & " - " & ThisItem.CharacterType & " - " & CountRows(ThisItem.DATA))
Hi Shane, thank you for all you do in creating these videos for us novices to learn Power Apps! I have a question I have created an App pulling from SharePoint Data. I have created a search, and put the syntax between another filter in the gallery. The issue I am running into is that if I search in play, the search is not returning anything in the subfolders and documents within my top layer folders. This is the syntax I am using for the search.
Filter(
Search(
'Standard Operating Procedures',
SearchBox.Text,"{Name}"),
'Folder path' = varCurrentPath
)
Can you help?
This week video explains it actually. ruclips.net/video/iG8SjWtX1yM/видео.html 😎 Search(Filter is better
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).
I haven't done it before but I think you would have to incorporate an In operator of some sort to look for a match. Not sure.
Good night!
I need to store the history of changes made to items that are in a SharePoint list. These items are accessed through a gallery in PowerApps, when choosing the item to be changed, it is redirected to a form, where changes are made.
How can I collect the data (before the changes) of the item or items that have been changed and store them in a history column in the SharePoint list, this column will contain the date, time, name of the person responsible for the changes and data before the changes .
I appreciate your attention.
There is no easy answer here. 😕 You will have to create the logic to save the changes, mostly like to another list so you can piece it all together.
@@ShanesCows Good Morning!
OK thank you.
Happy and prosperous 2021
Hi Shane, I have asked the same thing in another video but that was old one, I just saw this one so I thought I might ask you here too.
Hi Shane, thanks for your amazing contribution to powerapps community.
Can you please tell me if i want to use lookup based on not one but
multiple conditions, how can I. I tried using && and "And" but I
keep getting error as possible invalied query. Can you please guide me.
LookUp(datasource, name = “Chewy” And Animal = “Dog”) is the syntax I use
Shane is it possible to filter based on a dropdown and a checkbox ( i can get each filter to work independantly on the Gallery) but cannot find a way to get if you choose option on dropdown filter that first then iif you check these boxes filter that second. I have watched your video PowerApps filter gallery by dropdown so i have a dropdown set up exactly like in that video and a checkbox set up exactly from this youtube I am just struggling in getting the gallery to filter against both. Any suggestions?
Two thoughts. If you want to use both you can do an And between them. Or you can do an If statement like the other video showed.
Hi Shane
Great video
I have an app which lists all of the buildings my company is in charge of (about 1500). Each building is zoned by city (11 citys). I have a gallery listing the citys as the first screen, then pressing the city goes to a screen with a gallery listing the buildings in that city so the user can scroll through them, and a search button at the top so the user can search instead if they want. When they click on the building , and it expands to show more details using gallery and text boxes including a launch function. Users can then also edit the building details using the patch function to update details if needed.
The issue is it is very slow (have to use Excel and dont have sharepoint access). There must be a smarter way to speed it up?
Sorry I am slow. Excel just isnt' a great data source. I talked about it a bit here. ruclips.net/video/RtmZM3tm2Zs/видео.html
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
I covered this in my latest video where I answer comments and yours was one of them. 😀 ruclips.net/video/8eoaSsXnh6Q/видео.html
@@ShanesCows Thank Guru !!! Greetings from Chile !!!
Interesting logic. Awsome! Hi Shane, User of my powerapps application request to me for reset ID in sharepoint list could back to 1 for every beginning years. Did you have any suggestion for reset ID back to 1 in sharepoint list? Thanks Shane.
Not possible that I know of
Hello Shane, I have a sharepoint list where there is a person column which allows multiple selection and it leverages the employee list of organization. I have a gallery in powerapp wherein data is to be filtered as per selection made in a combobox. What code can I write to filter items in gallery so that evenif there are multiple selections in sharepoint in person, all data is shown in gallery. I have seen multiple videos which shows how to filter items in gallery when we select multiple items in combo box but all of them are with single selection allowed in sharepoint list, here I only want to select one item in combobox but multiple selections are allowed in sharepoint list.
Hi Shane, i am watching your videos. It is very useful to learn powerapps very easily with your tips. I would like to ask about collections partitions. Like get set of records from collection (Set 1 has 10 records, Set 2 has next 10 records, Set 3 has last 10 records). Any help on this?
You can use FirstN to get the first few records.
@@ShanesCows Thanks for your reply. Another scenario like i am having custom gallery with more text fields. How required validation handled on each textbox inside dynamic gallery? It does not allow new row to enter values. Gallery is not created with sharepoint list data. This gallery is created for dynamic content. I have placed controls inside gallery and do binding operations like that. Any idea on this?
Hi Shane, Is it possible to have a dropdown containing your column headers that the gallery gets sorted by? I've tried ... ,SortByDropdown.Selected.Result, ... and selected.text too, with and without ""s but haven't had any success yet :( Thanks!
I haven’t tried but at a minimum you could do a big if statement to change the sort. 🤔
@@ShanesCows Ok thanks, I'll give it a go. It seemed to be a syntax error. Would be very interested if you find a neat solution to this!
Is there any way you can do a quick video utilizing Sharepoint data? I’m not understanding your answer to Jean-Francois below. Thanks!
I am not sure the difference for you. Put your SharePoint list into the collections I show in the demo and you should get the same result?
Hi Shane, would this work on Dataverse Multi-Select choices as well?
I would assume but I haven’t checked. But I do think so.
can you do multiple selections, within a sharepoint list? for example a status column, filter on 'in progress' and 'delayed,' or filter on 'completed?'
Replied to your other similar comment.
Hello Shane. There is any way to download the file for this specific sample..since.. after following all instructions i can't make my checkbox to work and i would like to see closely... thanks!!
Https://training.powerapps911.com and sign up for the curated library. You can download this and many other apps I have built. 🐶
I was wondering how to filter a yes and no choice in SharePoint for the gallery. I use the toggle function for a status. Do you know a way to make this work?
Do you have an Idea how do I add a column based from a Sharepoint list data?
hi, has you a Blog with a RSS Feed or so ?
Kind regards
I don't. Two options Patrick. 1 - You can subscribe to the RUclips Channel and turn on notifications to get notified when I post. 2 - You can sign up training.powerapps911.com/courses/video-library and you get an email when I post with more info about the video, plus downloads of the apps I demo, and you can even do Office Hours and join our monthly chats. 😍
@@ShanesCows okay thanks
I am really struggling to find a solution even after watching all your videos! I have (1) SharePoint list with a text column called "Region" that could contain Sydney or Melbourne or Sydney AND Melbourne (2) Power Apps Combo box to find any SPOL records that contain contains just Sydney or Sydney; Melbourne. I know you said DO NOT USE MULTI CHOICE columns in SPOL.....so I am stuck. Any tips or advice.....
You would have to Filter(SPOList, "Sydney" in ColumnName) that will do it but it is not delegable. 😑
Langage issues the ; in Clear();ForAll dosent work and i been trying with , : ;. no result any idea
If you are in a region that uses a , as a decimal separator then when i use a ; you need to use a ;;
@@ShanesCows Thanks Yepp itworks now :)
How kan ik use checkbox in powerapps voor delete
This might help? ruclips.net/video/xKXPmK00DCA/видео.html
Hi Shane Great tutorial! one question - do you create colItemsTOShow collection separately (ruclips.net/video/YYizaX6gXW0/видео.html)? Where does it come from?
Saw it. LOL :D
Glad you got it
Implemented SelectAll items in gallery. Reproducing one scenario - I click on Select All, So all Checkbox within gallery gets selected. Now i unselect one item in gallery. My requirement is how to uncheck the SelectALL Checkbox.
Make a button that does the opposite of the CheckAll. :) Set them all to false
First
🥰🥰🥰