cancel
Showing results for 
Search instead for 
Did you mean: 

Support SharePoint Lists with Lookup Fields that point to another site

If you try to create a flow that uses a list that has a Lookup Field which was defined in a parent site, Flow returns an error:

 

flow error.png

 

An error is returned even if the field is not being used as part of the flow. 

 

Status: Under Review
Comments
Level: Powered On

 Error "The lookup list is in another web." issue is a common problem.  We have solved it in our own application.  We came across this problem when building WebParts using the SharePoint Framework and found a way to fix it.  I assume the FLOW team could use the same approahc to quickly fix FLOW.

Power Apps Staff
Status changed to: Under Review
 
Level: Powered On
You have made my weekend turining this issue to "under review". If you need any supporting examples please let me know.
Level: Powered On
Also see this:

'Enable support for lookup columns in other webs in the REST API' -

https://sharepoint.uservoice.com/forums/329220-sharepoint-dev-platform/suggestions/9065329-enable-su...
Level: Powered On

Any update on this?

Level: Powered On

Voted. Getting kinda tired of doing this with REST API

Level: Powered On
👍
Level: Powered On

At a minimum, if lookups are not supported, the Flow should not crash if the lookup column is not even being used.  It looks like it itterating across ALL COLUMNS rather than the ones being referenced by the FLOW.  Its a lazy way to get the info and would be better to actually just grab the columns needed by the flow.  This would be an easier fix than supporting lookup columns to another web.

Level: Power Up

This is critical for us. Anyone have any update on this?

Level: Powered On

Need to be able to create an Approval flow that uses the Approval email indicated in the list item. Approval email comes from a lookup to another SP list.....this is a simple but necessary function . Please get it working.