Answered

Combine Sort and Filter

(0) Share

Report

Posted on by Xinlin

Hi all,

I've a gallery that intended to filter with two dropdown selection and I would like to sort by created date as well. The filter and sort formula works well separately but it came back with errors when I tried to combine it.

Here's the filter formula:

Filter(
 AccountOpenings, 'Status (crf38_status)' = ddStatus.Selected.Value && 
 Instrument.'Instrument (crf38_instrument)' = ddInstrument.Selected.'Instrument (crf38_instrument)')

Here's the sort formula:

SortByColumns(AccountOpenings,"createdon", If(SortDescending1,Ascending,Descending))

The attempt to combine both formulas but came back with errors:

SortByColumns(Filter(AccountOpenings, 'Status (crf38_status)' = ddStatus.Selected.Value && Instrument.'Instrument (crf38_instrument)' = ddInstrument.Selected.'Instrument (crf38_instrument)'),'Created On', If(SortDescending1,Ascending,Descending))

How can I combine the formulas to make it work? Thank you.

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

Matren 454 Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hi @Xinlin ,

I noticed that you used "createdon" in the Sort formula that worked and 'Created On' in the combined version. Try using the same column name in the Sort formula that worked (i.e. "createdon") for the combined formula.

Let me know how it goes.

Best Wishes,

Matren

--------------------------------------------------------------------------------------------
Find this post helpful, give it a Thumbs Up
Solved your problem, click Accept as Solution so others can find it

Was this reply helpful? Yes No
Xinlin 82 on at

Like (0)

Report
Copy link

Link copied!

That actually works, thanks a lot Matren!

Was this reply helpful? Yes No