PowerApps Multiple Filters on Gallery

  Рет қаралды 292,442

Reza Dorrani

Reza Dorrani

Күн бұрын

#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

Пікірлер: 604
@juansepowerplatform
@juansepowerplatform 3 жыл бұрын
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
@RezaDorrani
@RezaDorrani 3 жыл бұрын
Excellent! So happy to know that the techniques showcases are valuable. Yes, time to refactor code :)
@andrewharvey9697
@andrewharvey9697 2 жыл бұрын
that is what I started doing too.
@bideyyusuf
@bideyyusuf 3 жыл бұрын
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.
@RezaDorrani
@RezaDorrani 3 жыл бұрын
Wow! These are some really amazing compliments. Thank you. The world definitely needs a Vaccine.
@user-ps5ms9ks5w
@user-ps5ms9ks5w Жыл бұрын
Thank you!
@ryanbond7144
@ryanbond7144 3 жыл бұрын
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.
@RezaDorrani
@RezaDorrani 3 жыл бұрын
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.
@balaji830
@balaji830 3 жыл бұрын
You have an amazing knack for teaching. You pick nice examples to demonstrate and provide information to the point. Good job and Thanks
@RezaDorrani
@RezaDorrani 3 жыл бұрын
Thank you for the amazing feedback.
@ingridengenharia1
@ingridengenharia1 3 жыл бұрын
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.
@RezaDorrani
@RezaDorrani 3 жыл бұрын
Thank you 🙏
@juancsanchezv
@juancsanchezv 3 жыл бұрын
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.
@RezaDorrani
@RezaDorrani 3 жыл бұрын
Thank you Juan. Hopefully I have simplified the process of applying filters :)
@vkrish79
@vkrish79 3 жыл бұрын
i second that!...thank you Reza
@8Steady
@8Steady 9 ай бұрын
This is the single most useful power apps video I've seen. Thank you, Reza! Great explanations.
@RezaDorrani
@RezaDorrani 9 ай бұрын
Wow! Thanks so much.
@Dylan-zm3ht
@Dylan-zm3ht Жыл бұрын
Thanks for all your continued help on my powerapp journey. Most of the best practices I have learned have come from you!!!
@RezaDorrani
@RezaDorrani Жыл бұрын
You are so welcome!
@samitbhattacharya2201
@samitbhattacharya2201 3 жыл бұрын
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.
@RezaDorrani
@RezaDorrani 3 жыл бұрын
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.
@lk43wz
@lk43wz 3 жыл бұрын
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.
@RezaDorrani
@RezaDorrani 3 жыл бұрын
Thank You for your kind words. I am no legend. I am just a content creator.
@lk43wz
@lk43wz 3 жыл бұрын
@@RezaDorrani Humble really you are, but please know that your videos mean a lot to people like me. Thanks again.
@RezaDorrani
@RezaDorrani 3 жыл бұрын
@@lk43wz You are most welcome.
@aprilmills5925
@aprilmills5925 Жыл бұрын
@@RezaDorrani No, seriously, you are a legend.
@RezaDorrani
@RezaDorrani Жыл бұрын
@@aprilmills5925 🙏
@arjunmadhav2847
@arjunmadhav2847 2 жыл бұрын
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 :)
@RezaDorrani
@RezaDorrani 2 жыл бұрын
Thank You. If I can do it, anyone can.
@mohamadsaifimran3196
@mohamadsaifimran3196 Жыл бұрын
Thanks Reza, you're a life saver! I spent days on this actually. Now my tasks is done...
@RezaDorrani
@RezaDorrani Жыл бұрын
Thanks!
@prithishsaha8895
@prithishsaha8895 3 жыл бұрын
Sir, this is Great!!! I used to waste so much time in long and conditions doing multiple filters
@RezaDorrani
@RezaDorrani 3 жыл бұрын
Great 👍
@cristianlongo8427
@cristianlongo8427 Жыл бұрын
MAN I DON'T Know how many times you saved my Power Platform daily Life....THANK YOU MAN!
@RezaDorrani
@RezaDorrani Жыл бұрын
You are most welcome!
@tommyhamilton1520
@tommyhamilton1520 3 жыл бұрын
Another great video Reza, keep up the good work. I will be using this method for filtering data in the future. again great work👍
@RezaDorrani
@RezaDorrani 3 жыл бұрын
Thank you
@shawnlloyd7526
@shawnlloyd7526 3 жыл бұрын
Thanks for another great video! This helped me solve a filter issue that was driving me crazy all week.
@RezaDorrani
@RezaDorrani 3 жыл бұрын
Glad it helped!
@andrewharvey9697
@andrewharvey9697 2 жыл бұрын
Great Video Reza! Like the layout too. thanks for the tip on filtering. worked a treat
@RezaDorrani
@RezaDorrani 2 жыл бұрын
Awesome! Thanks for watching.
@moniso2277
@moniso2277 2 жыл бұрын
Thank you so much, again! Great videos for beginners, intermediate and advanced users.
@RezaDorrani
@RezaDorrani 2 жыл бұрын
You are most welcome!
@akakakakak3047
@akakakakak3047 Жыл бұрын
Those tips are lifesavers. Second time this video saves my ass with the Sharepoint filter. Thank you very much Reza!
@RezaDorrani
@RezaDorrani Жыл бұрын
Most welcome
@aducaale328
@aducaale328 3 ай бұрын
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.
@RezaDorrani
@RezaDorrani 3 ай бұрын
Most welcome
@yehunlavolontededieu322
@yehunlavolontededieu322 3 жыл бұрын
Master piece. Thank you Reza as always.
@RezaDorrani
@RezaDorrani 3 жыл бұрын
You are most welcome
@nuinhuin2685
@nuinhuin2685 3 жыл бұрын
Hi Reza, this is so cool. I have watched so many videos, but this one is ultimate! Learned so much, thank you!
@RezaDorrani
@RezaDorrani 3 жыл бұрын
Happy to hear that!
@teresaagustin5191
@teresaagustin5191 3 жыл бұрын
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.
@RezaDorrani
@RezaDorrani 3 жыл бұрын
You are most welcome. Your feedback was exactly the goal of my video.
@conniemaldonado4884
@conniemaldonado4884 2 жыл бұрын
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!!!
@RezaDorrani
@RezaDorrani 2 жыл бұрын
Thank You so much :) Here is my Gallery design video kzfaq.info/get/bejne/mNRza9hkzMq7o6c.html It also has link (in video description) to look at the sample App which includes multiple designs.
@RichardJones73
@RichardJones73 6 ай бұрын
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
@RezaDorrani
@RezaDorrani 6 ай бұрын
You are welcome!
@danielfreundt7720
@danielfreundt7720 3 жыл бұрын
you sent me enlightment after 2hours of trying to filter Sharepoint List - thank you Reza :-)
@RezaDorrani
@RezaDorrani 3 жыл бұрын
You are most welcome
@ehabatme5324
@ehabatme5324 3 жыл бұрын
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 😂🤣😂🤣
@RezaDorrani
@RezaDorrani 3 жыл бұрын
My videos are now based on subscriber requests. I feel I am following the pulse of my audience.
@ehabatme5324
@ehabatme5324 3 жыл бұрын
So Audit Check List is on your Pipeline? 😉
@RezaDorrani
@RezaDorrani 3 жыл бұрын
@@ehabatme5324 I need multiple folks to make similar requests 😊
@rachelshalem
@rachelshalem 2 жыл бұрын
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.
@RezaDorrani
@RezaDorrani 2 жыл бұрын
Glad it was helpful!
@danulienka4030
@danulienka4030 Жыл бұрын
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
@RezaDorrani
@RezaDorrani Жыл бұрын
Most welcome!
@DinosKonstantinou
@DinosKonstantinou 3 жыл бұрын
Reza, the videos you upload are extremely helpful! Thank you! (not a native speaker myself and I love the way you pronounce "Data Worse"! :-) )
@RezaDorrani
@RezaDorrani 3 жыл бұрын
I keep trying to improve my pronunciation :)
@DinosKonstantinou
@DinosKonstantinou 3 жыл бұрын
@@RezaDorrani No! Don't! It's yours, and it is part of you!
@RezaDorrani
@RezaDorrani 3 жыл бұрын
@@DinosKonstantinou Ok. I will stick to my pronunciation style :)
@ramprakashm7891
@ramprakashm7891 3 жыл бұрын
Learned a lot about powerapps filter usages, Thanks!
@RezaDorrani
@RezaDorrani 3 жыл бұрын
Great to hear!
@SaimaSaleem
@SaimaSaleem 2 жыл бұрын
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,
@RezaDorrani
@RezaDorrani 2 жыл бұрын
Thank You.
@Yinusa00
@Yinusa00 4 ай бұрын
Hi from the future😊😊. Top videos as always Reza thanks for all you do.
@RezaDorrani
@RezaDorrani 4 ай бұрын
Glad you like them!
@ItsMeProday83
@ItsMeProday83 Жыл бұрын
Thanks for this video Reza, very useful as always!
@RezaDorrani
@RezaDorrani Жыл бұрын
Glad to hear that! Thanks for watching
@billakantikarthik
@billakantikarthik 3 жыл бұрын
Hi Reza, great video. I like your IsBlank and IsEmpty conditions. Awesome 👌
@RezaDorrani
@RezaDorrani 3 жыл бұрын
Thank you
@anamicula5480
@anamicula5480 3 жыл бұрын
This video is God-sent! Thank you so so so much!
@RezaDorrani
@RezaDorrani 3 жыл бұрын
You are most welcome. Welcome to my channel :)
@patrickteless
@patrickteless 11 ай бұрын
Thank you Reza, you're the best!!! You solve my problem 😅
@RezaDorrani
@RezaDorrani 11 ай бұрын
Glad to hear that!
@ronbakker1300
@ronbakker1300 3 жыл бұрын
Another great reference video, thank you Reza.
@RezaDorrani
@RezaDorrani 3 жыл бұрын
Thank you Ron
@diltoncesarjunior1848
@diltoncesarjunior1848 Жыл бұрын
Reza, thank you so much! Your job is excellent! Congratulation👍
@RezaDorrani
@RezaDorrani Жыл бұрын
Most welcome! Thanks for watching and liking the videos
@manjeetsinghutube
@manjeetsinghutube 2 жыл бұрын
Awesome Reza ,,,, you make things so simple ... thank you ..
@RezaDorrani
@RezaDorrani 2 жыл бұрын
Thank you very much
@dolapolawrence4865
@dolapolawrence4865 3 жыл бұрын
Thanks Reza, you're my Power Apps Super Hero.
@RezaDorrani
@RezaDorrani 3 жыл бұрын
🦸‍♂️ Thank You :)
@christophermichelsen1862
@christophermichelsen1862 3 жыл бұрын
Fantastic video, thank you Reza!
@RezaDorrani
@RezaDorrani 3 жыл бұрын
Most welcome and thanks for watching
@kathryncorbally1404
@kathryncorbally1404 2 жыл бұрын
This helped me so much. Thanks for your amazing videos!
@RezaDorrani
@RezaDorrani 2 жыл бұрын
You're so welcome!
@youtube_Salim
@youtube_Salim 2 жыл бұрын
thank you very much sir for all the explanation
@RezaDorrani
@RezaDorrani 2 жыл бұрын
You are most welcome
@franknielsen3219
@franknielsen3219 Жыл бұрын
Nice way to solve multiple filters, and great video 👌👌👌👌
@RezaDorrani
@RezaDorrani Жыл бұрын
Thank you! Cheers!
@joeswright86
@joeswright86 3 жыл бұрын
Great info, I only wish I had come across this sooner.
@RezaDorrani
@RezaDorrani 3 жыл бұрын
Better late than never :) Welcome to my channel
@TheCleberMetal
@TheCleberMetal 2 жыл бұрын
Thanks a Lot !!! Great Content !
@RezaDorrani
@RezaDorrani 2 жыл бұрын
Thank You for watching.
@johnheck1551
@johnheck1551 3 жыл бұрын
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.
@RezaDorrani
@RezaDorrani 3 жыл бұрын
Thank you. Yes, I do have a video - kzfaq.info/get/bejne/mNRza9hkzMq7o6c.html Video description includes link to download sample App as well.
@noeluk102
@noeluk102 2 жыл бұрын
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
@RezaDorrani
@RezaDorrani 2 жыл бұрын
Not all column types are delegable with IN function. Lookups is one of them. Hopefully, it would be in future.
@anchor4067
@anchor4067 Жыл бұрын
You are the Goat Reza! thanks for this one
@RezaDorrani
@RezaDorrani Жыл бұрын
My pleasure!
@vkrish79
@vkrish79 3 жыл бұрын
Great video. Extremely userful!
@RezaDorrani
@RezaDorrani 3 жыл бұрын
Glad it was helpful!
@FadyAnwarS
@FadyAnwarS 3 жыл бұрын
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.
@RezaDorrani
@RezaDorrani 3 жыл бұрын
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
@cameronmcintosh897
@cameronmcintosh897 3 жыл бұрын
Absolute legend. Well done!
@RezaDorrani
@RezaDorrani 3 жыл бұрын
Wow! Thanks.
@jjayceeb
@jjayceeb 3 жыл бұрын
This is what im looking for.thanks 🤩🤩🤩
@RezaDorrani
@RezaDorrani 3 жыл бұрын
Glad it was helpful
@sundrapillay6668
@sundrapillay6668 3 жыл бұрын
Thanks Reza always excellent videos
@RezaDorrani
@RezaDorrani 3 жыл бұрын
Glad you like them!
@Kylbigel
@Kylbigel 2 жыл бұрын
thank you Reza! the watering be multiplied to you!
@RezaDorrani
@RezaDorrani 2 жыл бұрын
Thanks Kyle
@meryemgazanayi5665
@meryemgazanayi5665 11 ай бұрын
thank uuuuuuuuuuuuuuuuuuuuuuuuu such a beautiful tutorial
@RezaDorrani
@RezaDorrani 11 ай бұрын
You’re most welcome
@sdusa008
@sdusa008 3 жыл бұрын
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.
@RezaDorrani
@RezaDorrani 3 жыл бұрын
Search function has delegation issues with SharePoint. But you could add filters for Person column as well. Check - kzfaq.info/get/bejne/qraoeMJeqcm7m5s.html
@VasilisSiskos
@VasilisSiskos 3 жыл бұрын
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!!
@RezaDorrani
@RezaDorrani 3 жыл бұрын
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.
@bzflowerbee
@bzflowerbee Жыл бұрын
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.🙏
@RezaDorrani
@RezaDorrani Жыл бұрын
Concept would be similar. However, Excel is not a good data source for Power Apps. Better options are Dataverse, SQL or SharePoint.
@bzflowerbee
@bzflowerbee Жыл бұрын
@@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.
@jelin5233
@jelin5233 3 жыл бұрын
Videos like these keeps us admins sane and employed 🤣 thank you this is amazing
@RezaDorrani
@RezaDorrani 3 жыл бұрын
Thanks 😊
@christophmeirich5928
@christophmeirich5928 2 жыл бұрын
Thx for sharing!!! Very helpfull!!! Greetings from germany Christoph 👏 👏 👏 👏 👏
@RezaDorrani
@RezaDorrani 2 жыл бұрын
Glad it was helpful! Thank You!
@radhakishansharma3582
@radhakishansharma3582 4 ай бұрын
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
@RezaDorrani
@RezaDorrani 4 ай бұрын
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
@itmesneha
@itmesneha 3 жыл бұрын
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.
@RezaDorrani
@RezaDorrani 3 жыл бұрын
Search function with SharePoint is not delegable. I would not recommend using it if your data source is SharePoint.
@yogalayang8096
@yogalayang8096 Жыл бұрын
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?
@RezaDorrani
@RezaDorrani Жыл бұрын
No workaround for SharePoint yet.
@Joker064460
@Joker064460 10 ай бұрын
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!
@RezaDorrani
@RezaDorrani 10 ай бұрын
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
@jasonmelchert155
@jasonmelchert155 2 жыл бұрын
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!
@jasonmelchert155
@jasonmelchert155 2 жыл бұрын
For anyone interested, I was able to figure this out using another one of Reza's videos on Dataverse Choices columns kzfaq.info/get/bejne/edtoo6egm73Ugn0.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"})
@RezaDorrani
@RezaDorrani 2 жыл бұрын
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
@RezaDorrani
@RezaDorrani 2 жыл бұрын
Thanks for sharing
@maximeklifman2303
@maximeklifman2303 3 жыл бұрын
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!
@RezaDorrani
@RezaDorrani 3 жыл бұрын
Possible. Set the default values on App load in the collection which gets updated when checkboxes are checked or unchecked.
@dominikdetering942
@dominikdetering942 11 ай бұрын
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 ?
@RezaDorrani
@RezaDorrani 11 ай бұрын
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
@pravalenka
@pravalenka Жыл бұрын
Thanks a lot sir ,you are great
@RezaDorrani
@RezaDorrani Жыл бұрын
Thank You 😊
@lucasvigier8373
@lucasvigier8373 3 жыл бұрын
Amazing video ! Thanks a lot
@RezaDorrani
@RezaDorrani 3 жыл бұрын
Glad you liked it!
@limychelseafc
@limychelseafc 2 жыл бұрын
Thank you Reza, Hi, btw, the dynamic sort does not work with delegation?
@RezaDorrani
@RezaDorrani 2 жыл бұрын
Sort delegation is tricky. Check kzfaq.info/get/bejne/bLGcfJSav8WvdGQ.html
@geometricsprocket
@geometricsprocket 3 жыл бұрын
You Rock! Thanks for your efforts
@RezaDorrani
@RezaDorrani 3 жыл бұрын
My pleasure!
@naynadhone359
@naynadhone359 Жыл бұрын
Awesome Video. One question Can we save this data whatever is filtered out from slicers. And also the slicers selected data in sharepoint ?
@RezaDorrani
@RezaDorrani Жыл бұрын
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.
@masgitz
@masgitz 3 жыл бұрын
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?🤷‍♂️
@RezaDorrani
@RezaDorrani 3 жыл бұрын
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 - kzfaq.info/get/bejne/h8yVpZZ13NDKp3U.html
@georgereid24
@georgereid24 Жыл бұрын
Great video. Thank you. Will this work for image galleries on sharepoint?
@RezaDorrani
@RezaDorrani Жыл бұрын
As long as power apps can connect to it (which it can), its a Yes
@CaptCJ1969
@CaptCJ1969 3 жыл бұрын
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.
@RezaDorrani
@RezaDorrani 3 жыл бұрын
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
@SheaStith
@SheaStith 2 жыл бұрын
I am getting the same behavior, if you were able to resolve, would you mind proving guidance?
@CaptCJ1969
@CaptCJ1969 2 жыл бұрын
@@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
@nickleryan106
@nickleryan106 2 жыл бұрын
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?
@RezaDorrani
@RezaDorrani 2 жыл бұрын
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
@Tower5DeSchmittgall
@Tower5DeSchmittgall 2 жыл бұрын
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!
@RezaDorrani
@RezaDorrani 2 жыл бұрын
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.
@niuean22kid
@niuean22kid 3 жыл бұрын
Great content Reza! How can we add a Yes/No to the combo drop down?
@RezaDorrani
@RezaDorrani 3 жыл бұрын
You will need to build a collection and add your own values in there. In this video I add “All” as an option - kzfaq.info/get/bejne/f711hNp4scm7Z4U.html
@kranthisks
@kranthisks 3 жыл бұрын
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.
@RezaDorrani
@RezaDorrani 3 жыл бұрын
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.
@olegstepanov7500
@olegstepanov7500 2 жыл бұрын
extremely helpful, thnx a lot
@RezaDorrani
@RezaDorrani 2 жыл бұрын
Thanks for watching
@matomejackolinetsiri9468
@matomejackolinetsiri9468 Жыл бұрын
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?
@RezaDorrani
@RezaDorrani Жыл бұрын
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.
@user-zl8vt8fz2d
@user-zl8vt8fz2d Жыл бұрын
Hi Reza. As always, thanks for your efforts with these instructional videos. Always excellent! I have a particular project that I am struggling with. I have a SP list and SP library. The library has a lookup column that refers to the list for assigning a number to a document in the library. I've built a powerapp that uses 2 dropdown filters of a gallery (filtering each other dynamically). The gallery is just a display of the list so the user can see the remaining options for selecting a number to assign in the library. Since this is a powerapp that edits the fields in the Sharepoint library, I need to have the resulting options in that dropdown be pre-filtered based on the 2 list dropdowns that filtered the gallery. I apologize if this is confusing.
@RezaDorrani
@RezaDorrani Жыл бұрын
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.
@user-zl8vt8fz2d
@user-zl8vt8fz2d 11 ай бұрын
​@@RezaDorrani Do you know of a way to add a sortbycolumns() function to sort the gallery in ascending order once the filters have been applied? It would need to be after the delegation limit errors are no longer an issue (after filtering). I'm getting an issue where the list is out of order of how I would like it displayed. I've seen your video on sorting, but I don't know how to add it to the existing filtering formula you demonstrated in this video without creating issues.
@RezaDorrani
@RezaDorrani 11 ай бұрын
@@user-zl8vt8fz2d Simply add sort logic on top of filter. I have a video on sort and filter which does exactly that
@user-zl8vt8fz2d
@user-zl8vt8fz2d 11 ай бұрын
@@RezaDorrani Perfect, thank you. Works great!
@user-zl8vt8fz2d
@user-zl8vt8fz2d 10 ай бұрын
​@@RezaDorrani This worked, thanks. Now I need an additional filter, but I'm not sure if it is possible. The gallery (from a SP list) needs to filter based on if values in a column in the list are used in a library (via lookup). The library lookup column enforces unique values. So if those are used in the library, I'd like the gallery view to not display them. I was able to run a clearcollect on the library to pull all active values for the library column. Then I've been attempting to use Filter(source, isblank(lookup(clearcollectname, value=columnname.value)) but am getting errors. Any tips to finish this off?
@gowdhamansarangapani2123
@gowdhamansarangapani2123 2 жыл бұрын
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.
@RezaDorrani
@RezaDorrani 2 жыл бұрын
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
@baptiste5819
@baptiste5819 2 жыл бұрын
Great, as always
@RezaDorrani
@RezaDorrani 2 жыл бұрын
Thank you! Cheers!
@rickysydney4208
@rickysydney4208 3 жыл бұрын
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. "
@RezaDorrani
@RezaDorrani 3 жыл бұрын
Possible but I would have to test it out. I did a video long back on lookup column single select filter - kzfaq.info/get/bejne/ptRlY6R805m1YY0.html
@simonball5602
@simonball5602 Жыл бұрын
Awesome stuff
@RezaDorrani
@RezaDorrani Жыл бұрын
Thanks
@Danielx64
@Danielx64 2 жыл бұрын
Hi Reza, Great video. I haven't watched the full video as I am interested in the SharePoint part, my question is, is it worthwhile putting the data into a collection and then filter on that? That would reduce the API calls being made to SharePoint?
@RezaDorrani
@RezaDorrani 2 жыл бұрын
Thanks. SharePoint based check kzfaq.info/get/bejne/mNuae5WY37rIpYU.html Collection data is limited to 2000 records (delegation) + performance will be lower as collection data is held in memory on user's device. I will recommend directly connecting to SharePoint.
@panos6817
@panos6817 2 жыл бұрын
Thank you Reza, this is awesome. I have problem with filter reset button. When button pressed, all filters cleared but gallery is empty. If i set filters again, then the gallery works fine. Have you any idea?
@RezaDorrani
@RezaDorrani 2 жыл бұрын
You are probably not checking for conditions defined in filters. I will have to look at your App in action to provide guidance. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
@anthonypriest6726
@anthonypriest6726 2 жыл бұрын
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.
@RezaDorrani
@RezaDorrani 2 жыл бұрын
Not sure I understood the question. Check kzfaq.info/get/bejne/jdhkZbOWvJzDp4k.html for multi select choice columns
@anthonypriest6726
@anthonypriest6726 2 жыл бұрын
@@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.
@RezaDorrani
@RezaDorrani 2 жыл бұрын
@@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
@miguelgarcia-mulet7173
@miguelgarcia-mulet7173 Ай бұрын
Hi Reza, I followed your steps and everything works well, except that when I set the default value of the combo box to collected values of the checkboxes. The values show up in the combo box, but nothing appears in the gallery. ANy suggestions on what might be going on?
@RezaDorrani
@RezaDorrani Ай бұрын
Check description of video
@stayalive1017
@stayalive1017 2 жыл бұрын
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.
@RezaDorrani
@RezaDorrani 2 жыл бұрын
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
@Fernanda-uh7iz
@Fernanda-uh7iz 3 жыл бұрын
This video was a life saver!! Is it possible to download that demo?? I would like to look at commands and schemes in depth.
@RezaDorrani
@RezaDorrani 3 жыл бұрын
Check this video description - kzfaq.info/get/bejne/mNRza9hkzMq7o6c.html It has link to download the sample App.
@Fernanda-uh7iz
@Fernanda-uh7iz 3 жыл бұрын
@@RezaDorrani thanks sooooooooo much!!!!!!
@chanp004
@chanp004 11 ай бұрын
Hi Reza, thank you for this! I have created a PowerApp grid view gallery using your video. I have nearly 1000+ data in my Sharepoint list and have created Power App gallery grid with multiple filter boxes. When i search an item in a text input the gallery is very quick and responsive however when i have a dropdown box and select specific items the app crashes. I hope you can advise how to fix this. Appreciate your help, Love what you're doing!
@RezaDorrani
@RezaDorrani 11 ай бұрын
I have not come across an issue with filtering grid data. I have done 4-5 videos on grids and one of them shows filtering. You can try checking that. Also, I have not come across any performance issues and without reproducing it, I will not be able to provide any fix. It would be best to post your issue on forums at powerusers.microsoft.com
@ia5687
@ia5687 3 жыл бұрын
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
@RezaDorrani
@RezaDorrani 3 жыл бұрын
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
@ia5687
@ia5687 3 жыл бұрын
@@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 👍
@nirupambanik8794
@nirupambanik8794 2 жыл бұрын
Thanks for the tutorial. Is there any way to filter the related table (lookup) data.
@RezaDorrani
@RezaDorrani 2 жыл бұрын
Thanks. Which data source?
@vidhoo29
@vidhoo29 2 жыл бұрын
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.
@RezaDorrani
@RezaDorrani 2 жыл бұрын
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/
@BreatheAudio
@BreatheAudio 2 жыл бұрын
Hi Reza, love the videos, especially this one. Very clear and great examples. I'm just having an issue where the combo box will filter the gallery fine. And the check box will update the combo box but this doesn't filter the gallery, it returns no items. Any ideas why that might happen?
@RezaDorrani
@RezaDorrani 2 жыл бұрын
Try breaking the formula into parts. First check if you get data for checkbox query. Then check for combo box and then merge both. 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
@GraemesAdventures
@GraemesAdventures 2 жыл бұрын
@@RezaDorrani I also had an issue with this formula. Ended up breaking it into parts as you've suggested, and trying different variations of the syntax. I kept a record of each variation I tried so I could refer back to it. From your video around timestamp 6:50, IsBlank and IsEmpty worked fine, but the 3rd argument didn't. (For simplicity, I've transcribed my fields etc. into your terms, but my scenario is the same - I have a text box input and a combo box input...) You wrote: 'TaskStatus'=cbTaskStatusFilter.Selected.Value, and I narrowed it down to this argument. Eventually I found that I had to change the argument around, to: cbTaskStatusFilter.Selected.Value=TaskStatus.Value Then I progressively rebuilt the entire function in stages to check it still worked. I wonder if this is a change to PowerApps since you did this video? I've come across a few other things that seem to work differently now than when the help topics (not just yours) were written 2-3 years ago.
@RezaDorrani
@RezaDorrani 2 жыл бұрын
@@GraemesAdventures Thanks for the updates. Is your datasource Microsoft Dataverse? Im using Option Set type column in Dataverse. Based on your usage of .Value it looks like you are using Sharepoint choice column. Formula would differ based on column type.
@GraemesAdventures
@GraemesAdventures 2 жыл бұрын
@@RezaDorrani yes I'm in SharePoint
@RezaDorrani
@RezaDorrani 2 жыл бұрын
@@GraemesAdventures The video showcases example of Dataverse at the time you mentioned in the video. For choice columns, .Value is a must. I have videos on filtering specific to SharePoint as well on my channel.
@conniemaldonado4884
@conniemaldonado4884 2 жыл бұрын
Awesome video! Is there a way to have a drop down filter that contains all the items in a column - name for example. So instead of typing in the name, the user would select from a drop down based on the contents of the Name field. Is there another video that explains this? Thanks!
@RezaDorrani
@RezaDorrani 2 жыл бұрын
Thank You! Creating a dropdown that lists out all the values from a column would result in a delegation warning (will not work with large data sets). I do not have a video reference on this scenario though.
Power Apps Search and Filter Functions on Large SharePoint Lists
19:41
Do you know 10 ways you can filter a Power Apps gallery?
9:55
Shane Young
Рет қаралды 9 М.
50 YouTubers Fight For $1,000,000
41:27
MrBeast
Рет қаралды 192 МЛН
Mom's Unique Approach to Teaching Kids Hygiene #shorts
00:16
Fabiosa Stories
Рет қаралды 28 МЛН
I Can't Believe We Did This...
00:38
Stokes Twins
Рет қаралды 132 МЛН
Editable Grid in Power Apps | SharePoint List
42:49
Reza Dorrani
Рет қаралды 361 М.
Wait! Solve Delegation Easily! In Power Apps Search
29:57
Andrew Hess - MySPQuestions
Рет қаралды 2,9 М.
13.4 Filter, Search & Sort in Power Apps
26:17
Mayuresh Joshi (office365notes.com)
Рет қаралды 11 М.
PowerApps Filter Gallery by the Current User
22:16
Shane Young
Рет қаралды 115 М.
PowerApps filter gallery by dropdown
28:06
Shane Young
Рет қаралды 268 М.
How to Select MULTIPLE Items in Power Apps Gallery & PATCH
14:43
Reza Dorrani
Рет қаралды 37 М.