Power Apps Sort and Filter on Multiple Columns

[@learningsessions4584]

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

[@RezaDorrani]

Glad to hear that!

[@michelfernandes3445]

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!

[@RezaDorrani]

Thanks Michel. Glad to hear this feedback. I have worked on my speech to ensure I speak slower and clear. Very happy to hear that folks are seeing improvements.

[@dankirchner4460]

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

[@RezaDorrani]

Thanks so much Dan

[@jelin5233]

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

[@RezaDorrani]

Thank You

[@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.

[@RezaDorrani]

Thats correct! Many have reported this in comments :)

[@christianreed4396]

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

[@RezaDorrani]

Awesome 👍

[@tibortot8148]

'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.

[@RezaDorrani]

Thanks so much for the awesome feedback.

[@davidrico8755]

Thanks!

[@RezaDorrani]

Thanks David

[@vigneshkumar271]

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

[@RezaDorrani]

Glad to hear that

[@youtube_Salim]

you are the best Mr Reza, thank you for everything

[@RezaDorrani]

Thanks Salim

[@guilhermeborba5741]

The King of Power Apps. Thank You!

[@RezaDorrani]

Content is 👑 Thank You

[@mwmstals]

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

[@RezaDorrani]

Great to hear!

[@travelbuffs360]

Thanks for this video, It solved the most demanded features from my app users.

[@RezaDorrani]

Glad to hear that. Thanks for watching.

[@DutchNorthAtlanticAlliance]

PERFECT!!! Amazing work brother!!!

[@RezaDorrani]

Thank you! Cheers!

[@antoniobranderas]

Hey Reza, I watched this video in 2022 and implemented the use of variables for sorting the SortByColumns (14:38) formula and it’s been working great. Yesterday, the editor started showing a warning ⚠️ about the use of a variable instead of using the “name directly” in the formula. I believe it is a bug. When I hover over the variable I see it is set to “Modified” which is the Modified field on a SharePoint list. When I code in “Modified” it stops complaining. When I swap back to the variable, it complains but still works when I select a different column name from the dropdown. Here is the full warning message: “The expression ‘variableName’ may represent a column that is not part of the data source or has not been downloaded. Consider using the name directly.” The source is a collection. When I view the collection, all columns listed as options in the dropdown are present. The warnings disappear when I directly use the name. Authoring version is 3.23.114.25 but published with 3.23.113.30 for some reason.

[@RezaDorrani]

Sorting by variables still requires us to hardcode the column names by using If condition for sorting. I have not tested this video in a long time so not sure if anything has changed.

