PowerApps Multiple Filters on Gallery
Вставка
- Опубліковано 24 лип 2024
- #PowerApps #GalleryMultipleFilters #GalleryFilters #MultiSelectFilters
In this video on PowerApps Multiple Filters on Gallery, we will go through a step-by-step tutorial of applying multiple filters to PowerApps Gallery control. We will apply multiple filters of type text, date, dropdown, combo box, checkbox, multi-select combo boxes etc.
I will also showcase how to get around the default select item issue with Gallery so that you can have all items displayed when no filter is applied and filter the galleries based on multiple filters once filter is applied.
We will leverage both Microsoft Dataverse (CDS) and SharePoint as a data source in this video on How to apply Multiple filters on Gallery in Power Apps.
Video covers the following:
✅ Multiple filters for Gallery
✅ Search function and filter function
✅ Filter based on single select combo box (acts like a dropdown control)
✅ Filter based on multi-select combo box
✅ Filter based on multi-select checkboxes
✅ Filter based on date range
✅ Reset filters
Links:
Delegation documentation - docs.microsoft.com/en-us/powe...
My delegation playlist - • Power Apps Delegation ...
Table of Contents:
00:00 - Intro
00:42- Data source schema - Dataverse table
01:07 - Search on text column
02:30 - What is Delegation?
03:45 - Filter on Choice column (single-select filter)
06:26 - Show data when no filter value is selected
08:26 - Add a second filter using comb box choices
09:41 - Filter on Choice column (multi-select filter)
11:40 - Filter on checkbox selections (multiple)
14:28 - Filter based on date range
16:15 - Reset filters
17:36 - Apply multiple filters with respect to SharePoint as a data source
thank you Reza, your isblank or is empty is gold. Before this I wrote nested if statements to check for all possible combinations, so if I had three combo boxes, ended up with a huge complicated nested if statement. Very elegant, now I need to refactor lots of code. Thank you
Excellent! So happy to know that the techniques showcases are valuable. Yes, time to refactor code :)
that is what I started doing too.
I usually battle with Nested statements, especially when it comes to filter & search functions. You are saving a lot of lives with this video Reza. This is like a VACCINE for our Filter virus. I appreciate you.
Wow! These are some really amazing compliments. Thank you. The world definitely needs a Vaccine.
Thank you!
So many helpful tips in there, thanks Reza. Every week I am learning so much from you! I never realised the need for checking isblank and isempty! In regards to search not being delegable in SP, what I have done in the past when the datasource is small enough is imported that into a collection then used search.
Firstly, thank you for the fantastic feedback.
Collections are all held locally in memory. There are always delegation challenges which one needs to be aware of.
Thank you for watching.
You have an amazing knack for teaching. You pick nice examples to demonstrate and provide information to the point. Good job and Thanks
Thank you for the amazing feedback.
There we go! Yet another video with amazing information by Reza. Before this, my filters where huge because of several nested if statements. Thanks a lot.
Thank you Juan. Hopefully I have simplified the process of applying filters :)
i second that!...thank you Reza
Thanks for all your continued help on my powerapp journey. Most of the best practices I have learned have come from you!!!
You are so welcome!
This is the single most useful power apps video I've seen. Thank you, Reza! Great explanations.
Wow! Thanks so much.
Master piece. Thank you Reza as always.
You are most welcome
That moment when Power Apps slaps on my face but Reza publishes a video to save me! :) Always thankful to you. May God bless you and help you in all your life. You are surely helping a lot of people.
Thank you 🙏
Thank you so much, again! Great videos for beginners, intermediate and advanced users.
You are most welcome!
Thanks Reza, you're a life saver! I spent days on this actually. Now my tasks is done...
Thanks!
Brilliant solution on filters. Followed the steps and have used these with ease and would like to generate the output in form of charts. In anticipation of your ultimate guidance. Thank you.
Output in form of charts? There is no direct action for that. You could call a flow and send your filtered data and then generate an excel file from it.
Thanks for another great video! This helped me solve a filter issue that was driving me crazy all week.
Glad it helped!
Great Video Reza! Like the layout too. thanks for the tip on filtering. worked a treat
Awesome! Thanks for watching.
Oh my god, you're a legend.
I am building a mobile app for my uni project, and you have hugely saved my life.
Can't thank you enough Reza.
Thank You for your kind words.
I am no legend. I am just a content creator.
@@RezaDorrani Humble really you are, but please know that your videos mean a lot to people like me. Thanks again.
@@lk43wz You are most welcome.
@@RezaDorrani No, seriously, you are a legend.
@@aprilmills5925 🙏
This video is God-sent! Thank you so so so much!
You are most welcome. Welcome to my channel :)
Sir, this is Great!!! I used to waste so much time in long and conditions doing multiple filters
Great 👍
Another great video Reza, keep up the good work. I will be using this method for filtering data in the future. again great work👍
Thank you
Hi Reza, this is so cool. I have watched so many videos, but this one is ultimate! Learned so much, thank you!
Happy to hear that!
Learned a lot about powerapps filter usages, Thanks!
Great to hear!
MAN I DON'T Know how many times you saved my Power Platform daily Life....THANK YOU MAN!
You are most welcome!
Thanks for this video Reza, very useful as always!
Glad to hear that! Thanks for watching
Those tips are lifesavers. Second time this video saves my ass with the Sharepoint filter. Thank you very much Reza!
Most welcome
Another great reference video, thank you Reza.
Thank you Ron
Thank you for demystifying gallery filters for us Reza. It is such a core piece of every app, but can be confusing knowing how to nest Search, Filter and SortByColumns in a Gallery Items formula.
You are most welcome. Your feedback was exactly the goal of my video.
Awsome !! Thank you for this video, I was affraid that I would need very complexed "If" for my multiple filters in my App and with this solution it's nice and easy.
Glad it was helpful!
This content was helpful for my project confused on whats acceptable in SharePoints and thabks you showed how to choose the right funtion for data value.
Most welcome
Absolute legend. Well done!
Wow! Thanks.
Dear Reza, apart from your explanation and the way of presentation, I am a big fan of your fluent speaking and crisp n clear pronunciation! I wish I could achieve that expertise one day :)
Thank You. If I can do it, anyone can.
Reza, thank you so much! Your job is excellent! Congratulation👍
Most welcome! Thanks for watching and liking the videos
Fantastic video, thank you Reza!
Most welcome and thanks for watching
Thanks a Lot !!! Great Content !
Thank You for watching.
Great video. Extremely userful!
Glad it was helpful!
This helped me so much. Thanks for your amazing videos!
You're so welcome!
you sent me enlightment after 2hours of trying to filter Sharepoint List - thank you Reza :-)
You are most welcome
Thanks Reza, you're my Power Apps Super Hero.
🦸♂️ Thank You :)
This is awesome! Your videos are the best, and I love the way your screens look. Is there a video that explains how you set up the original gallery with the 3 column, shading, etc.? It would be a basic video, but if you have it, I would love to see it. I looked but couldn't find it among your videos. Keep the videos coming!!!
Thank You so much :)
Here is my Gallery design video ua-cam.com/video/bnC8u3gdWss/v-deo.html
It also has link (in video description) to look at the sample App which includes multiple designs.
You are the Goat Reza! thanks for this one
My pleasure!
Excellent tutorial sir. You solved a problem I was having with syntax, and although it is still a little illogical, you gave some pointers on how to solve my particular issue. Kudos
You are welcome!
Awesome Reza ,,,, you make things so simple ... thank you ..
Thank you very much
Reza, the videos you upload are extremely helpful!
Thank you!
(not a native speaker myself and I love the way you pronounce "Data Worse"! :-) )
I keep trying to improve my pronunciation :)
@@RezaDorrani No! Don't! It's yours, and it is part of you!
@@DinosKonstantinou Ok. I will stick to my pronunciation style :)
As always, fast and simple explained. Thank you for the delegation input, that causes a lot of trouble. I wonder why SharePoint is still not delegable for many functions.
Thank you for sharing with us
Most welcome!
Thank you Reza, you're the best!!! You solve my problem 😅
Glad to hear that!
This is what im looking for.thanks 🤩🤩🤩
Glad it was helpful
thank uuuuuuuuuuuuuuuuuuuuuuuuu such a beautiful tutorial
You’re most welcome
Hi Reza, great video. I like your IsBlank and IsEmpty conditions. Awesome 👌
Thank you
Hi Reza, thank you so much for the amazing videos! I've started a career in power app development which you videos have played a massive part in. When using dataverse I am still getting a delegation warning using the in function when using lookup fields - is this expected? The in function works without delegation on text fields.
i.e this works: Filter(Table, TextColumnType in Filter.SelectedItems)
but Filter(Table, LookupColumnType in Filter.SelectedItems) has delegation warnings
Not all column types are delegable with IN function. Lookups is one of them. Hopefully, it would be in future.
thank you very much sir for all the explanation
You are most welcome
absolutely loving your videos.. they are very helpful... keep up the good work.
i am trying to program the gallery view to show data according to the following conditions,
Thank You.
Amazing video ! Thanks a lot
Glad you liked it!
You Rock! Thanks for your efforts
My pleasure!
Thanks Reza always excellent videos
Glad you like them!
Hi from the future😊😊. Top videos as always Reza thanks for all you do.
Glad you like them!
Great info, I only wish I had come across this sooner.
Better late than never :)
Welcome to my channel
Great, as always
Thank you! Cheers!
Good day Reza, you are reading my mind. I was struggling with multiple filter since 3 days, where I could not find the right way online. Finally I achieved the result, but as usual, will adopt your way 😂🤣😂🤣
My videos are now based on subscriber requests. I feel I am following the pulse of my audience.
So Audit Check List is on your Pipeline? 😉
@@ehabatme5324 I need multiple folks to make similar requests 😊
Loveeeee ittttt!!!!!
Thank You
Thx for sharing!!! Very helpfull!!! Greetings from germany Christoph 👏 👏 👏 👏 👏
Glad it was helpful! Thank You!
Very nice and useful!!!
Thank You
extremely helpful, thnx a lot
Thanks for watching
Thanks a lot sir ,you are great
Thank You 😊
This is amazing!
Thank You
Nice way to solve multiple filters, and great video 👌👌👌👌
Thank you! Cheers!
I love great videos! :)
Thank you!!
Thanks for your video!! It helped me a lot. Is there a way to default check some checkboxes, for example: when going to this screen "Not started" and "In progress" are default checked? I tried with a If statement, but then the filtering does not work anymore. Thanks in advance!
Possible. Set the default values on App load in the collection which gets updated when checkboxes are checked or unchecked.
thank you Reza! the watering be multiplied to you!
Thanks Kyle
Awesome stuff
Thanks
Hi Reza, Thanks so much for the great video. I have a list with a column that allows multiple values (characteristics like SEO, SEA, FBAds, ...). I used your filter logic with a combo box but don't get any results. I suppose it only works for columns with one value? Is there any way I can filter for one or more matching charateristics that are n this column (eg. SEO or FBAds)? Thanks so much angain!
I do not have a video scenario on multiple-select values.
I will recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.
Hello Rex’s, quick question, am I able to add another 2 search boxes, and concurrently filter all rows based on searching specifics on several “Text” type columns? For example, searching “Project” instead of Name (in the case of this demo), then having another search box for Project Owner, Email, and more?
You can add multiple filters and combine them with OR and AND operations as shown in video.
I will have to look at your App in action in case you are running into issues to provide guidance. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
Thank you sooo much
You are most welcome
Thank You Reza!!!! This is amazing! I had a question though, what if i have multiple text filters along with combo box filters, how do i write the multiple search functions? any tips at all will be appreciated.
Search function with SharePoint is not delegable. I would not recommend using it if your data source is SharePoint.
Thank you so much for the detailed explanation. How can I search based on the Created By column on the sharepoint list in addition to few other text fields.
Search function has delegation issues with SharePoint.
But you could add filters for Person column as well. Check - ua-cam.com/video/tPxE_-DcWkg/v-deo.html
Thank you Reza, your workarounds are always fantastic! One question I need some help with, I know that Microsoft is already working on app certification to certify apps created by ISVs.
But for now us there a way/workaround that I can use to sell a solutions built on PowerApps with a subscription model, like USD1 per user per month. Given that I will have access to build the backend on the client tenant?
It would be an amazing solution till Microsoft finalize this.
I have never tried publishing Apps to App Source so I am probably not the best person to answer this.
App Source -
To list on App Source - appsource.microsoft.com/en-us/partners
appsource.microsoft.com/en-us/marketplace/apps
Quick question (I hope). I did the date filter for my gallery utilizing the Modified date from a SharePoint list. It works great except if you pick the same date as the listed item in the gallery. Even though the code says less than or equal to, it doesn’t seem to do the equal to. If I select a date that comes after a listed date in the gallery, the item appears just fine. Is there something I’m missing here? Also thank you so much for everything you do. You’ve saved me so many times with your videos!!
This is related to Power Apps working in UTC for dates. Also the time component comes in play.
I will plan a video on this in future.
Reza, great content thank you! How do I create gallery that is grouped by section so that if I click one of the sections, it will open new screen at the top of that section but expanded to show sub items, while still letting me scroll up to previous sections or continue to next section and subitems?🤷♂️
That would be quite a lot of work - Group the data, then create sections of data based on group, then showcase them inside gallery and also provide add row on top of section.
I would have to spend a good amount of time to see the possibility and test it out.
Also, there will be issues related to delegation.
Check out 1 video I found on this topics - ua-cam.com/video/Qfer3DwjfwA/v-deo.html
Thank you so much for the lessons in this video Reza, I found it very helpful. I do have a question though, at 10:39 you demonstrated a way to bypass the delegation warning through the setting by using Dataverse. Is there any workaround to bypass delegation warning for Sharepoint List?
No workaround for SharePoint yet.
As always, a great video! Thanks so much!
Glad you enjoyed it!
A life saver video
👍 👍
Reza. Thank you so much for the work that you do! Your videos have giving me the skills to create a new job for myself at my company. In regards to this video, I got all the filtering to work in PowerApps/Dataverse for Teams. I’ve tried for hours to figure out how to have some of the checkboxes checked, as a default, rather than all being cleared. With the reset button I thought I could clear the collection and then make a new collection with just the choices I wanted checked, but can’t seem to get that to work. Do you have any advice? Thanks again!
For anyone interested, I was able to figure this out using another one of Reza's videos on Dataverse Choices columns ua-cam.com/video/Cu8pDo6WpRI/v-deo.html. In making the collection the name of the choices group and the selected choice must be included in the code, rather than hardcoding text. For example, Collect(colJobStatusFilter, {Value: JobStatusChoices.'Not Started'}), rather than Collect(colJobStatusFilter, {Value: "Not Started"})
Thank You so much for liking and following my videos.
I will have to look at your App in action to know the exact issue. All you would need to do is load the collection with default values on click of Reset. I would recommend you post your issue/query with screenshots on the forums at powerusers.microsoft.com
Thanks for sharing
Thanks for your work Reza, I have a question about using the "in" operator in the other direction. I'm trying to use a choice drop down component to filter if the selected value is IN a multi-choice column in Dataverse. I can only get it to work right now by using the Field.Value reference which is giving me a delegation warning. It seems like it SHOULD work using dropdown.selected in Field but that doesn't work at all.
Not sure I understood the question.
Check ua-cam.com/video/Wr42PeW6_wU/v-deo.html for multi select choice columns
@@RezaDorrani Hopefully I can clarify the question. In the video you linked you are doing a filter using a multi-select combobox and checking if those values exist IN a multi-select field. You clarify in the video that this WILL cause delegation issues due to the ForAll() function you need to use to execute that check. What I'm trying to do is check if a SINGLE item from a dropdown is IN a multi-select choice field. When I attempt to do this the filter seems to not work at all (the gallery just stays blank). Filter(MyTable, DropDown.Selected in MultiChoiceField). If I change it to Filter(MyTable, DropDown.Selected in MultiChoiceField.Value) it works but I get the delegation error.
@@anthonypriest6726 I will have to see your app in action to know the reason why your gallery is blank. I will recommend posting your issue with screenshots on the forums at powerusers.microsoft.com
Another great video Reza. Thanks. I do have one question and that pertains to the Gallery you created. How did you create a gallery that goes left to right and down? Do you have a video to demonstrate this? Thank you.
Thank you.
Yes, I do have a video - ua-cam.com/video/bnC8u3gdWss/v-deo.html
Video description includes link to download sample App as well.
Hi Reza!
First of all, thank you for incredible content, as always!
I just wanted to ask you a question - when I use the checkbox from a gallery and Collect to fill out a collection, the performance gets crippled and the app glitches out and when I unselect an item, it doesn't always remove it...
Do you have an idea on how to avoid this?
Also, I cannot see to use Choices from a collection, but only directly from the SP list - is this by design or am I missing something?
Thank you very much!
1 - I have not come across the mentioned issue and hence not sure what the fix for your issue is. I recommend posting your issue with screenshots on the forums at powerusers.microsoft.com
2 - Choices function is for choice type columns in a data source
Good video Reza. I am a newbie to power apps. I see there a combo box hidden and respective values are placed as checkboxes. Does both required? Is there anything like multiselect checkboxes or radio buttons which can do the functionality without hidden combobox.
Yes both are required in my example since the combo box default values is set from the checkboxes.
There is no muli select checkbox control in Power Apps.
There is a radio button control but it only allows single selection. I wanted to showcase multi selections in my demo.
Thank you very much ! I love your videos. This Time I have got a problem. I have a sharepoint list as data source. With the Filter(Search( function the dataset finds nothing because there is a problem with the deligation. Can you help me here ?
Thank You!
Debugging issues here on chat is not a great option. I recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
Videos like these keeps us admins sane and employed 🤣 thank you this is amazing
Thanks 😊
Thanks @Reza for this great video. I am having an issue, when I choose values from checkbox, it is showing in combo box but gallery is not filtering, when I select manually from combobox then gallery filtering.following your video at 13:40
Welcome!
I have not come across this issue and hence not sure what the cause could be.
I recommend posting your issue on forums in case someone has experienced something similar powerusers.microsoft.com
Thanks for such excellent video. I'm replicating several filter for my own project in PowerApps for Teams and it seems Date column has different properties. It doesn't accept SelectedDate, instead
It only accepts .Value. But the filter doesn't work as expected. Do you have any tip to solve it?. This is the syntax i'm using:
'Project Deliverable Estimate Date'
I have not faced any issue with date columns.
Here is one of my old videos. Check - ua-cam.com/video/eCMuXPI1Qok/v-deo.html
Thank you Reza, Hi, btw, the dynamic sort does not work with delegation?
Sort delegation is tricky. Check ua-cam.com/video/6KlI1iZ_KD0/v-deo.html
Thanks for the video. If I don't want some values from drop down to show in gallery in one screen and show that in a different gallery in different screen to differentiate the choices..how to make that. Am using SP list tried sing Collection but not working for me.
I will have to look at your App in action to provide any guidance. I would recommend you post your issue/query with screenshots on the forums at powerusers.microsoft.com
excellent
Thanks
Hello Reza, i am trying to add multiple filters using this video while also filtering my date column using one of your previous videos. i have been able to filter by date but i dont know how to add the additional filter without getting errors.
so here is my date filter which works: SortByColumns(Filter('Works',
PlannedDateNumber>=VarDateFrom && PlannedDateNumber
I would have to recreate your scenario or look at your App in action (screenshots) to provide any guidance. I would recommend you post your issue/query with screenshots on the forums at powerusers.microsoft.com
Hi Reza..
I have a scenario where I need to use 2 datasources on one Gallery. Both have reference number field but based on the selection on the first screen, the reference number starts with either: PLR---, PRJ---, POC---. Both data sources have PRJ--- and then the other has PLR--- while the other has POC--- in the reference field as well. How would I go about showing both data sources on one gallery accounting that they both have PRJ but then I need PLR and POC as well from each data source?
I do not have a video reference on this scenario and would have to try it out to provide guidance. I recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.
Hi Reza, Thanks for video it was great. I was using a common search button where user can type and search for all the column in a table . I was having a date column but i was nort able to use the common search function for it. Can you please help regarding the same.
Not sure if one can search on dates. The Data source would also play a key role in this.
I will recommend you check on the forums at powerusers.microsoft.com/
Great content. One question. How did you get the date into PowerApss? In my case it says that the formula is not admitted. I´m using a Label to show the date in the app.
I will have to look at your App in action to know the cause of your issue. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
Hi Reza, thankyou for this video but is there a way to filter a gallery based on lookup column? I'm using dataverse.
Check if this gives you any ideas -> ua-cam.com/video/2XUKvXNfsIc/v-deo.html
Thanks for the tutorial. Is there any way to filter the related table (lookup) data.
Thanks.
Which data source?
Excellent! I finally found a tutorial that I need for what I'm going to build. My first app, a little nervous.😁 Now, I have a Excel table that stored in one drive, is the concept still the same? I mean when we apply the formula, do I use the header name of the column I wNt to pull the data from? Do I have to define the name of the column in Excel before I do anything? Thank you for your time.🙏
Concept would be similar.
However, Excel is not a good data source for Power Apps.
Better options are Dataverse, SQL or SharePoint.
@@RezaDorrani Thank you for the prompt reply. I have a feeling excel is not ideal foe power app but I've never worked with dataverse. It might be a good time to learn. Thank you again.
Hi Reza. I have a lookup column in my sharepoint list. Can i use that lookup column as a filter to the gallery? If so what code shouldi past in the filter for that lookup column. The lookup column has a Value and Id i saw. If i filter on the lookup column alone it works. But when i start adding other filters i doesn't work. Not sure if my code is incorrect. I am using " LOOKUPCOLUMN.Value in DROPDOWN.SelectedItems. "
Possible but I would have to test it out. I did a video long back on lookup column single select filter - ua-cam.com/video/pn50AKn3Q1Y/v-deo.html
Great video. Thank you.
Will this work for image galleries on sharepoint?
As long as power apps can connect to it (which it can), its a Yes
Very useful video
Thank you