A SharePoint workflow that uses a site column to perform a lookup on a list on a different site doesn't execute
Consider the following scenario:
- You create a workflow in Microsoft SharePoint Online or Microsoft SharePoint Server 2013.
- The workflow uses the SharePoint 2013 Workflow platform type.
- The workflow is configured to use a site column that performs a lookup to a list in a site that differs from where the workflow executes.
In this scenario, the workflow doesn't execute, and you receive the following error message:
The field lookup column name is not supported in query. The lookup list is in another web.
In this message, the placeholder <lookup column name> represents the name of the specific column.
This is expected behavior in a workflow that uses the SharePoint 2013 Workflow platform type in either SharePoint Online or SharePoint Server 2013.
The SharePoint 2013 workflows use the REST endpoints to perform their work. The RESTful endpoint that's responsible for making this query isn't able to pull queries across subsites.
SharePoint 2010 workflows execute correctly in this scenario.
Still need help? Go to Microsoft Community.