PowerApps Multiple Filters on Gallery
ฝัง
- เผยแพร่เมื่อ 7 ก.ค. 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!
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.
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.
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
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 🙏
This is the single most useful power apps video I've seen. Thank you, Reza! Great explanations.
Wow! Thanks so much.
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!
Thank you so much, again! Great videos for beginners, intermediate and advanced users.
You are most welcome!
Great Video Reza! Like the layout too. thanks for the tip on filtering. worked a treat
Awesome! Thanks for watching.
Thanks Reza, you're a life saver! I spent days on this actually. Now my tasks is done...
Thanks!
This video is God-sent! Thank you so so so much!
You are most welcome. Welcome to my channel :)
MAN I DON'T Know how many times you saved my Power Platform daily Life....THANK YOU MAN!
You are most welcome!
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.
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
Sir, this is Great!!! I used to waste so much time in long and conditions doing multiple filters
Great 👍
Thanks for another great video! This helped me solve a filter issue that was driving me crazy all week.
Glad it helped!
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 🙏
Learned a lot about powerapps filter usages, Thanks!
Great to hear!
Thanks for this video Reza, very useful as always!
Glad to hear that! Thanks for watching
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!
Another great reference video, thank you Reza.
Thank you Ron
Those tips are lifesavers. Second time this video saves my ass with the Sharepoint filter. Thank you very much Reza!
Most welcome
you sent me enlightment after 2hours of trying to filter Sharepoint List - thank you Reza :-)
You are most welcome
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.
Thanks a Lot !!! Great Content !
Thank You for watching.
Thanks Reza, you're my Power Apps Super Hero.
🦸♂️ Thank You :)
Fantastic video, thank you Reza!
Most welcome and thanks for watching
Great video. Extremely userful!
Glad it was helpful!
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.
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!
Thank you Reza, you're the best!!! You solve my problem 😅
Glad to hear that!
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
You are the Goat Reza! thanks for this one
My pleasure!
Reza, thank you so much! Your job is excellent! Congratulation👍
Most welcome! Thanks for watching and liking the videos
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 :)
This helped me so much. Thanks for your amazing videos!
You're so welcome!
thank uuuuuuuuuuuuuuuuuuuuuuuuu such a beautiful tutorial
You’re most welcome
thank you very much sir for all the explanation
You are most welcome
You Rock! Thanks for your efforts
My pleasure!
This is what im looking for.thanks 🤩🤩🤩
Glad it was helpful
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.
Amazing video ! Thanks a lot
Glad you liked it!
Thanks Reza always excellent videos
Glad you like them!
Hi Reza, great video. I like your IsBlank and IsEmpty conditions. Awesome 👌
Thank you
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 😊
Great, as always
Thank you! Cheers!
Hi from the future😊😊. Top videos as always Reza thanks for all you do.
Glad you like them!
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 th-cam.com/video/bnC8u3gdWss/w-d-xo.html
It also has link (in video description) to look at the sample App which includes multiple designs.
Thx for sharing!!! Very helpfull!!! Greetings from germany Christoph 👏 👏 👏 👏 👏
Glad it was helpful! Thank You!
Great info, I only wish I had come across this sooner.
Better late than never :)
Welcome to my channel
Very nice and useful!!!
Thank You
extremely helpful, thnx a lot
Thanks for watching
As always, a great video! Thanks so much!
Glad you enjoyed it!
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!
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! the watering be multiplied to you!
Thanks Kyle
Thank you sooo much
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.
I love great videos! :)
Thank you!!
Loveeeee ittttt!!!!!
Thank You
A life saver video
👍 👍
Awesome stuff
Thanks
Videos like these keeps us admins sane and employed 🤣 thank you this is amazing
Thanks 😊
excellent
Thanks
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.
Very useful video
Thank you
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 - th-cam.com/video/tPxE_-DcWkg/w-d-xo.html
Hi Reza, thanks
Welcome!
Thanks Reza
👍
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
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.
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.
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.
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 - th-cam.com/video/bnC8u3gdWss/w-d-xo.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
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
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
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.
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 th-cam.com/video/Cu8pDo6WpRI/w-d-xo.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
Thank you Reza, Hi, btw, the dynamic sort does not work with delegation?
Sort delegation is tricky. Check th-cam.com/video/6KlI1iZ_KD0/w-d-xo.html
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 - th-cam.com/video/Qfer3DwjfwA/w-d-xo.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
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.
Thanks Reza for nice informative video.
After filtering I clicked the title to go to details view screen but when I clicked back all the filtering gone. How to maintain that state of filtering?
As long as you do not reset the controls, the filtering will be maintained.
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.
Great content Reza! How can we add a Yes/No to the combo drop down?
You will need to build a collection and add your own values in there. In this video I add “All” as an option - th-cam.com/video/IWEQwGLcW7Q/w-d-xo.html
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
Hi Reza, another great video. The dropdown task status filter works fine, I've then added the checkbox options, when I check a box the correct task appears in the task status label, however my gallery goes blank.
I would 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
I am getting the same behavior, if you were able to resolve, would you mind proving guidance?
@@SheaStith hi, I never got to a resolution. I even tried posting on the Microsoft community. Eventually I removed it altogether and stayed with the drop down list
Thanks for the tutorial. Is there any way to filter the related table (lookup) data.
Thanks.
Which data source?
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 th-cam.com/video/Wr42PeW6_wU/w-d-xo.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
YOU ARE A LEGEND Reza.... This video is a life-saver buddy... Keep it up... A small question I have a SP list with 44 columns and around 600 rows I need to filter it by 5 text columns also by 10 range of days and finaly around 5 choice columns... An advice on how to start would be really appreciate it... Thanks 😊
Just follow the technique in this video to achieve it. You will need to add plenty of conditions in the filter query. Since your data source is SharePoint use the StartsWith function.
@@RezaDorrani Legend :( when one applies various StartsWith to the filter the gallery doesn't show anything and also if the columns that you're filtering by have empty records those rows are just ignored... :(
@@johanynavarro8065 Not true. You must be adding some query that is resulting in empty results. Paste your entire query here.
@@RezaDorrani You are right Master I apologies the query works ok but I think if on the column there are empty fields, in my case, not all the records have yet a Manager assigned so those records are ignored.
Filter(colProcesses,
StartsWith(Companyname, inputCompanyName.Text),
StartsWith(Manager, inputManager.Text),
StartsWith(Reviewer, inputReviewer.Text),
StartsWith(Form, inputForm.Text)
)
I really appreciate your time answering my silly questions... God bless you.
Awesome Video. One question Can we save this data whatever is filtered out from slicers. And also the slicers selected data in sharepoint ?
Save data meaning export it out? Then yes. I have done videos on that topic.
Save slicer data - may be you can use savedata and loaddata functions to store than info on user device.
Thanks for the video, it's really helpful. I followed this tutorial yesterday to implement some filters on my galleries and I also used the choices fields in comboboxes. It was all working perfectly yesterday. but this morning I have found that my filters have stopped working and that the comboboxes that reference choices now contain an IDs aswell as the Value. I'm so confused how things can just change overnight
Overnight changes are scary :) Did you try posting your issue on the forums with screenshots?
I would recommend you post your issue/query with screenshots on the forums at powerusers.microsoft.com
@@RezaDorrani I'll be having a look at it Tomorrow morning to see if the issue persists, and if so, I'll follow your advice and make a post. Thanks for the help and thanks for the videos. They really are very helpful 👍