Unanswered

If i define the following inside a Combo Box's Items property "Sort('Cost Centre List',<>,Ascending)" i will get a delegation warning

(0) Share

Report

Posted on by johnjohn123

3,514

I have a custom combo Box , which have the following formula to sort the items inside its Items property, where 'Cost Centre' field is a calculated column:-

But this formula is returning a Delegation warning.. any advice how i can fix this?

Thanks

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

Sort by

BCLS776 8,994 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Sort() is usually delegable, but it depends a bit on the data source type and column type. What do you have for those? For example, lookup or complex data type columns in a Sharepoint list don't handle a delegable Sort().

Was this reply helpful? Yes No
johnjohn123 3,514 on at

Like
a
(0)

Report
Copy link

Link copied!

@BCLS776The datasource is a SharePoint list and the column is a calculated column.. thanks

Was this reply helpful? Yes No
BCLS776 8,994 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

The calculated column is your issue - do you truly need this operation to be delegable? For options to help, check out this thread:
https://powerusers.microsoft.com/t5/Building-Power-Apps/Delegation-issue-with-calculated-SharePoint-list-column-using/td-p/490105

Was this reply helpful? Yes No
v-xiaochen-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @johnjohn123 ,

If your data volume is less than 2000, you don't have to worry about delegation issues.

In addition, I don't recommend you to use calculate column in the list.

If you want to calculate some values, you can process them in canvas instead of preprocessing in the list.

Best Regards,

Wearsky

Was this reply helpful? Yes No