SharePoint - Improve a query on a Lookup field

[D1nos]

I have a "Request" form ("Requests" list), which is meant to list all (child) 'Request Profile' records.

The 'Request Profiles' list has a lookup field ('Request').

I am trying to filter on the lookup field (the filter below works), but it displays a delegation warning at the ".Id =" part.

I thought that the Filter() is delegated in SharePoint.

According to this: SharePoint - Connectors | Microsoft Docs  and this: Understand delegation in a canvas app - Power Apps | Microsoft Docs

Filter('Request Profiles',Request.Id = ThisItem.ID)

How can I re-write the above to avoid problems in the future?
(I am expecting much more than 500 records 😞 )

Thanks!

[v-xiaochen-msft · Accepted solution]

Hi @D1nos ,

The lookup column isn't delegable.

If you have less than 2000 records and more than 500 records, I suggest you modify the delegation setting.

If you have more than 2000 records, I suggest you use the Number column instead of the lookup column.

Best Regards,
Wearsky
If my post helps, then please consider Accept it as the solution to help others. Thanks.

[D1nos]

@v-xiaochen-msft  Thank you for answer. I cannot predict the number of items that will be stored and I cannot risk blocking the application because of this.

When switching from .Id to .Value I do not receive the warning. Is the .Value is delegatable?
It feels strange for me as number comparisons are "lighter and faster".

I also discovered there is a user voice request to make the .Id delegatable too.
Enable delegation on lookup 'Id' column - Power Platform Community (microsoft.com)

Thanks!