Unanswered

Sort Work Titles alphabetically

(0) Share

Report

Posted on by EuniceG11

I know this should be so simple, but I just can't get it to work! In my search bar, I'm searching by work title, director, lead and project manager. I want to have it ordered alphabetically by work title but I can't get the sort order working. Grrrrr....please save me before I lose it with Power Apps!

Here's the formula I'm using at the moment:

Filter('PMO Portfolio List',
StartsWith('Work Title',SearchInput_2.Text) ||
StartsWith('Assigned Director'.DisplayName,SearchInput_2.Text) ||
StartsWith('Assigned Lead / BPM Specialist'.DisplayName,SearchInput_2.Text) ||
StartsWith('Assigned Project Manager'.DisplayName,SearchInput_2.Text),
SortOrder.Ascending)

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Sort by

fnanfne 260 on at

Like (0)

Report
Copy link

Link copied!
Hi EuniceG11

You need to wrap that up in a Sort function and add the Sort By column (for example the ID) like this

Sort(Filter('PMO Portfolio List', StartsWith('Work Title',SearchInput_2.Text) || StartsWith('Assigned Director'.DisplayName,SearchInput_2.Text) || StartsWith('Assigned Lead / BPM Specialist'.DisplayName,SearchInput_2.Text) || StartsWith('Assigned Project Manager'.DisplayName,SearchInput_2.Text), ID, SortOrder.Ascending))

Was this reply helpful? Yes No
EuniceG11 50 on at

Like (0)

Report
Copy link

Link copied!

I tried that but got the following error:

Was this reply helpful? Yes No
fnanfne 260 on at

Like (0)

Report
Copy link

Link copied!
Really? It works in my tests.

Try shortening the formula with only one filter to make sure it works, then expand from there.

Sort(Filter('PMO Portfolio List', StartsWith('Work Title',SearchInput_2.Text), ID, SortOrder.Ascending))

Was this reply helpful? Yes No