Answered

Sort Ascending / Decending Not Working

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I am VERY new to PowerApps. It looks like a very useful tool. I am creating my first one with a basic app from a sharepoint list. Everything seems fine but I am not able to sort the gallery by a completed date in descending order. Here is the formula I am using.

Sort('TableName', "Date Completed", SortOrder.Descending)

No matter what I do it will not sort by the Column "Date Completed" in a descending order. The advanced section under the data portion to the right has a yellow triangle at the bottom of it too. I am assuming something is wrong but not sure what it is.

Categories:

Building Power Apps

All responses (5)

Answers (1)

Sort by

Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

It looks like there is also a Blue circle in the upper left of the window. If I hover over the Date Completed section I get the following warning.
CarlosFigueira Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

If you click on the 'More options' button on the right-side pane where you see a yellow triangle, it will expand and show all properties for that control; when you do that, do you see the yellow triangle near a specific property? If that's the case, it will help narrowing down the problem.
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

The yellow triangle is not near any specific field.
Verified answer

Community Power Pla... Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @Anonymous,

You do not need to put SortOrder. in order for sort to work.

Just replace your function with

Sort(PowerApps_Test_List,Date_x0020_Completed,Descending)
Replace PowerApps_Test_List with your SharePoint list.

Also always try to use PowerApps autocomplete for functions as writing them manually can lead to errors.
Notice how the collumn Date Compelted has to have _x0020_ in it to work as it is a symbol for space.

I tesed it out on my SharePoint and it works.

All Items (unsorted):

With the Sort function:
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

That worked perfectly. I knew it had to be something simple. Thanks for all the help.