Answered

SharePoint Lookup Column Id Subfield - Filter Gallery Items - Delegation Warning

(1) Share

Report

Posted on by ZachS15

I have a gallery control in PowerApps and its Items property is set to the following function:

Filter('My SharePoint List', 'My Lookup Column'.Id = 1)

This is giving me a delegation warning which is confusing based on the documentation found here:
https://docs.microsoft.com/en-us/connectors/sharepointonline/#power-apps-delegable-functions-and-operations-for-sharepoint

From that article it says that a Complex field (e.g. Lookup Column) is delegable based on the subfield involved. So in this case the "Id" field is treated as a "Number" in PowerApps. However the "ID" field only supports the "=" operator. So why am I getting a delegation warning while using the formula above?

Delegation Notes From Article:

SharePoint supports delegation of complex types by deferring the decision for delegation to the subfield (the Id field) involved. Check the type of the subfield being used on the complex type and then check this table for delegation capabilities. Note that only Email and DisplayName are delegable in the Person data type.
The SharePoint ID field for a table is a number field in Power Apps. However, SharePoint only supports the equal ('=') operation for delegation on an ID field.

All responses (2)

Answers (1)

JohnP 543 on at

Like (0)

Report
Re: SharePoint Lookup Column Id Subfield - Filter Gallery Items - Delegation Warning

@v-yutliu-msft
Your proposed solution seems to work, but I get an incompatible type warning?
I need to use the Text() function to remove it like so:

Filter('My SharePoint List', 'My Lookup Column'.Value = Text(1))

Is this happening on your end as well?
Verified answer

v-yutliu-msft on at

Like (0)

Report
Re: SharePoint Lookup Column Id Subfield - Filter Gallery Items - Delegation Warning

Hi @ZachS15 ,

Do you mean that Id for lookup field is not delegate?

I've made a similar test and met the same problem.

Here's an alternative solution:

set ID as the lookup field's related field.

Then you could use lookupfield.Value to represent that ID value.

Filter('My SharePoint List', 'My Lookup Column'.Value = 1)

Here's a similar issue for your reference:

https://powerusers.microsoft.com/t5/Building-Power-Apps/Delegation-warning-on-SharePoint-list-lookup-column-Id-versus/m-p/369410

Best regards,