rthomson
Scholar

Copy Form Fields to List

Jump to solution

I have a form and a list. The list has 250 items, submitted over the past 2 years. For each of these items, there are two fields in the associated form which contain data (single line text), but are not connected to list columns. The customer would now like to see that form data in the list. What would be an efficient and safe way to transfer this form data to list columns, for all 250 items?

0 Kudos
Reply
4 Replies
leighburke
Nintex Employee
Nintex Employee

Re: Copy Form Fields to List

Jump to solution

@rthomson You would need a workflow that will query the NFFormData column xml for each item then update the columns where you would like it stored. There is a blog here(http://workflowexcellence.com/nintex-workflow-parsing-nintex-forms-repeating-section-in-office-365/) about parsing repeating section but would help with parsing variables in form data.

0 Kudos
Reply
rthomson
Scholar

Re: Copy Form Fields to List

Jump to solution

Thanks Leigh. I've done a bunch of NFFormData xml parsing before, so I can cover that piece - what would be the best approach, workflow-wise? Like, to loop through all the items? I've only built workflows which run on a single item when that item is created. Thanks.

0 Kudos
Reply
leighburke
Nintex Employee
Nintex Employee

Re: Copy Form Fields to List

Jump to solution

@rthomson The workflow will have a query list to query all the items and then use a loop against that collection to go through and update each items. You could set it up as a site workflow or just create the workflow and manually trigger from the list.

View solution in original post

0 Kudos
Reply
rthomson
Scholar

Re: Copy Form Fields to List

Jump to solution
Awesome - thanks Leigh!
0 Kudos
Reply