Sort Galery by ID

(0) Share

Report

Posted on by Craig_Cowley

302

Hi all,

I've trying to sort a gallery by the ID number. The 'Item' properties already has a filter and when I add a sort everything disappears.

Item properties

Filter('Origination Work Requests', ProjectSearch.Text in 'Job Name',

IsBlank(TaskSearch.SelectedItems.Value) Or IsEmpty(TaskSearch.SelectedItems.Value) Or

Status in TaskSearch.SelectedItems

)

If I then add the sort either before or after, the gallery contents disappear

Sort('Origination Work Requests','Request ID',decending),

Any help would be appreciated.

Thanks

Craig

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

NandiniBhagya20 4,667 Super User 2024 Season 1 on at

Like (1)

Report
Please try using below formula -
Sort(Filter('Origination Work Requests', ProjectSearch.Text in 'Job Name', IsBlank(TaskSearch.SelectedItems.Value) Or IsEmpty(TaskSearch.SelectedItems.Value) Or Status in TaskSearch.SelectedItems ), 'Request ID', Descending)

Was this reply helpful? Yes No
Craig_Cowley 302 on at

Like (0)

Report

Thanks @NandiniBhagya20 for the response, this has almost worked.

The first item in the list is now 99, it then goes to the 80s, 70s, 60s, 50s, 40s, 30s, then I get my highest numbered entry which is 250.

I've changed the column in my list from a 'Single line of text' to a 'number' and this works perfectly.

Thanks

Craig

Was this reply helpful? Yes No