Unanswered

Sort list by alphabetically

(0) Share

Report

Posted on by Dev

Hello,

I have made a sharepoint list and added 70 items in that list now i am creating an app in powerapp by retriving the data from the sharepoint online list. The problem i am figuring out is my user want the app information list to be alphabetically order. But i am getting the information in any order. i have used this formula on my gallery :
SortByColumns(Filter('School Info', StartsWith(Title, TextSearchBox1.Text)), "Title", If(SortDescending1, Descending, Ascending))

CAN ANYONE PLEASE HELP ME ?

Categories:

Building Power Apps

All responses (10)

Answers (0)

Sort by

Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

The forumla looks to be setup correctly, what is not working? Do you get an error? Show us the screenshot of the list. This formula is from the "Generate App from Data" did you do this? Did you remove the sort button? Error might be there because the variable SortDescending1 is never set.
Brian Dang 3,976 on at

Like
a
(1)

Report
Copy link

Link copied!
SortByColumns( Filter('School Info', StartsWith(Title, TextSearchBox1.Text) ), "Title", If(SortDescending1, Descending, Ascending) )
My guess is that your Title column is numerical, which is making it sort by the left-most digit. Can you check what it is validated for?
Dev 35 on at

Like
a
(0)

Report
Copy link

Link copied!

Yes, I have made the sort icon set the property visible to false and its function is : UpdateContext({SortDescending1: !SortDescending1})
Dev 35 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello ,

I have not made the sort visible as it was not in my use any way. My purpose that the user look the schools alphabetically and can search for the school from the seacrh label. But i want that the school name is east oro high school but if the user types oro in search label it should show them the east oro high school. so not only like "STARTSWITH" but I need all the alphabets of "TITLE" to be displayed.
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Not sure I understand what you are looking form. But if you are looking to search "Title" column with any word not only the first word use Search instead of Filter + StartsWith

SortByColumns( Search('School Info', TextSearchBox1.Text,"Title"), "Title", If(SortDescending1, Descending, Ascending) )
Dev 35 on at

Like
a
(0)

Report
Copy link

Link copied!

I cannot use "SEARCH " as i saw online in one of the documentation if i am retrievieng information from the sharepoint list then the search function doesnot support the function in the powerapps. I will not give an error but the blue dot will come and it will work but only partial like it will search the schools but not with what i am looking for the same way as before.
Dev 35 on at

Like
a
(0)

Report
Copy link

Link copied!

I cannot use "SEARCH " as i saw online in one of the documentation if i am retrievieng information from the sharepoint list then the search function doesnot support the function in the powerapps. I will not give an error but the blue dot will come and it will work but only partial like it will search the schools but not with what i am looking for the same way as before.
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Where did you read it?

Here on the Filter, Search and Lookup documentation I cannot find anything what you are claiming. Filter and Search work in similar ways with delegation so it does not matter which one you are using.
Dev 35 on at

Like
a
(0)

Report
Copy link

Link copied!

https://powerapps.microsoft.com/en-us/tutorials/delegation-list/
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

I see.
If you have less than 500 records, then it does not matter. If you have more, then I do not really know how you could search by string. On the bright side, in one of the recent webinars they mentioned that they are looking into increasing the 500 record limit.