web

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

News and Announcements icon

Power Platform CommunityForums Power Apps Sort By Column + Filter

Power Apps

Answered

Sort By Column + Filter

(0) Share

Report

Report

Posted on by notepadapp

143

Hi,

I have a choice column called "Status" that has three items (Awaiting, Tickets Generated & Archived").

In my Gallery I want it to not show the status "archived" and sort it either ascending or "Awaiting" before "Tickets Generated".

Sort on its own works fine

SortByColumns(AddColumns(Onboarding, "Awaiting", Status.Value), "Awaiting")

However when I try and add the filter I cannot get it to function, I'm trying:

SortByColumns(Filter(Onboarding, Status.Value = "Awaiting" Or Status.Value = "Tickets Generated"), "Status", Ascending)

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Verified answer

LaurensM 12,516 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @notepadapp,

The SortByColumns on a choice field is causing the issue in the second code snippet. Try the following adjustment:

SortByColumns( AddColumns( Filter( Onboarding, Status.Value = "Awaiting" || Status.Value = "Tickets Generated" ), "StatusText", Status.Value ), "StatusText", SortOrder.Ascending )

If this solves your question, would you be so kind as to accept it as a solution.

Thanks!

Was this reply helpful? Yes No
notepadapp 143 on at

Like
a
(0)

Report
Copy link

Link copied!

Amazing thanks 🙂

Was this reply helpful? Yes No

Join the conversation