[@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.

[@RezaDorrani]

Wow, thanks!

[@TracyOsimowicz]

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

[@RezaDorrani]

Great to hear! Thanks for sharing the feedback

[@EpicBizHero]

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

[@RezaDorrani]

Most welcome

[@celinegebara5010]

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

[@RezaDorrani]

Glad I could help! Thanks for watching my videos.

[@thesriramsofpa]

Excellent content Reza! Very clear explanatiion step-by-step. Once minor comment: I understand that Task column is bound to Title field in the gallery. I was scratching my head for a few mins when you say Title, but you were actually referring to Task field. It wasn't obvious in your video I guess. I finally got it after pausing and going through your screen and code.

[@RezaDorrani]

Thanks so much! Apologies for the naming confusion. SharePoint has concept of internal name and display name. Internal name was Title and Display Name was Task

[@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!

[@RezaDorrani]

Thank you for the amazing feedback and welcome to my channel.

[@sreeroy]

Thanks

[@RezaDorrani]

Thank You

[@3086marcosv]

Ok, i would not like the first minute but at the end this tutorial helped me a lot and i should appreciate it, so i do!!!, Thanks Reza! Regards!

[@RezaDorrani]

You are most welcome. As long as the content is providing value, that’s a win for me.

[@RanjitSingh-xk9sb]

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

[@RezaDorrani]

You are most welcome

[@denilsonpa3060]

Muito bom, obrigado pela aula,ja irei seguir voce!!!

[@RezaDorrani]

Thanks

[@omarmorales909]

As usual, great video, thanks for helping us accomplish better apps!!

[@RezaDorrani]

My pleasure!

[@necdetsaritas8722]

Great job Reza. Thanks for sharing

[@RezaDorrani]

Thank you

[@RicardoVidalCastro]

Thank you you saved me a lot of time with this video 😎😎😎😎

[@RezaDorrani]

Glad it helped!

[@designmycity]

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

[@RezaDorrani]

You are most welcome

[@Girl_DressCollection]

Thank You Reza Duranni For This Incredible Solution 😊

[@RezaDorrani]

You are welcome

[@samitbhattacharya2201]

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

[@RezaDorrani]

Glad you like them! Goal is to show something different each time.

[@jithendra-p2m]

excellent presentation. it helps me lot.

[@RezaDorrani]

Glad it was helpful!

[@StephanOnisick]

Really Nice. I always learn something.

[@RezaDorrani]

Glad to hear it!

[@galinagolant]

Thank you!!! This is what I need for my app.

[@RezaDorrani]

Glad to hear that. Thanks for watching

[@moyura2]

@5:21 SortByColumns doesn't seem to work with complex column , Sort function works fine.

[@RezaDorrani]

Your statement is correct.

[@spen2431]

Brilliant. Please keep these videos coming.

[@RezaDorrani]

More to come!

[@FullStackPro]

Very rare content and useful example

[@RezaDorrani]

Thanks for watching

[@victorbenavides895]

Thanks for these videos Reza! Extremely helpful for new power apps users. I did find that the varsortcolumn function inside your switch function was not working. I noticed you said "sort direction" but the syntax shows sort column. Hope this helps anyone else who's sort icons weren't working.

[@RezaDorrani]

Thanks. I made a mistake on that part of the video :)

[@qayyumkadri2138]

Hi @@RezaDorrani Your Videos Really help us a lot !! one thing we can do is change "Sort Direction " in github

[@RezaDorrani]

@@qayyumkadri2138 Thanks! Sort direction in GitHub?

[@qayyumkadri2138]

@@RezaDorrani yes , you can paste corrected code there with single line note on top.

[@RezaDorrani]

@@qayyumkadri2138 There are 5-6 such videos where code need correction. I would do so in my free time which is very limited these days. I have a lot of plans but limited time.

[@cbsweb]

Amazing! I am watching this video for the 1st time on 3rd of April 1 year later 😄

[@RezaDorrani]

Awesome! 😊

[@VikasShankarMishra]

Very helpful thank you Reza for your effort !!

[@RezaDorrani]

My pleasure!

[@Ekaluk999]

Thank you Reza. For about Reset button of after all search /filter/sort , please advise me for your VDO? thanks a lot

[@RezaDorrani]

Welcome! I did not understand your question.

[@Ekaluk999]

@@RezaDorrani sorry I got it after reviewed in this content again and understood about reset button.

[@rahullal2058]

Well explained .Thanks Reza

[@RezaDorrani]

Thanks

[@robster2112]

Great Video - really helped me with clean my app. Having an issue though - when I go to choose which column I want to sort, not all of the columns in my SharePoint list appear, but a number of unnamed columns (just names "field_**" appear. I've refreshed the data and data source, but don't understand why all of my column names aren't appearing to be used in the sort.

[@RezaDorrani]

Thanks. I will have to look at your App in action to know the reason for your issue. I recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com

[@Ikarus4Prime]

thanks a lot, your video helped me to set the correct filter and sort my list :D

[@RezaDorrani]

Glad to hear that! Thanks for watching.

[@GraemesAdventures]

Hi Reza. I'm trying to combine SortByColumns with a Filter not based on a text input. This uses a context variable on button OnSelect: UpdateContext({SortDescending1: !SortDescending1}) - My gallery filter function works like this: Filter('testRaw Materials List', Customer.Value = "Spring Sheep") - My SortByColumns works like this: SortByColumns( 'testRaw Materials List', "Title",If(SortDescending1, Descending, Ascending)) How do I combine these two statements? When I use syntax similar to what you've done in 10:37 I get an error. Using SharePoint List as a datasource

[@RezaDorrani]

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

[@carlw]

Thanks once again for your comprehensive tutorial!! @ quesrtions: 1)What about those filter and reset icons. I figure the filtering would set one of two filter icons (filled, empty) visible and one hidden and the reset would reset filtering. HOWEVER, how do we know when the "filtering" is engaged? 2)Is that fancy header a component and how did you construct it? I cant get the quarter circle icon to rotate. Thanks

