Share
Report
42Dears,
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:
I have the same question (0)
All responses (
Answers (
