cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Doors1980
Helper I
Helper I

Combine Search and Sort by Columns formula

Hi All,

 

I'm sorting a gallery using this working formula:

 

Sort(Search( Search(Issues, "Closed", "Status"), "Columbus","Title" ), Modified, SortOrder.Descending)

 

I'd like to modify this to use SortByColumns so that I can have an ascending/decending icon with the onselect property of:

 

UpdateContext({SortDescending1: !SortDescending1})

 

What Should I change my original formula to?

 

Thanks.

1 ACCEPTED SOLUTION

Accepted Solutions
Doors1980
Helper I
Helper I

Sorted it:

 

SortByColumns(Search( Search(Issues, "Closed", "Status"), "Columbus","Title" ), "Modified", If(SortDescending1, Descending, Ascending))

 

 

View solution in original post

2 REPLIES 2
Doors1980
Helper I
Helper I

Sorted it:

 

SortByColumns(Search( Search(Issues, "Closed", "Status"), "Columbus","Title" ), "Modified", If(SortDescending1, Descending, Ascending))

 

 

Cool.

So in words ... what is Search( Search(Issues, .....  doing ? Saying ?

DatabaseMX ('mx')
Microsoft Access MVP

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Power Apps Ideas

Check out the New Ideas Site

We are excited to announce a new way to share your ideas for Power Apps!

Top Solution Authors
Top Kudoed Authors
Users online (5,435)