Power Apps Sort and Filter on Multiple Columns

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:
SharePoint Sort and Filter function delegation:
My playlist on delegation and data filtering of gallery:
Sort and Filter formula showcased in video:

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

[learningsessions]

Thanks a lot for sharing this, it solved an actual scenario when you use search as well as want user specific dynamic sorting :-)

[coopertkm]

Brilliant content. I've seen other videos on these topics but none that combine all of the features together in one clear and working example. I am learning PowerApps for use at work and I have now subscribed to your channel based on this video alone. Great work!

[jelin]

Above and beyond, even the last part about delegation. Perfect video!

[michelfernandes]

Thanks very much for the video. I'm from the Brazil, and my english is very basic, but you bothered to speak clearly and slowly, so that everyone understands. Thanks!

[tibortot]

'Brilliant' describes the quality of this session. I face the problem, and there is Reza's video that exactly solves it. Not only solving it, but I learn so much from it.

[dankirchner]

This method is by far the easiest I have seen to achieve the end result. Thank you Reza!

[vigneshkumar]

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

[RanjitSingh-xksb]

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

[samitbhattacharya]

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

[latinmaxdfc]

Hi Reza!
This video has been pretty useful to me. Just one observation. Please go to minute 21:16. There is a bug on the formula that checks sort direction. You wrote: "If ( varSortColumn = Ascending, Ascending, Descending)". It should have been: "If ( varSortDirection = Ascending, Ascending, Descending)". That´s why the sort icons seem to work unproperly as you might see between minutes 21:23 to 21:30.

[mwmstals]

I was wrestling with multiple filters for my gallery. This is a great help, thanks!

[christianreed]

This is an excellent tutorial, shortened my formula by at least 40 lines and improved app speed

[MadRockway]

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

[TracyOsimowicz]

Super helpful video! Was able to troubleshoot and role out my app for user testing same day. Much appreciated!

[designmycity]

This is exactly what I was looking for. Thank you very much for this great video.

[celinegebara]

Hi Reza, you are amazing and helped so much with my project. Just wanted to let you know! Keep it up!

[spen]

Brilliant. Please keep these videos coming.

[EpicBizHero]

ANOTHER Life-saver... THANK YOU REZA!!!

[zerocool]

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.

[youtube_Salim]

you are the best Mr Reza, thank you for everything