Answered

Sort Gallery issue

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I have a gallery with the following formula in the Items property

Switch(
 locSortColumn,
 "Title", Sort('MMRS Trailer', Title, If(locSortAscending, Ascending, Descending)),
 "Location", Sort('MMRS Trailer', Location, If(locSortAscending, Ascending, Descending)),
 'MMRS Trailer'
)

I have a Gallery, two buttons and a search bar.

Issue 1: How do I add my search terms in the above code? I've tried using "|", "&", "And"

Can't figure out that syntax

Issue 2: When I click sort by location, it works but my column has text and numbers in it. (Box 1, Box 2, Left Rear, etc)

So it is displayed as: Box 1, Box 10, Box 11, Box 2 and so on.

Anyone have a cool trick to fix this issue?

Thanks

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
@Anonymous

Please consider changing your Formula to the following:

SortByColumns( 'MMRS Trailer', Coalesce("Title", locSortColumn), If(locSortAscending, Ascending, Descending) )

It is not a good practice to use a Switch statement in the Items property as this can lead to issues with the resulting schema of the records.

The above formula performs what you are looking for. If locSortColumn is blank (i.e. has not been chosen yet), then the formula will default to sort on the Title...you can change that as needed.

I hope this is helpful for you.

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

Like
a
(0)

Report
Copy link

Link copied!

I tried your suggestion, had to revert to my prev code. That code made my buttons loose functionality.
Thanks for the assistance, my issue is the same though.

Was this reply helpful? Yes No
RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@Anonymous

Apologies...I had a typo in the formula. It should have been:

SortByColumns( 'MMRS Trailer', Coalesce(locSortColumn, "Title"), If(locSortAscending, Ascending, Descending) )

Had the Coalesce backwards.

Was this reply helpful? Yes No
Verified answer

Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
I figured it out.
I had to add a Number column though. But this is my end result
SortByColumns( Search('MMRS Trailer', TextSearchBox2.Text, "Title", "Location"), Coalesce(locSortColumn, "Title"), If(locSortAscending, Ascending, Descending) )

Was this reply helpful? Yes No