cancel
Showing results for 
Search instead for 
Did you mean: 
Workflow Hero

why does my workflow when extracting data from a spreasheet only populate the feilds with the first set of dat from the csv?

Jump to solution

I developed a workflow to extract the field data from a csv file in SharePoint and use it to update a list, based on Vadim Tabakmans example and expanded it from there, just adding some additional fields, the variables and the associated collection operations, that I required.


However, mine populates all the fields in the list with the first fields data from the csv, rather than working as his does.

I’ve attached  the sample csv, the workflow, the template for the list and also screen shot of what it looks like when it’s run
Has anyone encountered this before?

Labels: (1)
0 Kudos
Reply
3 Replies
Workflow Hero

Re: why does my workflow when extracting data from a spreasheet only populate the feilds with the first set of dat from the csv?

Jump to solution

Hi Julian,

I don't think you've inialised your index variables for the elements of the CSV file. e.g. SAP Project Number is the first column (index value 0), Project Name is the second (index value 1), Project Manager is the third (index value 2).

I looked and your index variables are all set with the default value of 0 instead of the column index.

As they are all set to 0 (zero), they will all retrieve the first collection entry which is going to be your first column from the CSV file.

If you go and adjust those index variables to their corresponding column index then you should be good to go.  Just remember it starts counting at 0 instead of 1 so the index is actually the CSV column number minus 1.

Cheers,

Chris

PS also check out your index for Project Name.  I didn't open up all the actions but I think you need to use a different variable for the index here (and possibly elsewhere).

Reply
Workflow Hero

Re: why does my workflow when extracting data from a spreasheet only populate the feilds with the first set of dat from the csv?

Jump to solution

Many thanks Chris, for your help as ever.

I owe you a beer or three...

Reply
Workflow Hero

Re: why does my workflow when extracting data from a spreasheet only populate the feilds with the first set of dat from the csv?

Jump to solution

Any time Julian - especially if beer is involved!

0 Kudos
Reply