web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Adding a Sort to a Gal...

Power Apps

Answered

Adding a Sort to a Gallery already filtered multiple times

(0) Share

Report

Report

Posted on by bdransf1

27

Hi there,

I am attempting to sort the following function but can't quite seem to get the syntax right. Its a couple of dropdowns with a couple of StartsWith:

Filter('Invoice Certification',(Status.Value=Dropdown1.Selected.Value||If(Dropdown1.Selected.Value="- Filter by Status -", true , false ))&&('KC POC'.Value=Dropdown4.Selected.Value||If(Dropdown4.Selected.Value="- Filter by KC POC -", true , false ))&&(StartsWith('Invoice Number',SearchInput1.Text)||StartsWith(Title,SearchInput1.Text)))

Thanks so much!

Ben

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Verified answer

BhaskarDhone 1,398 Super User 2026 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
always format the code to read it right.
Try this

SortByColumns( Filter( 'Invoice Certification', (Status.Value = Dropdown1.Selected.Value || Dropdown1.Selected.Value = "- Filter by Status -"), ('KC POC'.Value = Dropdown4.Selected.Value || Dropdown4.Selected.Value = "- Filter by KC POC -"), (StartsWith('Invoice Number', SearchInput1.Text) || StartsWith(Title, SearchInput1.Text)) ), "Invoice Number", SortOrder.Ascending )

Was this reply helpful? Yes No
bdransf1 27 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you so much! That did it. I was missing 1 comma... 🙄

Was this reply helpful? Yes No

Join the conversation