Delegation filter formula

[Lee123]

Hi

I can't figure out why this formula won't delegate to a sharepoint list. 

Sort(

If(MyRecordsOnlyCheck.Value = true,

Filter(Ministerials As Min, currentUser = First(Min.MinisterialAuthor).DisplayName), Ministerials)

,'Due date', Descending)

Any ideas? MinisterialAuthor is a multiple person field. CurrentUser is a global var made from User().FullName

[v-albai-msft]

Hi @Lee123 ,

If your formula is perfect except for the delegation issue, you can keep the results of “First(Min.MinisterialAuthor).DisplayName” using a variable to resolve the delegation issue.

By default, First() function is not delegable in SharePoint, only below functions are delegable in SP:

As a result, you can use Set() function to create another variable:

Set(firstresult, First(Min.MinisterialAuthor).DisplayName)

Then change your formula like below:

Sort(

If(MyRecordsOnlyCheck.Value = true,

Filter(Ministerials As Min, currentUser =firstresult), Ministerials)

,'Due date', Descending)

Note: If the number of your list items is not exceed to 2k, the filtered results will not be affected, you can ignore the delegation warning.

Best Regards,

Allen

[Lee123]

Hi Allen thanks for your post.

I don't think it's quite what I'm looking for though as First(Min.MinisterialAuthor).DisplayName produces the first entry in the multiple select people field in the data source, it's not a static value for the filter as it changes for each record.

Is there another function that is delegatable that might do the job?

[Lee123]

I've tried LookUp which according to the posted graphic is delegatable but it still complains that it can't be delegated

Sort(

If(MyRecordsOnlyCheck.Value = true,

Filter(Ministerials As Min, currentUser = LookUp(Min.MinisterialAuthor, DisplayName = currentUser).DisplayName), Ministerials)

,'Due date', Descending)

Also the formula is notably uglier.