This beginners video tutorial on Power Apps Sort and Filter on Multiple Columns in a gallery covers all the basics of using the Sort, SortByColumns and the Filter function together. We will perform dynamic sorting and filtering of gallery data all while keeping delegation (working with large lists) in mind. We will sort and filter on multiple columns and perform search operations on data using StartsWith function with SharePoint List as a data source. These basics on Sorting and Filtering of PowerApps data in a gallery or a datatable are important for every Power Apps maker to learn.
#PowerApps #Sort #SharePoint #Filter
Delegation:
https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/delegation-overview
SharePoint Sort and Filter function delegation:
https://docs.microsoft.com/en-us/connectors/sharepointonline/#power-apps-delegable-functions-and-operations-for-sharepoint
My playlist on delegation and data filtering of gallery:
Sort and Filter formula showcased in video:
https://github.com/rdorrani/PowerApps/blob/master/sortandfilter.txt
Table of Contents:
00:00 – Intro
00:20 – SortByColumns in Power Apps Gallery on Text, Number and Date columns
03:47 – Sort function in Power Apps on Choice / Dropdown & expressions
09:14 – Combining Sorting with Filtering on Multiple Columns
13:35 – Add sort button and sort direction Icon
21:33 – Subscribe
Very rare content and useful example
Very helpful thank you Reza for your effort !!
Thanks a lot Reza for your awesome videos. I can now avoid the delegation issue while multiple column sorting
Thanks Reza….
Hello Reza,
I am regularly watching your video. All of your videos are very useful and easy to understand.
I want to filter the gallery with predefined thee Customer name in the exclusion list.
I want to filter the gallery with all the customer name except predefined three name. which i do not want to see in the gallery.
Is this possible ?
If I reset filter controls, I get blank gallery. I did reset on search txt box, Drp control and gallery also…
Thanks, Reza
Thank you Reza
Hey Reza, Thanks for your videos. I am learning alot from your channel. I am working on a vehicle inspection application. Can you just make a one tutorial to how to create a tabbed form and give the user an option to take an image and save it in a particular record. I mean with the information and the image .It ll be helpful. Thanks.
Reza this is Amazing as usual with all your content. In terms of new videos, I'd love to see you re-do the repeating Grid video but with Sharepoint as a data source and not CDC. Thank you.
Awesome video. Thank you for covering the delegation part. It is very useful.
This is a great stuff with a combination of SharePoint Online and Powerapps. That would be great if you can post a session how can we create a SharePoint list Grid view in the gallery.
Another amazing tutorial. Always in anticipation of something new in your videos. Keep it up.
Great job Reza. Thanks for sharing
Very nice and informative video. I have one query regarding my one of the issue, I wanted to show data from sharepoint list Title field in PowerApps ComboBox and my Sharepoint list is having items more than 5000. Could you please suggest the best approach to achieve this.
That is cool. Your explaination in Each and every step is very clear in all the videos. You're are a Master of powerapps.
Brilliant. Please keep these videos coming.