In this post i am going to explain how to transfer bulk InfoPath forms from current SharePoint library to archive SharePoint library.
Recently I have requirement from inventory control department to copy all InfoPath from current folder to archive folder where machine’s disposal status is “Collected by CDL”, “Broken up for parts” or “Sold to Scrumpymacs”.
InfoPath Inventory Form :
Workflow is simple which I create in SharePoint 2010 designer:
This workflow runs whenever new document is created or existing document updated in Infopath form library.
This workflow is good for new InfoPath forms, or to run on single form. But problem is that i have already more 4000 items in document library and i cannot run this workflow on multiple selected forms.
To run workflow on multiple selected forms please flow steps,
1. You need to create extra field in current document library, i create runworkflow with data type yes/no and set defualt vale to no.
2. Export all form from current document library to excel
3. Change field runworkflow value to yes and copy this value to all rows and save.
As soon we change column value runworkflow to YES, workflow will run automatically one by one for each InfoPath form.
When you transfer InfoPath forms from current document library to archive SharePoint document library, it will only copy items and doesn’t transfer InfoPath column list. This happend becuase destination document library which is name archive document library in our case is not mapped to InfoPath form template.
Publish InfoPath inventorty form template to archive SharePoint document library then run workflow.
If you like this post please click LIKE and visit my sponsors thanks !!!