cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
New Member

Filter and Sort Gallery by two column

Hi guys,

 

I am using sharepoint as my database. I have one column which is a choice column to show priority. Another column is the time that they update records, which use formula Now() . 

So, every row has at lease two columns showing the priority(choice column), and time(text column using Now() formula). 

Question1: how can I sort both two columns, let the gallery show priority column which is "Urgent" on the top, the rest of them are sorted by time column?

Question 2: I found Now() formula would output different format between phone and laptop, if I output it in laptop, the format would be like this 2/20/2020 4:52 PM, but if I output it in phone, the output would be like this February 20, 2020 4:33 PM. It also confuse my sorting when I use sort by A to Z or Z to A, can anybody help me to unify the format? 

 

Thanks.

1 REPLY 1
Super User III
Super User III

@JoeQ
#1

SortByColumns(
    Filter(
        your_datasource_name,
        Status = "Urgent"
    ),
    "SortColumnName1",
    Ascending,
    "SortColumnName2",
    Ascending
)

#2

Text(Now(), "mm/dd/yyyy hh:mm AM/PM")


—-
Please Accept as Solution if this post answered your question so others may find it more quickly. If you found this post helpful consider giving it a Thumbs Up.

Helpful resources

Announcements
secondImage

Experience what’s next for Power Apps

Join us for an in-depth look at the new Power Apps features and capabilities at the free Microsoft Business Applications Launch Event.

Power Apps Community Call

Power Apps Community Call: February

Did you miss the call? Check out the Power Apps Community Call here.

New Power Super Users

Congratulations!

We are excited to announce the Power Apps Super Users!

New Badges

New Solution Badges!

Check out our new profile badges recognizing authored solutions!

Top Kudoed Authors
Users online (69,418)