[Flow] Excel import to Sharepoint - Comma separated values in column to generate multiple records

%3CLINGO-SUB%20id%3D%22lingo-sub-2280336%22%20slang%3D%22en-US%22%3E%5BFlow%5D%20Excel%20import%20to%20Sharepoint%20-%20Comma%20separated%20values%20in%20column%20to%20generate%20multiple%20records%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2280336%22%20slang%3D%22en-US%22%3E%3CP%3EDears%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'll%20try%20to%20be%20as%20short%20%26amp%3B%20detailed%20as%20possible%20-%20Trying%20to%20achieve%20the%20subject.%3CBR%20%2F%3E%3CBR%20%2F%3EExample%20Excel%20Source%20file%3A%3C%2FP%3E%3CTABLE%20border%3D%221%22%20width%3D%2271.45882623523448%25%22%3E%3CTBODY%3E%3CTR%3E%3CTD%20width%3D%2221.87864095914609%25%22%3EDocument%20ID%3C%2FTD%3E%3CTD%20width%3D%2222.14119884841687%25%22%3EDocument%20Name%3C%2FTD%3E%3CTD%20width%3D%2222.86125403490148%25%22%3EDocument%3CBR%20%2F%3EApproval%20Date%3C%2FTD%3E%3CTD%20width%3D%2222.53583003988347%25%22%3EProduct%20Name%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2221.87864095914609%25%22%3E1%3C%2FTD%3E%3CTD%20width%3D%2222.14119884841687%25%22%3EX%3C%2FTD%3E%3CTD%20width%3D%2222.86125403490148%25%22%3E01%2F01%2F2021%3C%2FTD%3E%3CTD%20width%3D%2222.53583003988347%25%22%3EProduct%20A%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2221.87864095914609%25%22%3E2%3C%2FTD%3E%3CTD%20width%3D%2222.14119884841687%25%22%3EY%3C%2FTD%3E%3CTD%20width%3D%2222.86125403490148%25%22%3E01%2F01%2F2021%3C%2FTD%3E%3CTD%20width%3D%2222.53583003988347%25%22%3EProduct%20B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E3%3C%2FTD%3E%3CTD%3EZ%3C%2FTD%3E%3CTD%3E01%2F01%2F2021%3C%2FTD%3E%3CTD%3EProduct%20A%2C%20Product%20B%2C%20Product%20C%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3CP%3E%3CBR%20%2F%3EBased%20on%20the%20above%20input%2C%20I%20would%20like%20to%20generate%20this%20type%20of%20List%20on%20Sharepoint%3A%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FP%3E%3CTABLE%20border%3D%221%22%20width%3D%2268.6454707738096%25%22%3E%3CTBODY%3E%3CTR%3E%3CTD%20width%3D%2210.939320479573045%25%22%20height%3D%2257px%22%3ESharepoint%20ID%3C%2FTD%3E%3CTD%20width%3D%2210.939320479573045%25%22%20height%3D%2257px%22%3EDocument%20ID%3C%2FTD%3E%3CTD%20width%3D%2222.14119884841687%25%22%20height%3D%2257px%22%3EDocument%20Name%3C%2FTD%3E%3CTD%20width%3D%2216.61125403490148%25%22%20height%3D%2257px%22%3EDocument%3CBR%20%2F%3EApproval%20Date%3C%2FTD%3E%3CTD%20width%3D%2232.37385427519449%25%22%20height%3D%2257px%22%3EProduct%20Name%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2210.939320479573045%25%22%20height%3D%2230px%22%3E1%3C%2FTD%3E%3CTD%20width%3D%2210.939320479573045%25%22%20height%3D%2230px%22%3E1%3C%2FTD%3E%3CTD%20width%3D%2222.14119884841687%25%22%20height%3D%2230px%22%3EX%3C%2FTD%3E%3CTD%20width%3D%2216.61125403490148%25%22%20height%3D%2230px%22%3E01%2F01%2F2021%3C%2FTD%3E%3CTD%20width%3D%2232.37385427519449%25%22%20height%3D%2230px%22%3EProduct%20A%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2210.939320479573045%25%22%20height%3D%2230px%22%3E2%3C%2FTD%3E%3CTD%20width%3D%2210.939320479573045%25%22%20height%3D%2230px%22%3E2%3C%2FTD%3E%3CTD%20width%3D%2222.14119884841687%25%22%20height%3D%2230px%22%3EY%3C%2FTD%3E%3CTD%20width%3D%2216.61125403490148%25%22%20height%3D%2230px%22%3E01%2F01%2F2021%3C%2FTD%3E%3CTD%20width%3D%2232.37385427519449%25%22%20height%3D%2230px%22%3EProduct%20B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2210.939320479573045%25%22%20height%3D%2284px%22%3E3%3C%2FTD%3E%3CTD%20width%3D%2210.939320479573045%25%22%20height%3D%2284px%22%3E3%3C%2FTD%3E%3CTD%20width%3D%2222.14119884841687%25%22%20height%3D%2284px%22%3EZ%3C%2FTD%3E%3CTD%20width%3D%2216.61125403490148%25%22%20height%3D%2284px%22%3E01%2F01%2F2021%3C%2FTD%3E%3CTD%20width%3D%2232.37385427519449%25%22%20height%3D%2284px%22%3EProduct%20A%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2210.939320479573045%25%22%20height%3D%2230px%22%3E4%3C%2FTD%3E%3CTD%20width%3D%2210.939320479573045%25%22%20height%3D%2230px%22%3E3%3C%2FTD%3E%3CTD%20width%3D%2222.14119884841687%25%22%20height%3D%2284px%22%3EZ%3C%2FTD%3E%3CTD%20width%3D%2216.61125403490148%25%22%20height%3D%2284px%22%3E01%2F01%2F2021%3C%2FTD%3E%3CTD%20width%3D%2232.37385427519449%25%22%20height%3D%2230px%22%3EProduct%20B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2210.939320479573045%25%22%20height%3D%2230px%22%3E5%3C%2FTD%3E%3CTD%20width%3D%2210.939320479573045%25%22%20height%3D%2230px%22%3E3%3C%2FTD%3E%3CTD%20width%3D%2222.14119884841687%25%22%20height%3D%2284px%22%3EZ%3C%2FTD%3E%3CTD%20width%3D%2216.61125403490148%25%22%20height%3D%2284px%22%3E01%2F01%2F2021%3C%2FTD%3E%3CTD%20width%3D%2232.37385427519449%25%22%20height%3D%2230px%22%3EProduct%20C%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3CP%3E%3CBR%20%2F%3E%3CSTRONG%3ENote%3A%20%3C%2FSTRONG%3EThis%20is%20a%20daily%20report%20%26amp%3B%20activity%2C%20I%20will%20need%20to%20be%20able%20to%20update%20in%20Sharepoint%20an%20already%20existing%20document%20information%20if%20anything%20changes.%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSTRONG%3ENote%202%3A%20%3C%2FSTRONG%3EBasically%2C%20and%20in%20words%2C%20what%20I%20need%20help%20here%20with%20is%3A%3CBR%20%2F%3ECreating%20X%20Sharepoint%20entries%20based%20on%20the%20X%20number%20of%20products%20I%20have%20in%20the%20Product%20name%20column%20in%20Excel.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2280336%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMicrosoft%20Flow%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

Dears,

 

I'll try to be as short & detailed as possible - Trying to achieve the subject.

Example Excel Source file:

Document IDDocument NameDocument
Approval Date
Product Name
1X01/01/2021Product A
2Y01/01/2021Product B
3Z01/01/2021Product A, Product B, Product C


Based on the above input, I would like to generate this type of List on Sharepoint:

Sharepoint IDDocument IDDocument NameDocument
Approval Date
Product Name
11X01/01/2021Product A
22Y01/01/2021Product B
33Z01/01/2021Product A
43Z01/01/2021Product B
53Z01/01/2021Product 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.

0 Replies