How are you posting the results? Are you updating a single field on a list item? Are you creating a new item for each entry retrieved? Please be specific.
Can you please share some screenshots?
This is screenshot of how i did. Currently i am updating single field in the list.I am confused about creating a new item for each entry retrieved.
If you're wanting to put the results into a single field, have your tried using a multi-text field? The title field is a single line of text.
I tried with multi text and the result is same. I want each row as a single item. if there are 400 rows i want them in list as 400 items. I am missing something in the workflow.
Ok, in that case you need to use a For Each to loop through the collection and create an item for each one.
What's the purpose of the parallel action, and what are each of your collection operations doing? Can you post a screen shot of the data from Excel you're trying to retrieve?
Also, how are you creating the item? Can you post a screen shot of that setup?
In your screen shot of your workflow you have a For Each action, as well as parallel Collection actions. What are those doing? How are you generating the information that is in the variables "FirstValue, SecondValue, etc."?
Hi,
I have successfully created SharePoint list items from Excel file. Giving below Nintex workflow screen shots which may be of any help.
As per requirement I had to update list items which had 5 columns - Title, Name, Location ... Created Excel service for each column and configured as A1:A438, B1:B438, C1:C438... In For each loop configured 1st column i.e. Title and rest in Run Parallel Action
Hey Sunil, Thanks for the Guidance, I did it in a different way but the workflow is slow and it is taking more than12 hours to update all the records. I tested your workflow and it works fine for my requirement. Thanks for replying.
Thanks Brendan Murphy for the suggestions.