Answered

Sorting

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hello,

I have a SharePoint list named "LS Checklist-2" that has the following columns: Date, Associate, Area, Shift, Mobile#, Inspection, Results, and Comments. In my Power App on Browse Screen 1, that screen contains the following data: Shift, Mobile#, Date , Assoc. #. I am trying to sort this data by DATE, but the sort icon is not working and this is the syntax I am using:

UpdateContext({SortDescending1: !SortDescending1}).

Can anyone figure this out? Thanks in advance!

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Sort by

Michael E. Gernaey 53,963 Moderator on at

Like (0)

Report
Copy link

Link copied!

hi @Anonymous

We really need to see your sort could, not that Context variable.

Have you attempted to not use the Context variable and assuming they have the ability to click something (to reverse the sort) (like a chevron) and then just check if the chevron is down or up and sort based on that?

Either way, please show your sort code

If I have helped you, I would really appreciate if you please Mark my answer as Resolved/Answered, and give it a thumbs up, so it can help others

Cheers

Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey

Was this reply helpful? Yes No
Verified answer

v-qiaqi@microsoft.com Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
HI @Anonymous,

Well, you should make sure that the Items property of the Gallery is set to like below:

SortByColumns(Filter(list_name, StartsWith(Title, TextSearchBox1.Text)), "Date", If(SortDescending1, SortOrder.Descending, SortOrder.Ascending))

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

Like (0)

Report
Copy link

Link copied!

Here is my Sort Code:
UpdateContext({SortDescending1: !SortDescending1})

You are correct, all I need is to sort up or down, there is another checkbox to return to a main screen.

Thank-you!

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

Like (0)

Report
Copy link

Link copied!

Here is how the form is setup, I would like to sort from the third line (Date):
-First Box (Letter): Subtitle1-1
-Second Box (Alpha-Numeric): Scooter#
-Third Box (Date): Subtitle1
-Fourth Box (Number): Body1

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

Like (0)

Report
Copy link

Link copied!

Here is how the form is setup, I would like to sort from the third line (Date):
-First Box (Letter): Subtitle1-1
-Second Box (Alpha-Numeric): Scooter#
-Third Box (Date): Subtitle1
-Fourth Box (Number): Body1

Was this reply helpful? Yes No