Power Platform Community Forum Thread Details

I want to create a sharepoint list based on another sharepoint list.

In the existing sharepoint list (list 1) there is a column where an entry can contain multiple answers in a string. These answers are comma-separated (if there are multiple answers). In the new list (list 2) I would like a new entry to be created for each of these answers. How do I set up Power Automate to do this?

Example

List 1:

Column 1:

Entry 1, (SE, DK, NO)

List 2:

Column 1:

Entry 1: SE

Entry 2: DK

Entry 3: NO

Categories:

General topics

Hi @SimoneFG,

Assuming that the data from the List1 is in the same format as you've provided, you can parse and separate the string as below,

1. We get the data from List 1 = "Entry 1, (SE, DK, NO)"

2. Replace the brackets and then split the string into an array

split(replace(replace(outputs('List1Column1Data'), '(',''),')',''),',')

1. Convert to array.PNG

3. Now use this array, by skipping the first record "Entry 1", in "Apply to each" loop to iterate through each element

skip(outputs('ConverToArray'),1)

2. skip and use array.PNG

4. Inside the loop, you can use the element from array along with a counter variable to create record in List2, then increase the counter [ instead of compose, you can use a SharePoint create new item action]
3. create record in List2.PNG