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

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.