cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Luciano_A
Helper I
Helper I

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

Dears,

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

 

Excel input:

Document NameDocument IDProductDocument Owner
abc1Bike, SkateJohn Doe
def2MonowheelJohn Doe

 

Desired Sharepoint Output:

Document NameDocument IDProductDocument Owner
abc1BikeJohn Doe
abc1SkateJohn Doe
def2MonowheelJohn 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!

1 REPLY 1
Luciano_A
Helper I
Helper I

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 

 

Luciano_A_0-1620979332608.png

 

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (3,898)