[@RezaDorrani]

1 - To check if filtering is engaged, I check to see if the filter controls have values in them. 2 - Fancy header is a string of label controls tied together :) Check kzbin.info/www/bejne/mJ-maahpnMmKqdU

[@carlw]

@@RezaDorrani Thanks Reza. It didn't work that way for me. I had to put a hidden label above the search boxes which pulled the value then the code checked if those labels had values. I had to put a circle on top of the filter icons as I found it was only working if you clicked the edge of the icon/text. The transparent circle on top seems to work. Thanks. LOVE YOUR VIDEOS!!

[@sejalmehta5203]

Hi Reza!! Nice and informative video. Can you tell me how to reset the sort icons back to original? so that no direction is selected?

[@RezaDorrani]

Its been a long while since I did this video. I believe the variable used for defining sorting, you can try setting that to Blank() Please note I am only guessing as I do not remember this video step by step

[@suprithaxgurkar1555]

Thank you very much for this wonderful post. I have a question how to sort status where the status is 'Not started' ?

[@RezaDorrani]

is Not a delegable operator. Sometimes you have to write long formulas to get around it. Lets assume you have 3 status values Not Started, IN Progress and Completed Formula would be Filter(datasource, Status = "IN Progress" || Status ="Completed")

[@reidugenia7162]

Thanks again for sharing this wonderful video Reza!! I do have a similar implementation of sorting from before. Then I encountered delegation issues. I found your pagination video last week and it worked well but was stuck in incorporating my old sort solution. Alas I stumbled on this video and confirmed all the things in my situation.... that complex types won't work, the dynamic variables are not working either, and I have to repeat the same code (filter of 5+columns) for each column I want to sort.... keep up the good work!! :)

[@RezaDorrani]

Sometimes we just have to write long formulas to get around delegation.

[@simonball5602]

More great stuff Reza.

[@RezaDorrani]

Thanks

[@VerticalVictoryGarden]

These are all brilliant insights. Could you make a video using a people picker as part of the filter for the gallery. This seems to be a gap in KZbin university. Thanks.

[@RezaDorrani]

I have shown that in some of my videos. Title may not be that specific. You will need to look through.

[@beenikki101]

Thank you! Does this work on the Data table too?

[@RezaDorrani]

Yes. Same concept will work.

[@cgenadi]

fantastic tutorial :)

[@RezaDorrani]

Thank you! Cheers!

[@scottmatson3313]

Another good one. Thanks.

[@RezaDorrani]

Most welcome

[@scottmatson3313]

@@RezaDorrani will this logic work with Search too? Or do i have to do Filter? I am having a hard time getting it to work with the following. SortByColumns(Search(Job0013_Holiday_Gift_List, TextInput_Search.Text,"EMail","First_Name","Last_Name", "Company"), "Company",SortOrder.Ascending,"Last_Name")

[@RezaDorrani]

@@scottmatson3313 Search is not a delegable function with SharePoint. I cannot guess if formula will work by looking at it. Will have to try it out at my end. I would recommend posting your query on forums powerusers.microsoft.com

[@lospenguin5208]

Great job man ... lots of vids out there on this subject and you're approach is one of the better ones... you should make a video on brainstorming methods when coming up with logic flows for answering probs like this. 🦅

[@RezaDorrani]

Thanks so much.

[@malek17july]

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 ?

[@RezaDorrani]

Thanks for following my channel. Exclusion list is possible but will run into delegation warnings. I did show some workarounds on delegation and filters. Check kzbin.info/www/bejne/r4nZdZ1sZZJmj7M

[@malek17july]

@@RezaDorrani .... Hello Reza.. Thanks for your reply. I found the solution from your suggestion video.

[@investrules2746]

Looks good. However would be great if you could provide more context to the gallery that you are using at the very start. I have no idea how to get started and create the gallery that you are using to sort and filter. Thanks

