Copy List Item From One Site Collection To Another Through Flow

In this blog, I have explained how we can copy an item from one site collection to another through Microsoft Flow.

In this blog, I am going to explain how we can update or add an item from one site collection to another through Flow without using web service as we used to do it in SPD workflow.

First, select Flow, as shown below.

 

Click "Create from blank", as shown below.

Click on "When an item is created", as shown below.

Fill in the site collection address and provide the list name in which we are going to create an item.

Now, the scenario is that we are going to create an item in ‘List1’ of ‘coll1’ which is a site collection. Then, we are going to create an item in ‘List2’ of another site collection with the same properties.

I have created two lists with the same column names and with the same data types on both the site collections. Below is the list of data types of columns that I have created.

Title	Single line of text
Address	Multiple lines of text
Employee code	Number
Is Married	Yes/No
Employee	Person or Group
Date of Joining	Date and Time
Working shift	Choice
Profile link	Hyperlink or Picture
Employee picture	Hyperlink or Picture
Salary	Currency
Skills	Managed Metadata

Skills is a Taxonomy field. Copying Taxonomy values from one Managed Metadata field to other only works if the terms are from the same term set which means we have to create a Term set at the tenant level, as shown below.

We can select a term set for a column, as shown below.

I have initialized a variable to check if an item already exists in ‘List2’ of site collection ‘coll2’. For this, I am going to use ‘Get items’ action to query the list items from List2 of ‘coll2’.

Above, we can see that I have applied a filter query on Employee column of ‘List2’ in site collection ‘coll2’.

I have also mentioned Top Count = 5000 because by default if we do not specify anything then ‘Get Items’ action bring only 100 items.

Also, make sure to manage your indices on columns that you intend to query so that we want to query more than 5000 items we could do that.

Now if ‘Get Items’ action return item count is greater than 0 then “Apply for each action would be executed” as shown below.

If the item already exists, then we can set variable ‘IsItemExists’ to true, so that once the control is out of ‘Apply to each’ action, we can apply a condition to check whether we need to create the item in List2 or not.

Below is the condition.

‘Create item’ is executed if the condition is true.

Below ‘Create Item’ action with all the properties.