[Need advice] Need to transform single entries with multiple csv values in a column to unique multiple entries in Sharepoint

(0) Share

Report

Posted on by Luciano_A

Dears,

this community already helped me building the first part of my small project, I am now facing another challenge:

Excel input:

Document Name	Document ID	Product	Document Owner
abc	1	Bike, Skate	John Doe
def	2	Monowheel	John Doe

Desired Sharepoint Output:

Document Name	Document ID	Product	Document Owner
abc	1	Bike	John Doe
abc	1	Skate	John Doe
def	2	Monowheel	John Doe

So far, I can already:

1) Take either a table OR non-table formatted Excel as Input

2) If NON table formatted, create a Table via Excel Script

3) If Document number doesn't exist in Sharepoint already, create New, otherwise upload existing item

I " just " miss the part & logic of those cases in which my "Product" is not a single product but has multiple, comma-separated, products -> I need single sharepoint entries to work with.

Any help is, as always, very much appreciated!

Categories:

Process Advisor

All responses (1)

Answers (0)

Luciano_A 42 on at

Like (0)

Report

Re: [Need advice] Need to transform single entries with multiple csv values in a column to unique multiple entries in Sharepoint

Well - Just after posting the above, a lamp lighten up above my head and made little progress

UPDATE//: Just found this doesn't really solve my challenge 100%

What I did:

1) Get items with substringof OData query on Products column searching for "," to actually get only those multi-products entries
2) Apply to each on previous values and split Product value
3) Create the item again for all values of the above

- Need to check with real data how things are going, I am almost sure I have an issue on combining manual updates & this automatic flow