Unanswered

Really confused with delegation warnings. I have a filter that uses 'in' inside the fomula

(0) Share

Report

Posted on by KevinGador

826 Moderator

hello everyone,

I've tried to search in the community first before asking however I do not understand most of the solution that was given to the users with the same delegation problems with me. The answers are mostly specific to their question that's why its kind of confusing

I have this formula that is giving me a delegation warning

Sort(
 Filter(
 'DataSource',
 //can be seen by the Requestors
 'Created By'.Email = varUserMail && galFilters.Selected.Filter in 'Overall Approval Status'.Value||
 //can be seen by the Approvers
 'Approver 1' = varUserMail && galFilters.Selected.Filter in 'Overall Approval Status'.Value ||
 'Approver 2' = varUserMail && galFilters.Selected.Filter in 'Overall Approval Status'.Value 
 ),
 ID,
 SortOrder.Descending
 )

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (0)

Pstork1 69,026 Most Valuable Professional on at

Like (2)

Report
Copy link

Link copied!

the "in" operator is never delegable if the data source is SharePoint. If the data Source is Dataverse and the field is text then it is delegable. Based on your formula I expect you are using SharePoint. So in is never delegable.

Was this reply helpful? Yes No
Ami K 15,687 Super User 2024 Season 1 on at

Like (2)

Report
Copy link

Link copied!

@kej assuming your data source is SharePoint, the in function is not delegable.

https://learn.microsoft.com/en-us/connectors/sharepointonline/#power-apps-delegable-functions-and-operations-for-sharepoint

However, if you have a specific field that you can filter on, and you can be certain that filtering on that field will return less than max 2000 rows, it will be possible to use the in function on that smaller filtered subset of data without worrying about the impact of delegation.

Have a think and I will share a possible solution.

Was this reply helpful? Yes No
Ami K 15,687 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@kej - I will leave you with @Pstork1 as I see he responded to you already.

Was this reply helpful? Yes No
KevinGador 826 Moderator on at

Like (0)

Report
Copy link

Link copied!

you are correct im using a sharepoint list. Are there any workarounds that I can use for using contains or in?

Was this reply helpful? Yes No
KevinGador 826 Moderator on at

Like (0)

Report
Copy link

Link copied!

looking forward to a possible workaround. I am also searching for this.

Was this reply helpful? Yes No
WarrenBelz 154,494 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!
HI @kej ,

Firstly, you may have a window depending on how many records are returned here, or more specifically whether the newest records will do the job

With( { _Data: Filter( Sort( 'DataSource', ID, SortOrder.Descending ), 'Created By'.Email = varUserMail || 'Approver 1' = varUserMail || 'Approver 2' = varUserMail ) }, Filter( _Data, galFilters.Selected.Filter in 'Overall Approval Status'.Value ) )

but my other question is regarding the field types of Filter (very bad name for a field with high Ambiguity potential) in the Gallery and 'Overall Approval Status' and why you need to use the in Filter.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No