cancel
Showing results for 
Search instead for 
Did you mean: 
Workflow Hero

Set a WF variable based on data in a list on another site collection?

Jump to solution

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.

Example.

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?

Labels: (1)
Reply
2 Replies
Not applicable

Re: Set a WF variable based on data in a list on another site collection?

Jump to solution

Hi,

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

4-Paste Query

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

Will

Reply
Workflow Hero

Re: Set a WF variable based on data in a list on another site collection?

Jump to solution

Here's a great article about querying a list on another site:

Nintex Workflow – Query a List in Another Site - SharePoint Blog

Reply