
Announcements
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
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'), '(',''),')',''),',')​
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)​
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]
Here's the full flow:
Hope you find this helpful!
Kind Regards,
Shaik Sha
________________________________________________________________________
If I have answered your question, please mark the post as Solved.
If you like my response, please give it a Thumbs Up.