Combine sort and Filter

(0) Share

Report

Posted on by nithishguptak

100

Hello everyone,

I'm trying to combine filter and sort into one function but I get an error. First filter and sort it alphabetically. Also my data is in Dataverse. I used sort by columns but then I get error saying delegation warning. My data isnt that huge (100 lines so far)

Sort(
 'shftplnr_employees_new',
 Name,
 SortOrder.Ascending
)


Filter(shftplnr_employees_new,Site=CURRENTSITE)

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

Daniel Bocklandt 5,151 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Your function needs to be in one formula:
Sort( Filter(shftplnr_employees_new,Site=CURRENTSITE) , Name, SortOrder.Ascending )

Was this reply helpful? Yes No
nithishguptak 100 on at

Like
a
(0)

Report
Copy link

Link copied!
why is that search not working ? I would like search based on two columns (Name and firstname)

Sort( Search( Filter(shftplnr_employees_new,Site=CURRENTSITE), 'SearchText'.Text, Firstname), Name, SortOrder.Descending)

Was this reply helpful? Yes No
Daniel Bocklandt 5,151 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Sort( Search( Filter(shftplnr_employees_new,Site=CURRENTSITE), 'SearchText'.Text, "Firstname"), Name, SortOrder.Descending)
you need doubleqoutes around the column name

Was this reply helpful? Yes No