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

17 Comments
  1. Gajapathi K S 4 months ago

    Very rare content and useful example

  2. Vikas Shankar Mishra 4 months ago

    Very helpful thank you Reza for your effort !!

  3. Vignesh Kumar 4 months ago

    Thanks a lot Reza for your awesome videos. I can now avoid the delegation issue while multiple column sorting

  4. Naveen Kumar 4 months ago

    Thanks Reza….

  5. Altaf Malek 4 months ago

    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 ?

  6. Naveen Kumar 4 months ago

    If I reset filter controls, I get blank gallery. I did reset on search txt box, Drp control and gallery also…

  7. Aslam Parvez 4 months ago

    Thanks, Reza

  8. Sundra Pillay 4 months ago

    Thank you Reza

  9. Lohit Devgan 4 months ago

    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.

  10. zerocool 4 months ago

    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.

  11. Ranjit Singh 4 months ago

    Awesome video. Thank you for covering the delegation part. It is very useful.

  12. shanthan reddy Boddi 4 months ago

    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.

  13. Samit Bhattacharya 4 months ago

    Another amazing tutorial. Always in anticipation of something new in your videos. Keep it up.

  14. N S 4 months ago

    Great job Reza. Thanks for sharing

  15. Nilesh Marathe 4 months ago

    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.

  16. mattish ven 4 months ago

    That is cool. Your explaination in Each and every step is very clear in all the videos. You're are a Master of powerapps.

  17. Spencer Parry 4 months ago

    Brilliant. Please keep these videos coming.

Leave a reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

©2021 TDG - We Are Back Baby!

CONTACT US

We're not around right now. But you can send us an email and we'll get back to you, asap.

Sending
or

Log in with your credentials

or    

Forgot your details?

or

Create Account