I want to be able to lookup information from a list on another site collection, in order to update a list item in the site running the workflow.
I have a workflow that has a username as a value in a column. I want to use that username to lookup the employee ID which is stored in a different list on a different site collection.
list A: List running the workflow that wants to populate the column "Employee ID"
List B: List that has all employees and their ID. Exists on a different site collection in the same tenant.
Can this be achieved?
Solved! Go to Solution.
Ensure the account has permissions on both site collections.
You can do this via CAML Editor in the Query List -
So you go to the list in the other site collection you want to query.
1-Create a temporary workflow
2-Add Query List
3- Select the list you want to query
4-Add the fields and filters you may need.
5-Change editor mode to CAML
6-Copy the query.
Now in the first site collection.
1-Add Query list
2-Change mode to CAML editor
3-Select alternative site and enter the URL
5-Adjust variable for current workflow
Sometimes you have to click in and out of the workflow for the fields to update in Action form.
I hope this helps
Here's a great article about querying a list on another site: