0

I read many articles about how to make SharePoint lookup field delegable inside SharePoint/PowerApps. and seems if we use .Value instead of .Id for the lookup we can have delegable filtering. but one article which confused my is this question Can we force the SharePoint Lookup field to be delegable inside Power Apps where in the accepted answer the user provided this image:

enter image description here

So is this picture correct or wrong? as based on my test the .Value on the column under "In this column" is delegable unlike what the image is showing, am I correct?

2 Answers 2

1

Power Apps delegation supports SharePoint lookup columns with the primary lookup value (column selected under In this column option in lookup settings).

The additional (extended) columns/fields under lookup column settings are not supported in Power Apps delegation.

Image should be read as follows:

  1. Delegation supported on .Value for - primary column selected under In this column option

  2. Delegation not supported on .Value (or .AdditionalColumnName) for - additional (extended) columns/fields under lookup column settings.

2
  • ok thanks for the great explanation and reply .. so inside the image when it says "no delegation on .value" under additional columns then means the additional columns are not delegable? am i correct? May 11, 2023 at 10:03
  • 1
    Yes, correct. No delegation support on .value for additional columns. May 11, 2023 at 10:04
0

There is now a workaround that enables more delegable referencing of various lookup fields: https://powerusers.microsoft.com/t5/Community-App-Samples/Large-SP-List-Delegation-Workaround-App/td-p/2330721

It leverages the SharePoint HTTP action & parallel processing in a flow to pull in all the relevant data, including lookups, and passes all that data to the app so it can form a table with it. Then one can use references to the table data for any previously non-delegable operations

1
  • This set-up & explanation includes several screenshots & more characters than what can be included in a stack overflow post. Do not delete for trivial reasons. Sep 15, 2023 at 17:48

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.