Power Platform Community Forum Thread Details

Hi,

I want to store something in a collection. Below is the code I am using:

colTypeSelected is another collection.

Ce is the SharePoint List

varCamID comes from the gallery which identifies the ID.

ClearCollect(colCe, Filter(Ce, CamID = varCamID, Type.Value in colTypeSelected.Value));

I am getting delegation warning for this. Basically I want to filter out all the records from Ce for that CamID and only where the Type is in colTypeSelected.

Can you please help me overcome this delegation issue and also explain what delegation means and how it works?

Thanks!

Categories:

Building Power Apps

This revision to your code should make the delegation warning go away:

With({aFilter: Filter(Ce, CamID = varCamID)}, // a delegable pre-filter
 ClearCollect(colCe, Filter(aFilter, Type.Value in colTypeSelected.Value)) // the non-delegable part
);

A delegation warning isn't necessarily a bad thing - see this documentation - it's a warning to make sure you are getting the results you want without adversely affecting app performance. In short, all apps have a limit applied to the number of rows they can retrieve from a data source for performance reasons. Delegation is the ability to get the server to do some or all of your querying work before it sends your app those rows, therefore allowing you to potentially query many more rows than the app limit (500-2000 depending on the app settings). If you won't have that many rows in your data source ever, you can simply ignore a delegation warning.

The In operator is not delegable when dealing with Sharepoint lists, which is why the flag gets raised.

Hope that helps,

Bryan