You’re offline. This is a read only version of the page.
Announcements
42
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!
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
Share
Report
All responses (
Answers (
