Unanswered

Filter Sort challenge

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi Folks,

I should like to sort the gallery on the the items property that already has a filter function that works.

I only have 700 or so records (bumped up to 2000 in the details), but I'm getting delegation warnings when I add a sort. I'm probably not adding the syntex correctly and would really appreciate some guidance with it.

The filter:

Filter('Course Reviews Quality Table U2', StartsWith('Course Code', TextInput1.Text) Or StartsWith(Department,Trim(TextInput1.Text)))

With Sort:

Sort(Filter('Course Reviews Quality Table U2', StartsWith('Course Code', TextInput1.Text) Or StartsWith(Department,Trim(TextInput1.Text))),"Title")

Not only does the sort not sort, but it is duplicating records that don't exist in the SP list.

Thanks in advance

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

Sort by

Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Update:

A rookie mistake. It's duplicating records because the field names were the same. Once I corrected that, no more dupes.

I still have the sort challenge however, so if anyone has the received wisdom on Sort/Filter syntax, please do support?

Was this reply helpful? Yes No
EddieE 4,643 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!
@Anonymous

It's most likely to do with the Trim function you are using. Maybe try setting a variable in the OnChange of your text input then use that in your Filter?

Eg

// OnChange of text input UpdateContext({ vSearchText: Trim(TextInput1.Text)})

Was this reply helpful? Yes No