Delegation Warning SharePoint List

[burliad]

Hi All,

I am getting a delegation warning on the code below.  I thought that both Filter and Sort could be delegated to SharePoint?

Sort(Filter(active_treat_log, lg_treat_num=varTNum),SortOrder.Descending)

[burliad · Accepted solution]

Looks like I was able to fix it with this

SortByColumns(Filter(active_treat_log, lg_treat_num = varTNum),"lg_log_dt", Descending)

[WarrenBelz]

@burliad ,

Sort will also work

Sort(
   Filter(
      active_treat_log, 
      lg_treat_num = varTNum
   ),
   lg_log_dt, 
   Descending
)

[v-xiaochen-msft]

Hi @burliad ,

Has your problem been solved?

If so, you could mark the correct reply as a solution to help others in need. 

Best Regards,

Wearsky