cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Frequent Visitor

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

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-ope...

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:

  1. 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.
  2. 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.

Capture.JPG

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support
Community Support

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.

8133.PNG

 

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...

 

 

Best regards,

Community Support Team _ Phoebe Liu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
Community Support
Community Support

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.

8133.PNG

 

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...

 

 

Best regards,

Community Support Team _ Phoebe Liu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

@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? 

Helpful resources

Announcements
New Badges

New Solution Badges!

Check out our new profile badges recognizing authored solutions!

New Power Super Users

Congratulations!

We are excited to announce the Power Apps Super Users!

Power Apps Community Call

Power Apps Community Call: February

Did you miss the call? Check out the Power Apps Community Call here.

Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

Users online (74,290)