Answered

Sort Ascending / Decending Not Working

(0) Share

Report

Posted on by Community Power Pla...

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:

Connecting to Data

I have the same question (0)

All responses (5)

Answers (1)

Community Power Pla... on at

Like (0)

Report

Re: Sort Ascending / Decending Not Working

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.

Was this reply helpful? Yes No
CarlosFigueira on at

Like (0)

Report

Re: Sort Ascending / Decending Not Working

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.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Re: Sort Ascending / Decending Not Working

The yellow triangle is not near any specific field.

Was this reply helpful? Yes No
Verified answer

Community Power Pla... on at

Like (1)

Report
Re: Sort Ascending / Decending Not Working

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:

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Re: Sort Ascending / Decending Not Working

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

Was this reply helpful? Yes No