Answered

SortbyColumns and Search problem

(0) Share

Report

Posted on by rome_knight

I have sortbycolumns and search function for a table as Item with code below, however the sort order idoes not correct (not follow by ID) and info in the table is lacking also after put code, (Entity is Choice column, ID is default column in SPlist). Please help me to fix the code

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

CU22040918-0 195 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @rome_knight ,

The code snippet syntax looks good. Could you please share some screenshots to illustrate the error?

Nelson

Was this reply helpful? Yes No
rome_knight 20 on at

Like
a
(0)

Report
Copy link

Link copied!

It should be arrange following latest event, however after the code, the order is wrong

Was this reply helpful? Yes No
Verified answer

Drrickryp Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@rome_knight

Try

With({_items: Sort('Bypass TH Status',ID, Sort Order. Descending)},

Search(

AddColumns(_items, "EntityValue", Entity.Value),

TextSearch.Text,

"EntityValue"

)

)

And see if you get a different result.

Was this reply helpful? Yes No
CU22040918-0 195 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @rome_knight ,

That's weird!

I would take delegation issue into consideration!

How many items does 'Bypass TH Status' have? Is it a sharepoint list?

Kindly noted that Search() and AddColumns() are not delegable, so only first 500 items will be returned from data source by default.
Try to increase delegation data limit to 2000(max) if your table row count is less than 2000.

Also you can try to use Filter function as below which is delegable, but the search text must be exactly same. For that case, a dropdown or combobox would be better.

SortByColumns( Filter( 'Bypass TH Status', Entity.Value=textSearch.Text ), "ID",SortOrder.Descending)

Nelson

Was this reply helpful? Yes No