Forum Discussion
laratari
Apr 21, 2021Copper Contributor
[Flow] Excel import to Sharepoint - Comma separated values in column to generate multiple records
Dears,
I'll try to be as short & detailed as possible - Trying to achieve the subject.
Example Excel Source file:
Document ID | Document Name | Document Approval Date | Product Name |
1 | X | 01/01/2021 | Product A |
2 | Y | 01/01/2021 | Product B |
3 | Z | 01/01/2021 | Product A, Product B, Product C |
Based on the above input, I would like to generate this type of List on Sharepoint:
Sharepoint ID | Document ID | Document Name | Document Approval Date | Product Name |
1 | 1 | X | 01/01/2021 | Product A |
2 | 2 | Y | 01/01/2021 | Product B |
3 | 3 | Z | 01/01/2021 | Product A |
4 | 3 | Z | 01/01/2021 | Product B |
5 | 3 | Z | 01/01/2021 | Product C |
Note: This is a daily report & activity, I will need to be able to update in Sharepoint an already existing document information if anything changes.
Note 2: Basically, and in words, what I need help here with is:
Creating X Sharepoint entries based on the X number of products I have in the Product name column in Excel.
No RepliesBe the first to reply