Showing results for 
Search instead for 
Did you mean: 
Advocate II
Advocate II

SortByColumns and using variable sort columns and delegation

Hi, im using SortByColumn in a Gallery, and i am going to create buttons with different for different sort order, eg button for Title, Created, Location, Created by, Priority  Requester.  My variable is varSortColumn.


I use the set(varSortColumn,"Title")  to set the column name to sort by.

In the Item in the Gallery i use:




When i use a variable, and not the "hord code" name of the column i get an delegation warning. Is there a way to use variable without getting the delegation issue ?    When i use the column name, there is not any delegation problem, only when i use a variable. 








I tried With statement and it DOES clear the delegation warning but it doesn't retrieve all the records.

I tested by changing the limit to 5. It only retrieve 5 records.



This is what I'm trying


With ( {wFilterRecords: Filter(SP, 
       (ID=Value(IDFilterInput_2.Text) || IsBlank(IDFilterInput_2.Text)) &&
(FullName = NameFilterInput_2.Selected.DisplayName || IsBlank(NameFilterInput_2.Selected)))
        Sort(wFilterRecords, "Column1", If(sortDirection,Descending,Ascending)),  
        Sort(wFilterRecords, "Column2", If(sortDirection,Descending,Ascending)) 



Im getting the exact same thing, managed to get the with method to work but it does not get round the delegation issue


@JoshHudsy and @indhaa ,

Absolutely correct - you might read this blog of mine - the second dot point advises of this.

Helpful resources

Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (3,113)