Sort gallery by if checkbox is true and then days passed

(0) Share

Report

Posted on by drossi

134

Hello,

I am trying to sort a gallery by if the checkbox is ticked sort to bottom and then sort the unticked by descending days passed. However when I attempt to do, it looks all over the place and sort doesn't seem to be right.

The formula I have is:

Sort(Sort(Filter(WorkCompletedList, "Invoiced" in JobStatus.Value),PaidYet.Value,Ascending),"DaysPast",Descending)

And the current result is:

Screenshot 2021-05-28 at 10.15.49.png

Categories:

Building Power Apps

All responses (3)

Answers (0)

Sort by

nickellis74 432 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
You can use SortByColumns to do it in a single statement rather than nesting.
SortByColumns(Filter(WorkCompletedList, "Invoiced" in JobStatus.Value),PaidYet.Value,Ascending,DaysPast,Descending)
Also, I you've put DaysPast in " quote marks, which makes that a string rather than a column reference.

If that works, let me know!
drossi 134 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks @nickellis74

It seems it does not like the formula.

'The function SortByColumns has some invalid arguments'
nickellis74 432 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Yes, it's the PaidYet.Value that it doesn't like. Take out the '.Value' part, so it's just PaidYet. That might do it.