Skip to main content
Nintex Community Menu Bar

Copy Item to Multiple SharePoint Site based on local variable

  • August 22, 2019
  • 3 replies
  • 40 views

Forum|alt.badge.img+1

Hi all, I have some questions about copying item to multiple SharePoint Site automatically based on local variable. So here is the example

 

I have 100 different sharepoint site

Site A: for submitting nintex form and creating item

Site B: copying item from site A based on workflow variable (this variable stored from build string action)

Site C: copying item from site A based on workflow variable

until...Site CCC

 

I have tried to use switch actions, but I need to distribute/copy items into more than 100 different site. I doubt about reliability of this workflow. So is there any suggestions to use simple method or automatic way?

3 replies

Forum|alt.badge.img+17
  • August 22, 2019

Thanks for posting your question here. I have to wonder, why are you using so many sites for this operation. Generally, sites are done for permissions. But if you're just capturing information from forms, do you need to split them amongst sites. Having a single site with multiple lists may be an easier alternative, but I won't offer any advice until I understand better why you are attempting this in the first place.

 

To give you a brief idea of how to achieve this if you must go this route.

  1. Create a SharePoint list that contains the site name, url and value to match for the workflow variable.
  2. Then when an item is created in the form, you would query the list to find out which site it should get created in.
  3. Grab the url and value and using variables fill in the criteria for the create item action. You could do copy item, but I think the create item action offers a bit more flexibility here.
  4. Complete the creation of the new item in the correct site and then update the current item to show it has been copied. Or delete the item/whatever you need here to remove duplicates. 
    1. Note you may have to use the call web service action to truly move data across sites like this. I am not 100% sure, but its something to consider.

 


Forum|alt.badge.img+1
  • Author
  • October 15, 2019

Thanks @eharris04 for your suggestions. 

We split site into many sites because of document usage for single site was very high. We tried to prevent sharepoint hang or to maximize speed of all sharepoint site process. 

I have some ideas from this blog Copying document library using web service. I will check later if it is work for me. 


Forum|alt.badge.img+17
  • October 15, 2019

@aabinhaq I would also suggest looking at a Content Hub for this. SharePoint on-prem specifically handles this really well out of the box, so if you're running into performance issues, then I'd suggest looking at how your App and WFE servers are setup.