I used query excel services and able to retrieve the data.How can i post them to the SharePoint list ?
I got all the values stored in a variable and i used create item action to post the data. I tested this scenario and i am getting only the first value of the excel in the list.
Example :- In query Excel Service i mentioned cell to retrieve as A1 : A482 and stored the result in a collection variable.How should i post the values in the SharePoint list?
Solved! Go to Solution.
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.
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?
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."?