AnsweredAssumed Answered

Import excel sheet automatically

Question asked by michuk on Aug 28, 2018
Latest reply on Aug 31, 2018 by michuk

So there is a way to manually import a excel sheet into a SP list, but is there a way of doing this automatically.

 

So - Excel documents are stored in document library, then nintex workflow is run to pull the data in to the relevant columns on a existing list.

 

I have managed to use query excel services to pull one column correctly A2:A5, but as soon as I try and capture the next column A2:B5 all the results (variables) from column 1 and 2 end up in the first column.

 

Any ideas? Vadim Tabakman any ideas?

 

FYI- I want a way where scripts are not used.

 

When trying some WF-I received :The error:

Coercion Failed: Unable to transform the input lookup data into the requested type

 

 

Thanks

Outcomes