web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Creating a new list ba...
Power Automate
Unanswered

Creating a new list based on another sharepoint list with comma-separated values

(0) ShareShare
ReportReport
Posted on by 2

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:
I have the same question (0)
  • Mister_Shaik Profile Picture
    1,008 on at

    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

     

    Here's the full flow: 

    Parse data from List1 and create data in List2.PNG

     

     

    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.

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
David_MA Profile Picture

David_MA 86 Super User 2026 Season 1

#2
Haque Profile Picture

Haque 55

#3
Ellis Karim Profile Picture

Ellis Karim 53 Super User 2026 Season 1

Last 30 days Overall leaderboard