Hello,
I need to get all data from my table in my database and to set it to my splist .
I used the component "Execute SQL" and i get all my data and stored in variable ( type collection) .
So to set all those data to splist, i need to do the foreach and to set element by element.
dose any one done that before?
do have a clear exemple for us.
Thank you .
Hi,
Here is an example of two collection variables that have paired data and are put back together in a string. Instead of putting them back together in a string you could have a create item action with the two variables going into it to create the item.
This is easily expandable if you have more columns in the database to bring across.
https://community.nintex.com/t5/Nintex-for-SharePoint/Split-string-help/m-p/99534/highlight/true#M69431
If this is just a one off thing to transfer the data I would export to excel and then import the excel sheet into SharePoint.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.