I was building a powerapp for a long standing sharepoint list that is quite large. And I found that it sorted things in all lower case, then proper, then all caps. So like smith it was
Is there some way to get it to sort it together?
Here’s my command
SortByColumns(ColRecruitmentState,”Last_x0020_Name”, Ascending, “First_x0020_Name”, Ascending,”State”, Ascending)
I tried putting Upper() around the last name column but it threw an error. Any ideas?
Go to Solution.
To sort by the upper cased lastname and firstname, you can add columns that contain the upper cased representation of the lastname and firstname columns, and then sort by those.
The syntax would look like this:
Hopefully, this will take you a bit further.
View solution in original post
Thanks! that worked perfectly. I hadn't thought of adding a column to make it work but it took care of it cleanly!
Fill out a quick form to claim your user group badge now!
Find out where you can attend!
Features releasing from October 2019 through March 2020
The largest Power BI, Power Platform, and Data conference in New Zealand