How to apply Multiple Filters to Power Apps Gallery: Dates, Ranges & More! 📅🎯
Vložit
- čas přidán 1. 06. 2024
- In this PowerApps tutorial video, we will learn how to apply multiple filters to Power Apps Gallery control. We will unlock the potential of multiple filters as we navigate through a variety of scenarios, including date-based filtering, dynamic date ranges, addressing blank filters, and combining multiple filters for data refinement.
PowerApps tutorial video includes:
✅ Harnessing Multiple Filters for Gallery data refinement
✅ Filter Function
✅ Filtering via Start and End Dates
✅ Crafting Dynamic Date Range Filters
✅ Resetting Filters
✅ Setting Up Filter Default Values
✅ Date Validation
Empower your Power Apps journey by mastering the art of filters, ensuring your Gallery displays exactly what you need. Elevate your app-building experience now! 🚀
⬇️ Download Power App showcased in the video:
Exclusive for Channel Members (Silver Club 🥈 or higher).
Find the download link in the Community Tab for Members.
To become a member, click here: czcams.com/users/rezadorranijoin
More Power Apps filter videos 📽️
• PowerApps Multiple Fil...
• Power Apps Tutorial - ...
#PowerApps #PowerPlatform #SharePoint
Table of Contents:
00:00 - Introduction to filtering Power Apps gallery by multiple filters
00:36 - Demo: Power Apps Gallery with multiple date filters and dropdown filter
02:44 - Build multiple filters (dates, ranges, etc.) for Gallery in Power Apps
07:18 - Set default Filter values
09:44 - Combine Multiple Filters for PowerApps Gallery
12:18 - Add date validation when filtering
13:41 - READY to subscribe to Reza Dorrani’s channel
🤝 Let’s connect on social:
🔗 Reza Dorrani LinkedIn: / rezadorrani
🐦 Reza Dorrani Twitter: / rezadorrani - Věda a technologie
Hi Reza,
Very informative video, these features are highly requested and I am sure it will help the community.
Thank you.
Glad it was helpful!
1000x thanks to you Reza!! You are an amazing human being.
Finally got round to watching this. Simple, straightforward and elegantly presented as always. Extremely useful, especially the combination of the AND, OR and NOT operators to get the required logic to work. Great stuff and thank you for sharing.
Glad you enjoyed it! Thanks so much for the feedback
Thank you, Reza. I subscribed and have been watching a lot of your videos for several weeks. You are a fantastic teacher.
Wow, thank you so much.
Welcome to the channel
Another nice video Reza ... you rock!
Thanks again!
Brilliant!! And/or logic makes it so easy!
Thanks
Thanks Reza 🙏🙏🙏 everytime always amazing explanations.
Glad you think so!
As Always.... excellent video very well explained.
Thank You George
thanks!! This is the clearest guide I have seen :)
You're welcome!
Great video Reza. Thank you.
Always Perfect and backstopping 👍👍👍
Thanks so much
Hi, I’ve always been leaning from your videos. Your explanation and the visuals have helped me a lot from my zero background of both power automate and the power apps. Thanks for your wonderful explanation dedicated to the Microsoft user’s world 👏 👍🏻
Great to hear! Thanks so much for watching and learning from the videos
tyvm Reza, you always help us. cheers!
Most welcome
Great Raza, how simply you explain in the video....informative .....Thanks 🙏
You’re most welcome and thanks so much for watching
Great video, Thank you
Thank you for sharing, this has helped me understand better.
Glad it was helpful!
Thanks for another amazing tip Reza
Most welcome
Amazing work ❤
Thank you! Cheers!
Great video, thanks a lot!
Most welcome
very informative video, and very helpful Thank you so much
Superb content as usual
Glad you enjoyed it
Great work
Thank you! Cheers!
Done ! Very nice vídeo :D
Thanks
Magnificent.
Thanks
you are my saviour 😍😍
Thanks Reza..😊
Most welcome
Thank you Reza, looking forward to when we can format modern date picker to dd/mm/yyy
Coming very soon
Great Video! Is there a specific way to add in and "assigned to" with the modern dropdown to only show the names of the people assigned. Currently I followed the same steps as your product example, but it is bringing everyone back in my directory (all OfficeUsers).
Modern dropdown and combo box do not work well with person type columns.
hi Reza, your is very powerful thanks for your time.
I am creating two canvas apps in a model-driven app but when I switch between apps first app is off??
Most welcome!
I have not come across the mentioned issue and do not have any video references on the scenario mentioned. I recommend posting your issue with screenshots on the forums at powerusers.microsoft.com
Hi Sir, Very informative video, do we have the step-by-step process of building this application apart from date filters like how you build the below galleries and all. if you have please share with us. Thank you.
Gallery designs -> czcams.com/video/Jj4ZYztnUQ0/video.html
Gallery flyout menu -> czcams.com/video/ZWl2jwC9p3w/video.html
Very nice !
How did you get the new Calendar UI. I'm still stuck with the old one on Canvas app 😞
Im using modern controls. Check my recent videos. They are all about modern controls and they can be enabled from settings in App.
@@RezaDorrani Is it stable enough to use in production?
@@kevinnguyen3635 GA was announced today for a few controls. Check power apps blog.
Hi reza, your playlist is so helpful for me. I have a question here.
How can we apply multiple filters and these filters are coming from multiple table like we can do in power bi (Applying multiple slicers on table visual)
It is possible but depends upon the tables / data source / architecture. I do not have a video reference on this scenario though. I recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.
@@RezaDorrani Are you planning something like that in a future?
@@user-cq9hw6gu6s No. I make videos when I receive multiple requests on a topic. Every quarter I ask subscribers for topic suggestions on Community Tab of my channel. Most voted topic ideas get added to my backlog. Make sure to suggest this idea whenever the next topic suggestion post is out.
Writing to you after a long gap. But follow your videos every Monday ☺️.
Can you share link of one of your videos where user can edit data from gallery. As usual 👍
Thanks for watching the videos.
Check my playlist on editable grids.
who knows how many powerapps out there are solely due to Reza spreading his magic.
I am so happy to know that there are apps out there :)
Hi Reza, great video thank you very much, I hoe you can assist me on the following issue, I have all excatly as in your video but I have the error "Name isn't Valid, 'Value' isn´t recognozed", again, thank you very much
Most welcome!
I have not come across the mentioned 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
Awesome, Reza. Please, can you do a video on how to load 2000+ data into gallery.
A gallery if built using delegable queries will load data in batches in a performant manner. Loading 2000+ data into gallery in 1 go is not a recommended (performant) approach.
You can check my playlist on delegation to learn more about how gallery works.
do you have videos on how I'm going to put a counter if how many items will fall under the filtered value?
No
Hello Reza, I wanted to ask can you make a video on ow to do orderly sorting for displaying multiple values of dropdown?
I make videos when I receive multiple requests on a topic. Every quarter I ask subscribers for topic suggestions on Community Tab of my channel. Most voted idea gets added to my backlog. Make sure to post this idea whenever I post the next topic suggestion post.
Hi Reza, thanks for this video. Is there a way to filter gallery if date elapses each other?
What does elapses mean?
I'm sorry..wanted to say "overlap"
@@adchrisakinyode5087 It does show data based on the range. So not sure whats the issue.
Hi Reza, I have one question: Is it possible to have 2 or more filters and have the values for this filters only be items, that are present in the actual set of results? For example a list with visits of a doctor with columns name, symptoms and medication. If I filter the symptoms for “Symptom 1” I want to have the filter for medication contain just the medications that were made for visits with Symptom 1 and vice versa…
Probably possible but would run into delegation issues. Would work with data sets < 2000 items. I do not have a video reference on this scenario though. I recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.
@@RezaDorrani Thanks for your reply. I will check the forums
Hi Reza,
Thanks for this, it was very helpful.
I am currently trying to get a date picker in a gallery (Gallary 2) to display a date depending on the different gallery (Gallery 1) first column AND whats selected in a drop down outside of both the galleries.
I tried the following - LookUp(
'Package Schedule',
'Package number' = DropdownPackageID.Selected.Result && 'Gate Item' = ThisItem.Title,
'BaselineDate'
)
But its giving me a error for the "=" and ".Result" for some reason.
Much appreciated.
I would have to recreate your scenario to know how to frame the formula. I recommend posting your issue on forums at powerusers.microsoft.com
Hi Reza, How to find earliest date from multiple date column? Ex. I have three date columns Date 1, Date 2, Date 3 and I would like to find earliest date from these three columns and filter on earliest date.
Thanks for great content!
Hey, I do not have a video reference on this scenario and would have to try it out to provide guidance. I recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com
@@RezaDorrani Will do! Thanks for your prompt response.
Thanks for vídeo! is It possible to apply a filter to a choices column? I have a choices column with 5 laptops option, I want that an user select a period and the next screen It show only available laptop according with the period that the user selected previously.
I have done ~10 videos on filtering covering all column types. Recommend to check my videos on gallery filtering.
Do you need to use modern controls?
No
Hi Raza, i have a doubt is we can add filter based on one of the label value from the same gallery along with the multiple conditions?
Does not sound like a right approach to me. Why would you want to do that? Whats the scenario?
@@RezaDorrani Thanks for your immediate response. In my gallery I'm showing a label text with condition. Soni wants to filter the gallery with that label name. Please suggest the right way. Thanks
@@abishkumar2131 whats Soni? I dont have any video on this scenario. I recommend posting your query on forums at powerusers.microsoft.com
@@RezaDorrani Thanks for your valuable help ❤️.
Sorry for the mistake, that was so I want to...
Hello Reza.
Could You tell me how You make this info "show all data" or show information about actual filter date ?
the video itself is my best explanation
@@RezaDorrani i got only "Start Date cannot be greater than End Date" :(
I have not come across this issue and hence not sure what is the cause for your issue. I recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
How can you make the value blank on the product filter? I keep getting the first value of the choice
If you are using classic dropdown control (which I assume you are), it has a property related to making it blank to begin with. I don’t remember the property name.
Hello how can you combine Search/SortbyCOlumn/Filter when you have an And function.Thank you
I have done a video on filter and sort
Simply decorate that with search
Mr Reza a quick question, how is posible to access in power apps or powerautomate the rstp protocol of a videocamara? it is posible?
I don’t know if that is possible. I recommend posting your query on forums in case someone has done something similar
powerusers.microsoft.com
thanks i will do that, BTW Excelent video@@RezaDorrani
@@fam.giannakisflores7780 Thanks
Maybe I need to watch this again but if there is no end date can a record still be shown?
From what I remember- Yes
Hi Reza,
How do I filter gallery with the order number from a barcode number from the barcode scanner. I have been trying , and although my expression is showing no errors, it's not working.
I have not done any work with barcode scanner hence not sure. I recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com
I can't get it to work with either the old or the modern controller. Can you help me Reza?
I have not come across any issue with classic or modern controls and not sure what the cause or fix for your issue is. Best thing to do would be to post your issue with screenshots on the forums at powerusers.microsoft.com
Hi Reza,
on 2:39, there is a problem, after filter date, list only product B and Product A, while our product filter choice still shows A/B/C, which should be only B and A, how to correct this? let our filter reflect the left choices only like excel.
I have not come across the mentioned 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
Hi Reza, What I mentioned is on your video 2:39, please kindly check. @@RezaDorrani
@@user-bf7te2ub9d Yes but that is not an issue. I would have to try it out to know how to do it. I would recommend posting your query on forums.
Hi sir im getting error in my text of product like ThisItem.Product.Value json parsing error expected object but got array
.Value is not working for me not sure why is giving me a red x
I recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com
we want an attend app for school plzzzzz
I make videos when I receive multiple requests on a topic. Every quarter I ask subscribers for topic suggestions on Community Tab of my channel. Most voted idea gets added to my backlog. Make sure to post this idea whenever I post the next topic suggestion post.
Not working. These codes are outdated
Not true - these codes work fine!
I have not come across this issue and hence not sure what is the cause for your issue. I recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
@@RezaDorraniBy dpStartDate.Value. It says "'Value' isn't recognized". I had to do dpStartDate.SelectedDate.
Thats becoz of modern control properties. Modern date control is in preview.
@@RezaDorrani how to get the modern control properties? Under "upcoming features", "Keep classic themes" is off. Is there something else I should do get these modern controls?
@@roelmarten3969 check setting shown in czcams.com/video/TWcQwocLsE4/video.html
*promosm*
What does this mean?
Video inservible, no ayuda en nada
Comentario inútil, no me ayuda en nada a saber qué le pasa al vídeo.