[@RezaDorrani]

I have videos on gallery designs and styles. Check - kzbin.info/www/bejne/mJ-maahpnMmKqdU

[@shanthan6995]

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.

[@RezaDorrani]

I have done 2 videos on grid views on my channel. If I do another version then I will choose SharePoint.

[@Zsebtetu]

Great content again. Thank you! Is there a way to search with "Contains", not "StartsWith"?

[@Zsebtetu]

I've tried combining the knowledge from your other video: kzbin.info/www/bejne/a5W2nGifhMyHbJo but couldn't make the search function work :(

[@RezaDorrani]

Here is the video that explains "Contains" kzbin.info/www/bejne/sKm9eJSOhtGNp9E

[@Zsebtetu]

@@RezaDorrani Thank you! Helpful as always. :)

[@RohitTheMore]

thank you. Is there any way to accomodate complex column within this dynamic sort?. i.e. sort of priority column from your demo?

[@RezaDorrani]

You would need to table shaping formulas like addcolumns to get the text values from complex columns and then sort on it however those formulas are NOT delegable

[@mashohbd5838]

Hi Reza, Thank you again and again for the great video's you make. I followed the switch formula you provided, i am sorting on ID column and 3 other Date fields, everything works great except 3 date fields, when sorting on date fields , any empty fields are not included and some rows go missing, any idea why? your help is appreciated. Thanks in advance!

[@RezaDorrani]

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

[@canipeddi]

Hi Reza, Thank you very much, Your videos are amazing! I am following your directions for sorting functionality and got an issue, I wonder if you could give some guidence. I have a horizantal container and inside i have a data table(similar to your service desk app with responsive design), In the data table i inserted sort icons on column headers. for some reasons the icons are not getting aligned properly with data table headers, are there any known issues in using table and icons in side a container?

[@RezaDorrani]

I have not come experienced this and hence not sure what is the cause for your issue. I recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com

[@trstrean]

Great video! I used this in a few apps already. Quick question for a different use case I'm working on. Is there any way to integrate this with the Search( function? I'm working on a FAQ app and for that, the startswith function isn't convenient for searching, but it is still beneficial to be able to do some basic filters on the content.

[@RezaDorrani]

kzbin.info/www/bejne/sKm9eJSOhtGNp9E

[@utilisemedia]

Thank you for a great video. Do you have an example of how to reset the filters. I cant quite work this out

[@RezaDorrani]

Resetting filters basically implies resetting the controls. Reset(controlname)

[@utilisemedia]

@@RezaDorrani what’s the format for multiple controls?

[@RezaDorrani]

@@utilisemedia Reset(control1);Reset(control2); etc.

[@ramon_1992_]

function correction, 20:16 If(varSortDirection = Ascending,Ascending,Descending)),

[@RezaDorrani]

Thanks 😊

[@stacyfang3130]

Very informative! A quick question, what code do you have on the reset button?

[@RezaDorrani]

Reset the filter controls one by one.

[@RezaDorrani]

I saw some messages posted by you in comments but for some reason I cannot access it. Looks like you tried reset and it did not work. Im not sure why it would not work in your case. I will recommend posting your issue with screenshots on the forums at powerusers.microsoft.com/

[@stacyfang3130]

@@RezaDorrani For some reasons my messages disappeared after pressing the reply button. But no worries, I already figured it out. The reset button is working now. Thanks a lot!

[@jbo1253]

This is an amazing video, thank you very much. Is it possible to sort record type columns such as Choice, People or lookup?

[@RezaDorrani]

Possible. I do show Choice column sorting in video. However, it will run into delegation issues.

[@jbo1253]

@@RezaDorrani Thank you for the reply. To avoid delegation could the switch technique you used @19:49 in the video be used on record columns? Also, just a heads up I believe lines 14 and 45 in the github syntax should be VarSortDirection and not VarSortColumn. took me awhile to figure out why mine was not working.

[@RezaDorrani]

@@jbo1253 It would not help with delegation. You are correct on that mistake :)

[@death_cloud1046]

