Тёмный

How to apply Multiple Filters to Power Apps Gallery: Dates, Ranges & More! 📅🎯 

Reza Dorrani
Подписаться 130 тыс.
Просмотров 61 тыс.
50% 1

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: ru-vid.comjoin
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

Наука

Опубликовано:

 

21 июл 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 157   
@hamytube
@hamytube 11 месяцев назад
Hi Reza, Very informative video, these features are highly requested and I am sure it will help the community. Thank you.
@RezaDorrani
@RezaDorrani 11 месяцев назад
Glad it was helpful!
@dougydoe
@dougydoe 11 месяцев назад
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.
@RezaDorrani
@RezaDorrani 11 месяцев назад
Glad you enjoyed it! Thanks so much for the feedback
@Shmank
@Shmank 7 месяцев назад
Thank you, Reza. I subscribed and have been watching a lot of your videos for several weeks. You are a fantastic teacher.
@RezaDorrani
@RezaDorrani 7 месяцев назад
Wow, thank you so much. Welcome to the channel
@rexnii3458
@rexnii3458 5 месяцев назад
1000x thanks to you Reza!! You are an amazing human being.
@maiwitto
@maiwitto 9 месяцев назад
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 👏 👍🏻
@RezaDorrani
@RezaDorrani 9 месяцев назад
Great to hear! Thanks so much for watching and learning from the videos
@DroneEyes
@DroneEyes 11 месяцев назад
Another nice video Reza ... you rock!
@RezaDorrani
@RezaDorrani 11 месяцев назад
Thanks again!
@paolovr1970
@paolovr1970 11 месяцев назад
Thanks Reza 🙏🙏🙏 everytime always amazing explanations.
@RezaDorrani
@RezaDorrani 11 месяцев назад
Glad you think so!
@sreeponn
@sreeponn 7 месяцев назад
Brilliant!! And/or logic makes it so easy!
@RezaDorrani
@RezaDorrani 7 месяцев назад
Thanks
@aka9898
@aka9898 11 месяцев назад
Great Raza, how simply you explain in the video....informative .....Thanks 🙏
@RezaDorrani
@RezaDorrani 11 месяцев назад
You’re most welcome and thanks so much for watching
@georgegualda4262
@georgegualda4262 11 месяцев назад
As Always.... excellent video very well explained.
@RezaDorrani
@RezaDorrani 11 месяцев назад
Thank You George
@anis1106_
@anis1106_ 6 месяцев назад
thanks!! This is the clearest guide I have seen :)
@RezaDorrani
@RezaDorrani 6 месяцев назад
You're welcome!
@simonball5602
@simonball5602 11 месяцев назад
Great video Reza. Thank you.
@RezaDorrani
@RezaDorrani 11 месяцев назад
My pleasure!
@mirzasadiquebaig5798
@mirzasadiquebaig5798 11 месяцев назад
Always Perfect and backstopping 👍👍👍
@RezaDorrani
@RezaDorrani 11 месяцев назад
Thanks so much
@aminaali6616
@aminaali6616 6 месяцев назад
tyvm Reza, you always help us. cheers!
@RezaDorrani
@RezaDorrani 6 месяцев назад
Most welcome
@juanalcan2226
@juanalcan2226 11 месяцев назад
Great video, Thank you
@RezaDorrani
@RezaDorrani 11 месяцев назад
Glad you liked it!
@jailsonroberto88
@jailsonroberto88 Месяц назад
Tks Reza! You are amazing!
@RezaDorrani
@RezaDorrani Месяц назад
Thanks
@shribang4440
@shribang4440 9 месяцев назад
Thank you for sharing, this has helped me understand better.
@RezaDorrani
@RezaDorrani 9 месяцев назад
Glad it was helpful!
@oluwatobipaul6171
@oluwatobipaul6171 11 месяцев назад
Thanks for another amazing tip Reza
@RezaDorrani
@RezaDorrani 11 месяцев назад
Most welcome
@aladris5443
@aladris5443 4 месяца назад
Great video, thanks a lot!
@RezaDorrani
@RezaDorrani 4 месяца назад
Most welcome
@meskiy1967
@meskiy1967 11 месяцев назад
very informative video, and very helpful Thank you so much
@RezaDorrani
@RezaDorrani 11 месяцев назад
Most welcome
@deepakcitm
@deepakcitm 11 месяцев назад
Amazing work ❤
@RezaDorrani
@RezaDorrani 11 месяцев назад
Thank you! Cheers!
@csmtiltm5910
@csmtiltm5910 3 дня назад
Thank you very much !!!
@RezaDorrani
@RezaDorrani 3 дня назад
You are most welcome!
@RezaDorrani
@RezaDorrani 3 дня назад
You are most welcome!
@mukhayyarmohammed5874
@mukhayyarmohammed5874 11 месяцев назад
Superb content as usual
@RezaDorrani
@RezaDorrani 11 месяцев назад
Glad you enjoyed it
@ronbakker1300
@ronbakker1300 11 месяцев назад
Thank you Reza, looking forward to when we can format modern date picker to dd/mm/yyy
@RezaDorrani
@RezaDorrani 11 месяцев назад
Coming very soon
@kojo_shaddy
@kojo_shaddy 11 месяцев назад
Great work
@RezaDorrani
@RezaDorrani 11 месяцев назад
Thank you! Cheers!
@anoop9435
@anoop9435 20 дней назад
Hi sir. Thankyou for the video. Could you please help me to find how did or which gallery have you put as browse screen and any icons you used ?
@RezaDorrani
@RezaDorrani 20 дней назад
Video description has link to download entire solution (members only - check description for details)
@amandapiccinini8295
@amandapiccinini8295 8 месяцев назад
Done ! Very nice vídeo :D
@RezaDorrani
@RezaDorrani 8 месяцев назад
Thanks
@CloudhoundCoUk
@CloudhoundCoUk 11 месяцев назад
Magnificent.
@RezaDorrani
@RezaDorrani 11 месяцев назад
Thanks
@user-iu3ri4vp9n
@user-iu3ri4vp9n 4 месяца назад
you are my saviour 😍😍
@truecrimerealtime3135
@truecrimerealtime3135 6 месяцев назад
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).
@RezaDorrani
@RezaDorrani 6 месяцев назад
Modern dropdown and combo box do not work well with person type columns.
@amrhamdy8578
@amrhamdy8578 11 месяцев назад
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??
@RezaDorrani
@RezaDorrani 11 месяцев назад
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
@ashokpershad
@ashokpershad 11 месяцев назад
Thanks Reza..😊
@RezaDorrani
@RezaDorrani 11 месяцев назад
Most welcome
@venukolar7999
@venukolar7999 11 месяцев назад
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.
@RezaDorrani
@RezaDorrani 11 месяцев назад
Gallery designs -> ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-Jj4ZYztnUQ0.html Gallery flyout menu -> ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-ZWl2jwC9p3w.html
@feelingchefedd9071
@feelingchefedd9071 3 месяца назад
do you have videos on how I'm going to put a counter if how many items will fall under the filtered value?
@RezaDorrani
@RezaDorrani 3 месяца назад
No
@user-cq9hw6gu6s
@user-cq9hw6gu6s 11 месяцев назад
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)
@RezaDorrani
@RezaDorrani 11 месяцев назад
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.
@user-cq9hw6gu6s
@user-cq9hw6gu6s 11 месяцев назад
@@RezaDorrani Are you planning something like that in a future?
@RezaDorrani
@RezaDorrani 11 месяцев назад
@@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.
@samitbhattacharya2201
@samitbhattacharya2201 11 месяцев назад
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 👍
@RezaDorrani
@RezaDorrani 11 месяцев назад
Thanks for watching the videos. Check my playlist on editable grids.
@sejalmehta5203
@sejalmehta5203 9 месяцев назад
Hello Reza, I wanted to ask can you make a video on ow to do orderly sorting for displaying multiple values of dropdown?
@RezaDorrani
@RezaDorrani 9 месяцев назад
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.
@bilalzeine5572
@bilalzeine5572 5 месяцев назад
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.
@RezaDorrani
@RezaDorrani 5 месяцев назад
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
@kevinnguyen3635
@kevinnguyen3635 8 месяцев назад
Very nice ! How did you get the new Calendar UI. I'm still stuck with the old one on Canvas app 😞
@RezaDorrani
@RezaDorrani 8 месяцев назад
Im using modern controls. Check my recent videos. They are all about modern controls and they can be enabled from settings in App.
@kevinnguyen3635
@kevinnguyen3635 8 месяцев назад
@@RezaDorrani Is it stable enough to use in production?
@RezaDorrani
@RezaDorrani 8 месяцев назад
@@kevinnguyen3635 GA was announced today for a few controls. Check power apps blog.
@pauloaquiles6040
@pauloaquiles6040 10 месяцев назад
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.
@RezaDorrani
@RezaDorrani 10 месяцев назад
I have done ~10 videos on filtering covering all column types. Recommend to check my videos on gallery filtering.
@adchrisakinyode5087
@adchrisakinyode5087 11 месяцев назад
Awesome, Reza. Please, can you do a video on how to load 2000+ data into gallery.
@RezaDorrani
@RezaDorrani 11 месяцев назад
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.
@mixedbeans
@mixedbeans 6 месяцев назад
Do you need to use modern controls?
@RezaDorrani
@RezaDorrani 6 месяцев назад
No
@natalyaoliveira6264
@natalyaoliveira6264 8 месяцев назад
Hello how can you combine Search/SortbyCOlumn/Filter when you have an And function.Thank you
@RezaDorrani
@RezaDorrani 8 месяцев назад
I have done a video on filter and sort Simply decorate that with search
@adchrisakinyode5087
@adchrisakinyode5087 10 месяцев назад
Hi Reza, thanks for this video. Is there a way to filter gallery if date elapses each other?
@RezaDorrani
@RezaDorrani 10 месяцев назад
What does elapses mean?
@adchrisakinyode5087
@adchrisakinyode5087 10 месяцев назад
I'm sorry..wanted to say "overlap"
@RezaDorrani
@RezaDorrani 10 месяцев назад
@@adchrisakinyode5087 It does show data based on the range. So not sure whats the issue.
@user-vx3uq2qh6u
@user-vx3uq2qh6u 11 месяцев назад
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!
@RezaDorrani
@RezaDorrani 11 месяцев назад
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
@user-vx3uq2qh6u
@user-vx3uq2qh6u 11 месяцев назад
@@RezaDorrani Will do! Thanks for your prompt response.
@joelhapple
@joelhapple 11 месяцев назад
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…
@RezaDorrani
@RezaDorrani 11 месяцев назад
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.
@joelhapple
@joelhapple 11 месяцев назад
​@@RezaDorrani Thanks for your reply. I will check the forums
@kitegaming2661
@kitegaming2661 11 месяцев назад
How can you make the value blank on the product filter? I keep getting the first value of the choice
@RezaDorrani
@RezaDorrani 11 месяцев назад
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.
@ukaszyp479
@ukaszyp479 2 месяца назад
Hello Reza. Could You tell me how You make this info "show all data" or show information about actual filter date ?
@RezaDorrani
@RezaDorrani 2 месяца назад
the video itself is my best explanation
@ukaszyp479
@ukaszyp479 2 месяца назад
@@RezaDorrani i got only "Start Date cannot be greater than End Date" :(
@RezaDorrani
@RezaDorrani 2 месяца назад
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
@fam.giannakisflores7780
@fam.giannakisflores7780 11 месяцев назад
Mr Reza a quick question, how is posible to access in power apps or powerautomate the rstp protocol of a videocamara? it is posible?
@RezaDorrani
@RezaDorrani 11 месяцев назад
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
@fam.giannakisflores7780
@fam.giannakisflores7780 11 месяцев назад
thanks i will do that, BTW Excelent video@@RezaDorrani
@RezaDorrani
@RezaDorrani 11 месяцев назад
@@fam.giannakisflores7780 Thanks
@mixedbeans
@mixedbeans 6 месяцев назад
Maybe I need to watch this again but if there is no end date can a record still be shown?
@RezaDorrani
@RezaDorrani 6 месяцев назад
From what I remember- Yes
@user-erin109
@user-erin109 4 месяца назад
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.
@RezaDorrani
@RezaDorrani 4 месяца назад
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
@vitorbrandao8464
@vitorbrandao8464 10 месяцев назад
I can't get it to work with either the old or the modern controller. Can you help me Reza?
@RezaDorrani
@RezaDorrani 10 месяцев назад
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
@alainlopez9343
@alainlopez9343 7 месяцев назад
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
@RezaDorrani
@RezaDorrani 7 месяцев назад
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
@soumyathinking
@soumyathinking 18 дней назад
Sorry for the late reply, if you face this issue you can replace the "Value" with "Selecteddate"/"Selected" option and it should work
@abishkumar2131
@abishkumar2131 11 месяцев назад
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?
@RezaDorrani
@RezaDorrani 11 месяцев назад
Does not sound like a right approach to me. Why would you want to do that? Whats the scenario?
@abishkumar2131
@abishkumar2131 11 месяцев назад
@@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
@RezaDorrani
@RezaDorrani 11 месяцев назад
@@abishkumar2131 whats Soni? I dont have any video on this scenario. I recommend posting your query on forums at powerusers.microsoft.com
@abishkumar2131
@abishkumar2131 11 месяцев назад
@@RezaDorrani Thanks for your valuable help ❤️.
@abishkumar2131
@abishkumar2131 11 месяцев назад
Sorry for the mistake, that was so I want to...
@user-kg9io6mw4f
@user-kg9io6mw4f 11 месяцев назад
Hi sir im getting error in my text of product like ThisItem.Product.Value json parsing error expected object but got array
@RezaDorrani
@RezaDorrani 11 месяцев назад
Video description has link to download entire app and setup (member only). 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
@user-bf7te2ub9d
@user-bf7te2ub9d 7 месяцев назад
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.
@RezaDorrani
@RezaDorrani 7 месяцев назад
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
@user-bf7te2ub9d
@user-bf7te2ub9d 7 месяцев назад
Hi Reza, What I mentioned is on your video 2:39, please kindly check. @@RezaDorrani
@RezaDorrani
@RezaDorrani 7 месяцев назад
@@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.
@ishkabibble001
@ishkabibble001 6 месяцев назад
who knows how many powerapps out there are solely due to Reza spreading his magic.
@RezaDorrani
@RezaDorrani 6 месяцев назад
I am so happy to know that there are apps out there :)
@kylehill4437
@kylehill4437 3 месяца назад
.Value is not working for me not sure why is giving me a red x
@RezaDorrani
@RezaDorrani 3 месяца назад
I recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com
@Maxmaxfox
@Maxmaxfox 11 месяцев назад
we want an attend app for school plzzzzz
@RezaDorrani
@RezaDorrani 11 месяцев назад
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.
@edwardpacocha
@edwardpacocha 10 месяцев назад
*promosm*
@RezaDorrani
@RezaDorrani 10 месяцев назад
What does this mean?
@roelmarten3969
@roelmarten3969 6 месяцев назад
Not working. These codes are outdated
@RezaDorrani
@RezaDorrani 6 месяцев назад
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
@roelmarten3969
@roelmarten3969 6 месяцев назад
@@RezaDorraniBy dpStartDate.Value. It says "'Value' isn't recognized". I had to do dpStartDate.SelectedDate.
@RezaDorrani
@RezaDorrani 6 месяцев назад
Thats becoz of modern control properties. Modern date control is in preview.
@roelmarten3969
@roelmarten3969 6 месяцев назад
@@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?
@RezaDorrani
@RezaDorrani 6 месяцев назад
@@roelmarten3969 check setting shown in ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-TWcQwocLsE4.html
@juanjesuscanedovaldes7822
@juanjesuscanedovaldes7822 10 месяцев назад
Video inservible, no ayuda en nada
@RezaDorrani
@RezaDorrani 10 месяцев назад
Comentario inútil, no me ayuda en nada a saber qué le pasa al vídeo.
Далее
СДЕЛАЛА БРЕКЕТЫ ДОМА
01:01
Просмотров 1,2 млн
В GEOMETRY DASH СДЕЛАЛИ GTA
00:27
Просмотров 524 тыс.
PowerApps Multiple Filters on Gallery
23:45
Просмотров 291 тыс.
PowerApps filter gallery by dropdown
28:06
Просмотров 267 тыс.
Wait! Solve Delegation Easily! In Power Apps Search
29:57
Power Apps Menu Navigation (as a Component!)
18:57
Просмотров 52 тыс.
PowerApps Filter Gallery by the Current User
22:16
Просмотров 115 тыс.