Knocked it out of the park, again! I've been pondering about trying something like this, since I followed the left navigation component video. I'm have to have a go this evening. Thanks again Reza!
Update - works a treat and immediately created such a slicker experience which i think the users are going to love. (P.s. with the correct layering it works seamlessly with the Left Navigation from another of your videos)
@@jimmydoe1653 Awesome!!! I would love to see it or maybe share it (gif or pic) with the community. If you can share it then please send it to reza.dorrani@outlook.com
This is a year old video I stumbled upon as I am in process of building a new app for my business. Why am I not surprised to see such a simple way of filtering data. Fantastic Reza once again.
Being new to low coding, I had to work my way up to your videos. You are great, and I wish you prosperity in anything you do. Thank you so much for sharing what you know!!!
Reza, how do you never fail to amaze me and all your subscribers. I am in absolute awe of how you make functionality that is so important and vital to users appear so straightforward in your 18 mins videos. I suspect, if I would try and achieve these outcomes it would take literally 60 hours (not 16 mins) and I will still never get there. Keep going and continue to inspire and open up our eyes to the art of the possible with the PowerPlatform. Hope you get a well deserved and well rested winter break and look forward to what you bring to us in 2022!!!
It took me a long time to figure how to use two checkbox controls to filter a gallery. I ended up using an If statement to apply different Filters depending on if a checkbox was selected which made the code twice as long. But the way you showed it is much neater. Thank you for continuing to enlighten a rookie like me.
I just wanted to say thank you so much for your videos! I have been searching for how to combine dropdown filters with checkbox filters for longer than I'd like to admit and you solved it so easily! I've used many of your videos to build my Power App and they have been an amazing resource. Please keep posting videos!
Let's push the subs number to 32k by eoy go folks especially those whom desperate to see something new in SP...Here we go with Reza SP won't be boring anymore . Well done Reza , it's really wise that you're investing much in the SP area b/c SP is here to stay and that's the only realistic and viable solution for most org/companies at least at this point so we've got no option other than sticking around. Nope , No CDS or premiums for most of us even in the near future so any SP related content will be very appreciated . At least could you please give us advance notice in the video highlight when you use premium features.Thank you bro.
Thank You 🙏 For me the ❤️ of my subscribers is bigger than the number of subs. Thank You for all your support to my channel. I will keep trying my best to provide quality content.
This is great! One of the reasons I will shy away from Power Apps vs using list is because of the built in functions like filtering and clicking on people values and being able to dynamically get their contact info or start a chat with them. I find these so useful in my day to day. But this was really cool to see done in PowerApps.
Hey Reza, you may have noticed that I'm commenting in a bunch of your videos and I just want to say tank you, I learned a lot and implementing a powerapp (with some faults that I'm still trying to fix) it's been one of the most rewarding thing that I've done in like the past 7 years at work. I hope you keep on doing this videos because I really like your way of explaining (I tried with other creators but I got lost) now I just need to find a way to trim a string with a URL and get the picture stored in that URL 😄, again thanks for sharing the knowledge and I hope one of this days for you to be proud of me
Thanks for Sharing this .... Reza's Power Apps videos are like ... daily dose to learn something new in Power Apps, which sometimes we never get time to explore .. but could be used in our projects to make it more user friendly. unleashing the power of 'Power Apps'
Killer stuff Reza. Thus is going to save a lot of real estate and will look fancy and intuitive. Really loved it's going to apply this to my app tomorrow. Thanks for doing this. Learning everyday.
So valuable, it's incredible. Thx Reza ! I have to watch this video a couple of times and make myself notes like I did that in the past with your videos. You inspire us every time. You are amazing 🙌🙌🙌😀
Just wanted to say a huge thank you for all your videos Reza... this is another excellent one. As someone just learning the ropes.. this one might be a little tough for me.. but you make me feel like its within my grasp to achieve if I follow the video. Ill give it a go and see how I do. Thanks
You did it again, amazing and useful video. I am sure that I will update my galleries with this new filter system more elegant and modern hahahaha Thanks, I liked it a lot
Thank you for this. It has made a lot more room on the screen. Your videos are awesome. Is there a way to let the user filter more than 1 column in the text box as well as use the radio box. I tried to adding more startswith items with an or separator. The filter works great but the checkbox won't work?
Reza you did it again! I was looking to enhance my "filter dropdowns" for a gallery as I didn't like them (they were just "ok"). I really like this, but in addition can I use gallery "if" statements to default to a status such as "in-progress" when a user arrives to the app? I have a requirement to show that as main view, but also filter the same stuff you just taught.
Thank You so much! For the radio button control, you can set the default selection to "In Progress". This will ensure that filter is applied when user logs into the App.
This is amazing Reza thank you so much! The IsBlank function keeps is really clean but please could you explain why it works and shows all records if it is blank. I just can’t get my head around it!
Thank You! The IsBlank checks are running in an OR (||) condition with the filters. If IsBlank condition is true (empty scenarios), the OR function will evaluate to true. true OR anything else is true! Hence it will return all the results.
This is really helpful! Can I request you to guide on how you have created the variable and used Set() function ? I have searched a lot of videos but no one explains so meticulously like you. Hoping forward to have another video on Set variables from your channel!
@@RezaDorrani Great! Really looking forward to that! Also thanks for making these elaborative videos, really helped a lot for understanding and developing low code apps easily.
Fantastic logics.. Awesome get to know short and excellent logic from your videos as always.. Want to confirm one thing : If we are working with large data set in SharePoint, which datatypes are recommended to avoid delegate errors ? Choice type you took in this video won't create delegation warning ?
Everything showcased in this video is delegable. I have covered delegation end to end. Here is my playlist - ruclips.net/p/PLTyFh-qDKAiE6ia-D94Qk5-AzpN4dqOmD
Great video Reza. Everything works fine - the only issue I am having is that I have included a Form next to the gallery/container so that it is on the same screen. I have attempted to link the form to the gallery, however it no longer updates when I select a record from the gallery. I have included Gallery.Selected on under Items on the form, however it still does not update upon selection of a record from the gallery. I am not sure if this is because of the code used for the filter Panel? Any help would be so appreciated.
Hi Reza, this is it! I knew how to filter on multiple conditions but always struggled with multiple checkboxes. Thank you! I also wonder, would it be possible to change this into component? I tried to create such component on my own, for simplicity only with combo-boxes. I'm struggling with getting selected data out of component to use in gallery filter function. Any advices?
Possible for sure but not something that I have done or tried. May be check on forums in case someone has done something similar powerusers.microsoft.com
Hi Reza! Amazing video again, super helpful! I have a small question that until now nobody was able to answer me... Is it possible to know if the user is using the App on Browser or in Teams? To later make a variable and make the App more adjusted to browser or team?
Check thepoweraddict.com/how-to-deep-link-into-teams-from-power-apps/ May be it helps. I will also recommend you check on the forums at powerusers.microsoft.com/
Another great video, Reza! Do you have any recommendations for how one might apply a filter between two dates? I was able to add this to my filter pane and the filter seems to work; however, I am stuck on the following issue: if one of my dates is not selected, then no items will appear in my gallery. I suppose the solution I am looking for is something that will say if the From Date Picker is blank, then the From Date would be 01/01/2001 (this would capture all dates from before) AND if the To Date Picker is blank, then the To Date would be Today. I have seen some videos out there with some different solutions, but none seem to work easily with the Filter Pane I created using your tutorial. What are your thoughts?
I would have to try it out to know how best to design the filter condition. I have done a video on multiple filters in gallery which may help. I would also recommend checking on forums in case someone has done something similar
Hi Reza - Thank you for all your help! Is it possible to have a SharePoint custom form that is surfaced on a SharePoint site via a quick link return to that SharePoint home page when the form is saved instead of navigating the user to the list? We'd like the user to just interact with the form, Save or Cancel, and then go back to the homepage where the quick link is and where they started.
I am not sure if this is possible. You could try appending a query param called source to the url. Something like Yourquicklinkurl?source=urlofpageroredirect
Great information, as always Reza, thanks so much for your excellent videos. I've run into an odd issue, the Filter works well for my controls (three dropdowns), but as soon as I add the text search to the delegable Filter, not all records are returned from the SharePoint list. Currently this is a small list, but has the potential to grow so I'm trying to build to work-around the delegation issue. It is always the last three records that were added that will not be included with the search piece intact - as soon as I remove the search piece they are included in the result set and filter correctly. What might I be missing?
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
Hello Reza, great video. Is it possible to use your people picker trick for more than 1 person-type column? I have tried using 2 people pickers at the same gallery filter pane but it seems only one of them can work at the same time.
Yes possible. It depends on how you have configured the filter AND and OR scenario. 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
Reza, thanks for the instructions provided. As I follow your process I am having an issue where I cut the Gallery and Past in the Container. Once I paste in the container, I lose all rectangles, color formatting, etc. Assume I am doing something wrong. can you assist?
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
Great video Reza. Thank you. If I may ask, what if you have more filters to be applied, how do you make the container scrollable in order to accomodate them? Thank you in advance for your prompt reply.
Hi, great video, I have a question though, I am filtering using multiple text based fields as well as choice and date fields and I cannot seem to get this to work, when only one filter text is enetered it doesn't return any result, happy to share the inof path for help, i think its something simple.
Hi Reza, Great video, thanks for that.. when I try to reset the filters, search box i.e. text box is getting reset but the gallery items disappear.. any solution for this?
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
@@RezaDorrani Thanks for the reply, since I didn't give a default value, every time I hit reset, gallery items disappeared. Fixed it. Thanks for all the awesome videos, very helpful.
Is it possible to have multiple filters on multiple Sharepoint lists? I would like to populate a gallery with data selected on a specific coloumn, but then further refine this by selecting another filter based on a coloumn from a separate list.
Seems like Inception :) Looks like you need a gallery that loads data from multiple lists. For that you would need to first load all the data into a collection. Then apply all your filters on that one collection.
Video shows exactly that. Your gallery might be empty because probably your filter formula is not framed correctly. 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
Another great tutorial, but can you help me with the following, when I click clear, that is call Reset(textBox)&&Reset(radioButtons) the gallery goes blank. I then have to close the browser and reopen the powerapps environment to see gallery items again
I will need to see your app in action to know the reason you are facing the issue. I recommend posting your issue with screenshots on the forums at powerusers.microsoft.com
Hi Reza, once again a great tutorial - thank you as always! I have applied the multi-select combo box filter to a gallery, but is it possible to add a filter that excludes a specific category from the sharepoint list? I want the unfiltered app gallery to display all categories except one, in addition to having the other filters available. I have tried this: Filter( 'Lean Tracker_1', IsBlank(ComboBox1.SelectedItems.Value) || IsEmpty(ComboBox1.SelectedItems) || true in ForAll(Category.Value, ThisRecord in ComboBox1.SelectedItems.Value) && Category.Value "HR Confidential" ->> this is the line that creates the error but I want the gallery to exclude that one category ) Any guidance is appreciated. Thanks!
Possible is my guess but I have not tried this before and would have to try it out to provide guidance. I will recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.
@@RezaDorrani thanks for the suggestion! I was able to make it work by adding !("HR Confidential" in Category.Value) && before the other filters. I appreciate your great videos, you are a wealth of knowledge!
Any way to display documents from multiple libraries using the same concept (site column) in one gallery? Trying to create a single gallery view for multiple doc libs. Not sure which functions to use or how to configure it
You would need to load data from both libraries into a collection. A gallery only works with 1 data source. I do not have a video on this use case. I would recommend to post your query on the forums at powerusers.microsoft.com in case someone has done something similar.
Hi Reza.. I tried to recreate the editable grid experience by watching your video and tried to bulk update using collection.. The only difference was I used a Text box, a Radio button( choice) and a Toggle.. strangely the onchange, on select are not working as expected to store the updates.. Can you tell me for the above inputs, where should I write the collect/ update query ?
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
Hi Reza, I have followed the video step by step to apply the status part, I have the status column that is a choice field in my sharepoint list, but I want the "Completed" items to initially be invisible in gallery, I want them to show only when user selected "Completed" choice from filter pane. how can I achieve that?
Hi, thanks for the video. I tried to copy the same code into the search textbox, but it returns "Expected Text Value", and that my filter returns a table value which is not compatible. Filter('testing action item',StartsWith('Action Description',TextInput2.Text)) Where 'testing action item' is my source list, and TextInput2 is the search textbox. Could I get some help on this? Thank you!
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
I tried to recreate this. However, when i cut my gallery and paste to horizontal container, the positioning of gallery icons and labels were shuffled. What should i do?
You can use the responsive container control properties to re-position gallery + update the gallery template size and controls within gallery. Difficult to explain here on chat. I will recommend posting your issue with screenshots on the forums at powerusers.microsoft.com/
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
Hi Reza Dorrani, I would like to say its really great Job what you are doing, I need small help if you don't mind, I followed all steps that you have mentioned but unfortunately i am stuck in detail and Display forms, they are not getting data from The Gallery under the Container, I do have the below in my power app BrowserScreen1: Horizontal Container , BrowserGallery1, Filterpane, DetailScreen1: DetailForm1, EditeScreen1 where i have the EditForm1 I created in DetailsScreen1 "DetailForm1" and in EditeScreen1 "EditeForm1" under Item: BrowseGallery1.Selected but it does get any data,. I have created new screen "BrowseGallery2" and another screen to create "formviewr1" without any Container and it gets data, when i pointed GalleryScreen2 to my "detailscreen1" and "editscreen1" it acts crazy and dose not give the right results. hope you have solution to let both Edit and Display forms to read data from the gallery under the container
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
Great content as usual Reza, but what's with your audio lately? It's cutting off to complete silence after you stop speaking and it sounds so unnatural.
Let's push the subs number to 32k by eoy go folks especially those whom desperate to see something new in SP...Here we go with Reza SP won't be boring anymore . Well done Reza , it's really wise that you're investing much in the SP area b/c SP is here to stay and that's the only realistic and viable solution for most org/companies at least at this point so we've got no option other than sticking around. Nope , No CDS or premiums for most of us even in the near future so any SP related content will be very appreciated . At least could you please give us advance notice in the video highlight when you use premium features.Thank you bro. .
Hi Reza, How do I put a scroll bar inside a gallery on a individual data card so that data within the card can be scrolled through. Like I have a data card that have a ton of zip codes and I need the user to be able to scroll them in that data card within the main gallery.
Not sure. Something to try out for me. I will recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.
Knocked it out of the park, again! I've been pondering about trying something like this, since I followed the left navigation component video. I'm have to have a go this evening. Thanks again Reza!
Thanks Jimmy.
Go for it!
Update - works a treat and immediately created such a slicker experience which i think the users are going to love. (P.s. with the correct layering it works seamlessly with the Left Navigation from another of your videos)
@@jimmydoe1653 Awesome!!! I would love to see it or maybe share it (gif or pic) with the community.
If you can share it then please send it to reza.dorrani@outlook.com
This is a year old video I stumbled upon as I am in process of building a new app for my business. Why am I not surprised to see such a simple way of filtering data. Fantastic Reza once again.
Thanks so much! Old is gold
Being new to low coding, I had to work my way up to your videos. You are great, and I wish you prosperity in anything you do. Thank you so much for sharing what you know!!!
Thank You so much for your kind words 🙏
Reza, how do you never fail to amaze me and all your subscribers. I am in absolute awe of how you make functionality that is so important and vital to users appear so straightforward in your 18 mins videos.
I suspect, if I would try and achieve these outcomes it would take literally 60 hours (not 16 mins) and I will still never get there.
Keep going and continue to inspire and open up our eyes to the art of the possible with the PowerPlatform.
Hope you get a well deserved and well rested winter break and look forward to what you bring to us in 2022!!!
Thank You for your kind words 🙏
Brother you are the best of best power apps trainer in the world
Thank You!!!
It took me a long time to figure how to use two checkbox controls to filter a gallery. I ended up using an If statement to apply different Filters depending on if a checkbox was selected which made the code twice as long. But the way you showed it is much neater. Thank you for continuing to enlighten a rookie like me.
Awesome! Thanks for watching.
I just wanted to say thank you so much for your videos! I have been searching for how to combine dropdown filters with checkbox filters for longer than I'd like to admit and you solved it so easily! I've used many of your videos to build my Power App and they have been an amazing resource. Please keep posting videos!
Thank You so much for the awesome feedback. I will keep trying my best.
Let's push the subs number to 32k by eoy go folks especially those whom desperate to see something new in SP...Here we go with Reza SP won't be boring anymore .
Well done Reza , it's really wise that you're investing much in the SP area b/c SP is here to stay and that's the only realistic and viable solution for most org/companies at least at this point so we've got no option other than sticking around. Nope , No CDS or premiums for most of us even in the near future so any SP related content will be very appreciated . At least could you please give us advance notice in the video highlight when you use premium features.Thank you bro.
Thank You 🙏
For me the ❤️ of my subscribers is bigger than the number of subs.
Thank You for all your support to my channel.
I will keep trying my best to provide quality content.
This is great! One of the reasons I will shy away from Power Apps vs using list is because of the built in functions like filtering and clicking on people values and being able to dynamically get their contact info or start a chat with them. I find these so useful in my day to day. But this was really cool to see done in PowerApps.
Glad to hear that! Thanks for watching.
Thanks!
👍
Well this was beautiful followed this from start to finish for my app, I can say now fell more confident with filtering galleries now!
Great to hear!
Wow! Another wonderful video, Reza! Thank you for sharing your amazing ideas. That's a new level in apps. THANK YOU!!!
Glad to hear that. Thank You for watching.
Great stuff Reza. Just when I think implementing something like this will soooo difficult, you show us how easy it can be. Thank you.
Thanks Joey!
your videos take me to a new level in powerapps. thank you
Wow, thanks
Reza with another "reza" sharp explanation. Thanks for that
My pleasure!
Hey Reza, you may have noticed that I'm commenting in a bunch of your videos and I just want to say tank you, I learned a lot and implementing a powerapp (with some faults that I'm still trying to fix) it's been one of the most rewarding thing that I've done in like the past 7 years at work. I hope you keep on doing this videos because I really like your way of explaining (I tried with other creators but I got lost) now I just need to find a way to trim a string with a URL and get the picture stored in that URL 😄, again thanks for sharing the knowledge and I hope one of this days for you to be proud of me
Thank You so much Eduardo. It feels good to hear such amazing feedback. I will keep trying my best to keep going.
Thanks for Sharing this .... Reza's Power Apps videos are like ... daily dose to learn something new in Power Apps, which sometimes we never get time to explore .. but could be used in our projects to make it more user friendly.
unleashing the power of 'Power Apps'
Thank You Nishi.
Killer stuff Reza. Thus is going to save a lot of real estate and will look fancy and intuitive. Really loved it's going to apply this to my app tomorrow. Thanks for doing this. Learning everyday.
Awesome! Thank You.
So valuable, it's incredible. Thx Reza ! I have to watch this video a couple of times and make myself notes like I did that in the past with your videos. You inspire us every time. You are amazing 🙌🙌🙌😀
Thank You :)
Wonderful tutorial, extremely professional development.
Thanks
Taking filters to the next level. Thank you Sir
Your most welcome
Excellent session Reza
Thank You
Just wanted to say a huge thank you for all your videos Reza... this is another excellent one. As someone just learning the ropes.. this one might be a little tough for me.. but you make me feel like its within my grasp to achieve if I follow the video. Ill give it a go and see how I do. Thanks
Thank You so much Jason!
Realy good i am very happy to follow your videos .
Thanks for the follow Peter
Perfect Reza, just want I needed to do today. Thanks mate!
Awesome! Thanks.
Awesome thanks for Sharing
Thanks for watching
You did it again, amazing and useful video. I am sure that I will update my galleries with this new filter system more elegant and modern hahahaha
Thanks, I liked it a lot
Thanks Juan. Glad it was helpful!
Thanks for another knowledge shared. I have learnt something new from it
Glad to hear it! Thanks for watching.
I was in need of this I saw this filter in an app deveoped by other team I wanted know how it is achieved . Thank you so much ❤😊
My pleasure 😊
Great Work, thank you very much!
Most welcome and thanks for watching
It is amazing Video Reza, Thank so Much
Most welcome
👍✨ Will be referring back to this video a LOT. Thanks Reza.✨👍
Thanks Spen
Awesome video Reza.. thanks 👍🙏👌
Thanks for watching Ajay
Very helpful 👍.
Glad it was helpful!
Thank you for this. It has made a lot more room on the screen. Your videos are awesome. Is there a way to let the user filter more than 1 column in the text box as well as use the radio box. I tried to adding more startswith items with an or separator. The filter works great but the checkbox won't work?
Glad to hear that!
You can combine multiple filters using AND & OR operators.
I have done several videos on multiple filter conditions.
Reza you did it again! I was looking to enhance my "filter dropdowns" for a gallery as I didn't like them (they were just "ok"). I really like this, but in addition can I use gallery "if" statements to default to a status such as "in-progress" when a user arrives to the app? I have a requirement to show that as main view, but also filter the same stuff you just taught.
Thank You so much!
For the radio button control, you can set the default selection to "In Progress". This will ensure that filter is applied when user logs into the App.
This is amazing Reza thank you so much! The IsBlank function keeps is really clean but please could you explain why it works and shows all records if it is blank. I just can’t get my head around it!
Thank You!
The IsBlank checks are running in an OR (||) condition with the filters.
If IsBlank condition is true (empty scenarios), the OR function will evaluate to true.
true OR anything else is true! Hence it will return all the results.
@@RezaDorrani that’s brilliant! So clever! Thank you for explaining 😊
This is really helpful! Can I request you to guide on how you have created the variable and used Set() function ? I have searched a lot of videos but no one explains so meticulously like you. Hoping forward to have another video on Set variables from your channel!
I have a video planned in my backlog on "Power Apps Variables".
@@RezaDorrani Great! Really looking forward to that! Also thanks for making these elaborative videos, really helped a lot for understanding and developing low code apps easily.
Thanks Reza!!!
👍
Fantastic logics.. Awesome get to know short and excellent logic from your videos as always..
Want to confirm one thing : If we are working with large data set in SharePoint, which datatypes are recommended to avoid delegate errors ?
Choice type you took in this video won't create delegation warning ?
Everything showcased in this video is delegable.
I have covered delegation end to end. Here is my playlist - ruclips.net/p/PLTyFh-qDKAiE6ia-D94Qk5-AzpN4dqOmD
Great video Reza. Everything works fine - the only issue I am having is that I have included a Form next to the gallery/container so that it is on the same screen. I have attempted to link the form to the gallery, however it no longer updates when I select a record from the gallery. I have included Gallery.Selected on under Items on the form, however it still does not update upon selection of a record from the gallery.
I am not sure if this is because of the code used for the filter Panel? Any help would be so appreciated.
This has no relation to the filter panel. I have done multiple videos on gallery connected forms. Check and see if those help.
Hi Reza, this is it! I knew how to filter on multiple conditions but always struggled with multiple checkboxes. Thank you! I also wonder, would it be possible to change this into component? I tried to create such component on my own, for simplicity only with combo-boxes. I'm struggling with getting selected data out of component to use in gallery filter function. Any advices?
Possible for sure but not something that I have done or tried.
May be check on forums in case someone has done something similar
powerusers.microsoft.com
Hi Reza!
Amazing video again, super helpful!
I have a small question that until now nobody was able to answer me...
Is it possible to know if the user is using the App on Browser or in Teams? To later make a variable and make the App more adjusted to browser or team?
Check thepoweraddict.com/how-to-deep-link-into-teams-from-power-apps/
May be it helps.
I will also recommend you check on the forums at powerusers.microsoft.com/
Another great video, Reza! Do you have any recommendations for how one might apply a filter between two dates? I was able to add this to my filter pane and the filter seems to work; however, I am stuck on the following issue: if one of my dates is not selected, then no items will appear in my gallery. I suppose the solution I am looking for is something that will say if the From Date Picker is blank, then the From Date would be 01/01/2001 (this would capture all dates from before) AND if the To Date Picker is blank, then the To Date would be Today. I have seen some videos out there with some different solutions, but none seem to work easily with the Filter Pane I created using your tutorial. What are your thoughts?
I would have to try it out to know how best to design the filter condition. I have done a video on multiple filters in gallery which may help. I would also recommend checking on forums in case someone has done something similar
Awesome
Thanks
Hi Reza - Thank you for all your help! Is it possible to have a SharePoint custom form that is surfaced on a SharePoint site via a quick link return to that SharePoint home page when the form is saved instead of navigating the user to the list? We'd like the user to just interact with the form, Save or Cancel, and then go back to the homepage where the quick link is and where they started.
I am not sure if this is possible. You could try appending a query param called source to the url.
Something like
Yourquicklinkurl?source=urlofpageroredirect
Great information, as always Reza, thanks so much for your excellent videos. I've run into an odd issue, the Filter works well for my controls (three dropdowns), but as soon as I add the text search to the delegable Filter, not all records are returned from the SharePoint list. Currently this is a small list, but has the potential to grow so I'm trying to build to work-around the delegation issue. It is always the last three records that were added that will not be included with the search piece intact - as soon as I remove the search piece they are included in the result set and filter correctly. What might I be missing?
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
Hello Reza, great video. Is it possible to use your people picker trick for more than 1 person-type column? I have tried using 2 people pickers at the same gallery filter pane but it seems only one of them can work at the same time.
Yes possible. It depends on how you have configured the filter AND and OR scenario. 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
Reza, thanks for the instructions provided. As I follow your process I am having an issue where I cut the Gallery and Past in the Container. Once I paste in the container, I lose all rectangles, color formatting, etc. Assume I am doing something wrong. can you assist?
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
@@RezaDorrani Thanks for the quick response. I have posted as you suggested. Issue is titled "Adding Container for Filter".
@@ImGumby49 There are many experts on forums who assist. I only go to forums in my free time.
Great video Reza. Thank you. If I may ask, what if you have more filters to be applied, how do you make the container scrollable in order to accomodate them? Thank you in advance for your prompt reply.
There is a screen template called scrollable screen. You can grab the scrollable canvas control from there and use it for the filter section.
@@RezaDorrani Thank you. Did it and worked just fine.
@@MichaelGer Awesome!
Thanks Reza
You are most welcome
Hi,
great video, I have a question though, I am filtering using multiple text based fields as well as choice and date fields and I cannot seem to get this to work, when only one filter text is enetered it doesn't return any result, happy to share the inof path for help, i think its something simple.
Managed to solve it I was using blank() but forgot since I've added a prentend blank field in dropdown picker it's not actually blank
Looks like you got it to work based on your response comment
@@RezaDorrani Nice to see a quick response from yourself regardless well done 😃
Hi Reza, Great video, thanks for that.. when I try to reset the filters, search box i.e. text box is getting reset but the gallery items disappear.. any solution for this?
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
@@RezaDorrani Thanks for the reply, since I didn't give a default value, every time I hit reset, gallery items disappeared. Fixed it. Thanks for all the awesome videos, very helpful.
Is it possible to have multiple filters on multiple Sharepoint lists? I would like to populate a gallery with data selected on a specific coloumn, but then further refine this by selecting another filter based on a coloumn from a separate list.
Seems like Inception :)
Looks like you need a gallery that loads data from multiple lists. For that you would need to first load all the data into a collection. Then apply all your filters on that one collection.
Great Video, Reza I want to show the gallery by default with all items, but it shows empty when I go to the GalleryScreen. (any Help)?
Video shows exactly that. Your gallery might be empty because probably your filter formula is not framed correctly. 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
@@RezaDorrani solved that too by re watching your video ❤️❤️ tons of thanks
Another great tutorial, but can you help me with the following, when I click clear, that is call Reset(textBox)&&Reset(radioButtons) the gallery goes blank.
I then have to close the browser and reopen the powerapps environment to see gallery items again
I will need to see your app in action to know the reason you are facing the issue. I recommend posting your issue with screenshots on the forums at powerusers.microsoft.com
Hi Reza, Can I insert filter/Slicer in PowerApps Edit Form to? Where I need data to populate by the selected text search. Thanks
Possible but I do not have any video references on it. Typically slicers are used to filter gallery data.
@@RezaDorrani Thank you
Hi Reza, once again a great tutorial - thank you as always! I have applied the multi-select combo box filter to a gallery, but is it possible to add a filter that excludes a specific category from the sharepoint list? I want the unfiltered app gallery to display all categories except one, in addition to having the other filters available. I have tried this:
Filter(
'Lean Tracker_1',
IsBlank(ComboBox1.SelectedItems.Value) || IsEmpty(ComboBox1.SelectedItems) || true in ForAll(Category.Value, ThisRecord in ComboBox1.SelectedItems.Value)
&& Category.Value "HR Confidential" ->> this is the line that creates the error but I want the gallery to exclude that one category
)
Any guidance is appreciated. Thanks!
Possible is my guess but I have not tried this before and would have to try it out to provide guidance.
I will recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.
@@RezaDorrani thanks for the suggestion! I was able to make it work by adding !("HR Confidential" in Category.Value) && before the other filters. I appreciate your great videos, you are a wealth of knowledge!
Any way to display documents from multiple libraries using the same concept (site column) in one gallery? Trying to create a single gallery view for multiple doc libs. Not sure which functions to use or how to configure it
You would need to load data from both libraries into a collection. A gallery only works with 1 data source. I do not have a video on this use case. I would recommend to post your query on the forums at powerusers.microsoft.com in case someone has done something similar.
Hi Reza.. I tried to recreate the editable grid experience by watching your video and tried to bulk update using collection.. The only difference was I used a Text box, a Radio button( choice) and a Toggle.. strangely the onchange, on select are not working as expected to store the updates.. Can you tell me for the above inputs, where should I write the collect/ update query ?
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
Is it possible to patch set variable or update context variable or table without using collection
Patch function accepts single records or collections. You can use either.
hi reza, what if due date of a record is empty? how do you add that to the gallery where the records should only show due dates that are not blank??
Try Not(IsBlank
Reza,can we make this filter pane scrollable?if so,how can we achieve it.
I believe so. How? I'm not sure :) I would have to try it out.
I will recommend checking on the forums at powerusers.microsoft.com/
Hi Reza,
I have followed the video step by step to apply the status part, I have the status column that is a choice field in my sharepoint list, but I want the "Completed" items to initially be invisible in gallery, I want them to show only when user selected "Completed" choice from filter pane. how can I achieve that?
I would have to try this out to provide the steps.
I recommend posting your query on forums at powerusers.microsoft.com
Hi, thanks for the video. I tried to copy the same code into the search textbox, but it returns "Expected Text Value", and that my filter returns a table value which is not compatible.
Filter('testing action item',StartsWith('Action Description',TextInput2.Text))
Where 'testing action item' is my source list, and TextInput2 is the search textbox.
Could I get some help on this?
Thank you!
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
How can me make the filter pane as scrollable ? half of the filters I add is not displaying within the screen
The container control where filters are added can be a responsive container which overflows & shows a scroll bar.
Give that a try.
I tried to recreate this. However, when i cut my gallery and paste to horizontal container, the positioning of gallery icons and labels were shuffled. What should i do?
You can use the responsive container control properties to re-position gallery + update the gallery template size and controls within gallery. Difficult to explain here on chat.
I will recommend posting your issue with screenshots on the forums at powerusers.microsoft.com/
Thank you Reza is it possible to share the app please thanks
Here it is github.com/rdorrani/PowerApps/blob/master/FilterPane_20211125185316.zip
hi it worked for me , but when I code the condition for checkbox, the search buttons and radio button don't work
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
Hi Reza Dorrani, I would like to say its really great Job what you are doing, I need small help if you don't mind, I followed all steps that you have mentioned but unfortunately i am stuck in detail and Display forms, they are not getting data from The Gallery under the Container, I do have the below in my power app
BrowserScreen1: Horizontal Container , BrowserGallery1, Filterpane,
DetailScreen1: DetailForm1, EditeScreen1 where i have the EditForm1
I created in DetailsScreen1 "DetailForm1" and in EditeScreen1 "EditeForm1" under Item: BrowseGallery1.Selected but it does get any data,.
I have created new screen "BrowseGallery2" and another screen to create "formviewr1" without any Container and it gets data, when i pointed GalleryScreen2 to my "detailscreen1" and "editscreen1" it acts crazy and dose not give the right results.
hope you have solution to let both Edit and Display forms to read data from the gallery under the container
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
Great content as usual Reza, but what's with your audio lately? It's cutting off to complete silence after you stop speaking and it sounds so unnatural.
Thank You for liking the content and I appreciate the feedback on the audio.
I will work on that.
am I the only one that sees a blurry screen on all his vids?
Yes :)
Let's push the subs number to 32k by eoy go folks especially those whom desperate to see something new in SP...Here we go with Reza SP won't be boring anymore .
Well done Reza , it's really wise that you're investing much in the SP area b/c SP is here to stay and that's the only realistic and viable solution for most org/companies at least at this point so we've got no option other than sticking around. Nope , No CDS or premiums for most of us even in the near future so any SP related content will be very appreciated . At least could you please give us advance notice in the video highlight when you use premium features.Thank you bro. .
Thank You Yehun 🙏
Hi Reza, How do I put a scroll bar inside a gallery on a individual data card so that data within the card can be scrolled through. Like I have a data card that have a ton of zip codes and I need the user to be able to scroll them in that data card within the main gallery.
Not sure. Something to try out for me. I will recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.