Hi Reza, Nice Video. But one thing I notice in the last part that the Descending in Sort Icon didn't work. I also follow your command and also repeating to watch the last minute which you are clicking the sort Icon. It didn't sort to Descending. Do you know what causes it? It was similar to what I'm facing right now.

[@RezaDorrani]

Check most recent comments. Someone posted about it.

[@zerocool200380]

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.

[@RezaDorrani]

Thanks for watching. I have done the grid video 2 times with Power Apps and Dataverse for Teams. If I ever do a 3rd version, I will choose SharePoint.

[@komalmonga5030]

Amazing Video

[@RezaDorrani]

Thanks!

[@SA-kt3wt]

Thank you for the detailed explanation. I'm having trouble with dropdown + OR function. I am trying to filter my gallery by two dropdowns, either dropdown1 or dropdown2, or a combination of both. Both of these dropdowns are linkd to tables stored on excel. These are "month" and "task". My main data is in a table called Main. It has a month and task column. What I want to achieve is by selecting dropdown month, the gallery returns all the items with the month selected or If i click dropdown task, it returns all tasks. If i click both, it filters both the month and the task. Same as your video. I'm using Filter(Main, 'month' = dropdown1.selected.month, OR(task = dropdown2.slected.task)). However, this only then filters both combo boxes e.g., when i click the month dropdown, it will not show any results until I click on the task dropdown. It then applies the filter for both, but wont show just the months with all tasks. There is a blank option in the dropdown which is the first option to prevent accidental filtering.

[@RezaDorrani]

You need to check if your combo boxes are empty - Check kzbin.info/www/bejne/a5W2nGifhMyHbJo Also, your expression is more of an AND than an OR. You need something like this + add logic for empty check Filter(Main, 'month' = dropdown1.selected.month || task = dropdown2.slected.task)

[@souravshaw9344]

Awesome 👍

[@RezaDorrani]

Thanks Sourav

[@Elai20248]

Hi @Reza, how about if I followed your tutorial until the end, but the items in my gallery is not showing anymore after I fixed the delegation warning? Note that I have large dataset on my SP data source. Hoping for your response. Thank you

[@RezaDorrani]

I have not experienced the mentioned issue and hence not sure of the cause or fix for it. I will recommend checking or posting your issue on forums in case someone has experienced something similar community.powerplatform.com/

[@rutica]

Hi Reza! Thank you so much for your video. It was very helpful. If you wanted to add the Sort Up/Down icon to your choice field called Priority (to make the sorting of that field dynamic also), how would you incorporate that into the formula you have in the Items property of your Gallery? Because in the Items property of your Gallery, you use SortByColumns. But if you wanted to sort your choice field called Priority, you would need the Sort formula instead of the SortByColumns formula. (And I'm not worried about Delegation issues because my list only has about 60 items)

[@RezaDorrani]

Set a variable on icon selection - up or down value. And use that to define sort direction. I do not have a specific video on this scenario hence giving an idea. You can also try posting your query on forums in case someone has done something similar powerusers.microsoft.com

[@soumyendupaul9556]

Thank you Reza for your video. But I am unable to show all records in a gallery as you have done in your video. Could you help me in guiding how to do that?

[@RezaDorrani]

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

[@amigomusa]

Hi Reza, brilliant video again. I have question: I wanted to make the filter in 2 columns instead of one like: SortByColumns( Filter( Missions, StartsWith( Title, TxtUID.Text ) || StartsWith( 'Mission Name', TxtUID.Text ) && (Status.Value = DrpMissionStatus.Selected.Value || DrpMissionStatus.Selected.Value = Blank()) ), "ID", Descending ) However, is not filtering in both the text input box and dropdown box simultaneously. What I am doing wrong? thank you...

[@RezaDorrani]

Try SortByColumns( Filter( Missions, (StartsWith( Title, TxtUID.Text ) || StartsWith( 'Mission Name', TxtUID.Text )) && (Status.Value = DrpMissionStatus.Selected.Value || DrpMissionStatus.Selected.Value = Blank()) ), "ID", Descending )

[@amigomusa]

I tried that, however, if nothing is selected from the dropdown, the gallery gets empty.

[@RezaDorrani]

@@amigomusa DrpMissionStatus.Selected.Value = Blank() part should do the trick for empty dropdown selection. Must be something to do with how your dropdown is setup. Tough to help evaluate the issues on this chat. I would recommend you post your issue with screenshots on the forums at powerusers.microsoft.com/

[@amigomusa]

@@RezaDorrani I appreciate that, thank you so much. Posting it there

[@amigomusa]

@@RezaDorrani I figured out the issue was with my dropdown setup. I changed "AllowEmptySelection"=True and turned Default=0. Now it's working perfectly. All thanks to you!

[@Elai20248]

Hi @Reza, is it possible that this won't work on large datasets? I tried to implement this to my app, the sort is working properly for "Modified" but not on my other SP columns. Nothing is showing in the gallery

[@RezaDorrani]

As long as the column is indexed in SharePoint and has a type supported for sorting then it should work

[@Elai20248]

@@RezaDorrani thank you Reza! It immediately worked after I created my columns as index

[@TracyOsimowicz]

10:15 "Entire formula syntax in video description" I don't believe it is in the video description.

[@RezaDorrani]

Sometimes I say things and forget doing it :) Sorry but its not in video description. You would need to pause the video and get the formula.

