cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Nintex Newbie

Get Disconnected field values for old items

There is one Yes/No field on my Nintex form which is not conected to any columns in SharePoint List.

unfortunately I forgot to connect and there are about more than 1500 records created . Now my client wants to create report with that field and unfortunately I am not able to find a way to get that values. I am aware NF Formdata store the variable values in item properties. But in my case records are already cerated. So is there a way by which I can fetch those values for list items. any advise is really appreciated.

Labels: (2)
0 Kudos
Reply
5 Replies
Highlighted
Nintex Employee
Nintex Employee

Re: Get Disconnected field values for old items

HI,

Create the Yes/No column in sharepoint.
Create a site workflow that queries the hidden Form Data using a Query XML action for each item in the list and retrieves the value of the unbound Yes/No control and then use an update item action to update the newly created column. Run the workflow once.
On the form connect the Yes/No control to the newly created column.

0 Kudos
Reply
Highlighted
Nintex Newbie

Re: Get Disconnected field values for old items

Can you please share the syntax for Query XML action. Since i am new to Nintex.
0 Kudos
Reply
Highlighted
Nintex Employee
Nintex Employee

Re: Get Disconnected field values for old items

0 Kudos
Reply
Highlighted
Nintex Newbie

Re: Get Disconnected field values for old items

Thanks for sharing the article. I need to know what should i insert in XML property since {ItemProperty:FormData} is not available in site workflow.
0 Kudos
Reply
Highlighted
Nintex Employee
Nintex Employee

Re: Get Disconnected field values for old items

Good Point.
You could have the Site workflow start a list workflow on each item to do the query and update or just scrap the site workflow and just have a list workflow that starts a list workflow on each item.
0 Kudos
Reply