[@TracyOsimowicz]

@@RezaDorrani Definitely relatable. Got it! Thank you!

[@vinayayinapurapu]

Reza. Nice One as always. Is there a sample template for this app? I want to know how you implemented gallery design.

[@vinayayinapurapu]

Never Mind. Google gave me this kzbin.info/www/bejne/mJ-maahpnMmKqdU. I will change my search engine to rezadorrani.com :)

[@RezaDorrani]

I did a video on gallery designs. This is an extension version of the data table style. Check kzbin.info/www/bejne/mJ-maahpnMmKqdU

[@shuebkamil5556]

few tips for more views. on videos add ur other video links which are connected to this video. Like you could've added link for how to connect sharepoint list and how to make background of powerapps. I found it useful but what if i was a beginner and didn't know this.

[@RezaDorrani]

Thanks for the tip. I will start interlinking videos going forward.

[@vladimirpeshkov4846]

Perfect as usual!

[@RezaDorrani]

Thank you! Cheers!

[@beatrizpatria984]

You saved me!! Thanks a lot!

[@RezaDorrani]

Glad it helped!

[@utilisemedia]

Hi Reza, i could be mistaken but looking over your code example, I cant see in the switch statement an option for Priority (I can only see ID & Title). Reason I ask is that i have 2 drop down columns and cant quite get it to work. I am getting squiggly lines under the 2nd switch at the SortGByColumns( line

[@RezaDorrani]

Here is the full formula github.com/rdorrani/PowerApps/blob/master/sortandfilter.txt

[@utilisemedia]

@@RezaDorrani does this include the priority dropdown column?

[@RezaDorrani]

@@utilisemedia I did this video almost a year ago, so I do not remember

[@utilisemedia]

@@RezaDorrani I can’t see it in there. It’s a different type of control so that’s why I can’t work it out

[@RezaDorrani]

@@utilisemedia I would recommend posting your issue with screenshots on forums at powerusers.microsoft.com/

[@rhydonplay9190]

Nice Reza, thanks!

[@RezaDorrani]

Welcome!

[@lohitdevgan6799]

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.

[@RezaDorrani]

Thank You. I do have a video planned for working with the camera control (take an image) and upload to a particular record.

[@lohitdevgan6799]

@@RezaDorrani Thanks for the reply. I ll appreciate this. Please do it. It ll be very usefull.

[@RezaDorrani]

@@lohitdevgan6799 It's in my backlog

[@franciscoargandonalopez8554]

I have a sharepoint list with repeated values ​​for the name field value and I need to display them in a gallery with the unique values ​​and grouping values ​​according to the match. How do I do it? thanks

[@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.

[@JuanFelipeRestrepoNaranjo]

Hi Reza, another amazing video, Thanks for sharing!!!... Would it be possible to include the Switch for varSortColumn inside the Filter functions just the same way you did with the If for varSortOrder (Ascending/Descending)?

[@RezaDorrani]

You can but it will result in delegation warning and will not work with large data sets.

[@shawkeme]

Hi Raza , thank you for your effort , can you please explain how can i filter a blank value or sort by a blank value

[@RezaDorrani]

I have done many videos on filtering. Check my playlists.

[@pawanmishra6549]

Thanks Reza..👍

[@RezaDorrani]

👍

[@CGRB]

Very nice!

[@RezaDorrani]

Thanks

[@kmuralikrishna1582]

Reza ... Really appreciate.. Is it possible to loop a column values seperated with comma? Ex City Village C1. V1 C1 V2 C1 V3 C2. V1 C2 V2 So we want to display C1 V1, V2, V3 C2 C1, V2 Means column(village )values into single row seperate with comma as row string Please reply

[@RezaDorrani]

I do not have a video reference on this scenario and would have to try it out to provide guidance. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com

[@sinaa7562]

I tried this in section "Add sort button and sort direction Icon" but get an Delegation-warning. Do you think they changed something?

[@sinaa7562]

I am using a sql-connection

[@RezaDorrani]

I have done no work with sql hence not sure. I will recommend posting your issue with screenshots on the forums at powerusers.microsoft.com in case someone has experienced something similar.

[@Anon0326]

how does your filter icon change color when user choose from filter? thank you

[@RezaDorrani]

I think I checked it any of the filter controls have a value and accordingly changed the Icon

[@SihabUddin_sihabuddinmh]

how did you have table format after getting data from sharepoint? I am trying to use excel sheet but I am not getting the tabular layout and second... what did you code for text box and drop down menu?

[@RezaDorrani]

I customized the gallery design. Check kzbin.info/www/bejne/mJ-maahpnMmKqdU

[@truptinalnikar]

Can you please show how sorting can be done in data table ? It will be really helpful ! :)

[@RezaDorrani]

Logic should be similar. I do not have a video on that. Will add it to my backlog but this is the first request on this topic. I will need a lot more requests on this topic to give this a higher priority.

[@kuttieschutties6766]

I have get items action in flow and filtering it dynamically based on the onselect of sort icon in power apps, the issue is if i am sorting a column in asc order empty cell values are considered as the first, i want the empty cell value rows to be atlast. How can we achieve it?

[@RezaDorrani]

Why would you use flow if you can connect to data source directly from power apps? This is a pattern I have no used so not sure. I recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com

[@kuttieschutties6766]

@@RezaDorrani i need to export data into excel from power apps wherein. I have data in data table control and different screens and each has distinct sharepointlist or document library as datasource

[@RezaDorrani]

@@kuttieschutties6766 I have not tried that scenario so not sure

[@searchingyt4246]

Hi Reza, In the last part of the video, where you talk about delegation due to dynamically defining sort column, could you explain scenarios where this delegation warning would actually return wrong output? Or will we practically never face any issues, even though there's a warning (provided that our dynamic column name assignment is valid). I have experienced that not all warnings are actually problematic e.g. countrows with firstn etc. delegation issue. Could you please address this? thanks :)

[@RezaDorrani]

Give me all items from my SharePoint list sorted in asc order. If sort column is dynamically defined will result in delegation and Power Apps will load only the first 2000 records (assuming thats the delegation limit) in memory and then sort them. All other records in data source would be ignored. Delegation warning will never be a problem in case of data sources less than 2k records.

[@kx2793]

@@RezaDorrani Ok, then how do we solve for dynamically defined sort columns with delegation in mind?

[@RezaDorrani]

@@kx2793 That is a limitation.

[@elisatrifiro6099]

how do you change filter icon from empty to filled? Thanks a lot for this video

[@RezaDorrani]

If any of the filters have a value, I change icon style

[@ryannolarte1788]

so how will you return the sort items to the default ascending order for all?

[@RezaDorrani]

I did not understand the question

[@ryannolarte1788]

@@RezaDorrani I mean, all of the sort will return to its original state, not in ascending or descening order

[@RezaDorrani]

@@ryannolarte1788 then you need to add logic to sort on whatever that original state is

[@ryannolarte1788]

@@RezaDorrani thanks!

[@2210duynn]

awesome again !

[@RezaDorrani]

Thanks again!