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 / Splitting MS Form data...
Power Automate
Unanswered

Splitting MS Form data in one field to create separate rows in SharePoint list

(1) ShareShare
ReportReport
Posted on by 18

Hello all - I'm new to Power Automate and have a simple flow that pulls data from an MS Form and direct writes to a SharePoint list.  In one of the form fields (Recommended Employee/Team), users are entering multiple names into the form separated by commas.   This is fine, but I'd like to know if there is a way to have Power Automate separate that data and create a new row in my SharePoint list for each entry in this field....basically duplicating the entry for as many names entered into the field.   This is currently how my flow is defined and works perfectly. 

 

sandivaughn_0-1709042936944.png

 

Categories:
I have the same question (0)
  • v-mengmli-msft Profile Picture
    Microsoft Employee on at

    Hi @sandivaughn ,

     

    Here is a method for your reference:

    vmengmlimsft_0-1709044799228.png

     

     

     

     

    Best regards,

    Rimmon

     

  • sandivaughn Profile Picture
    18 on at

    Thank you so much @v-mengmli-msft .  This worked, however it is only creating two entries in my SharePoint list and this field may contain more than two names.  Is there another solution that would allow more than two?  For example, one entry we had included 9 names in the form field. 

  • v-mengmli-msft Profile Picture
    Microsoft Employee on at

    Hi @sandivaughn ,

     

    Could you please show me the test names and result of entries in SP list?

    Remember to hide private information.

     

    Best regards,

    RImmon

  • sandivaughn Profile Picture
    18 on at

    @v-mengmli-msft 

     

    Here is what occurs in SharePoint.  I listed three names in the form and only two entries are made. 

     

    sandivaughn_0-1709049530038.png

     

  • v-mengmli-msft Profile Picture
    Microsoft Employee on at

    Hi @sandivaughn ,

     

    The biggest possibility at the moment is that the split function splits nine names into arrays of two or three lengths when splitting names. Can you show me the output of compose?

     

    Best regards,

    Rimmon

  • sandivaughn Profile Picture
    18 on at

    @v-mengmli-msft 

    Yes - here it is.  

    sandivaughn_0-1709132857562.png

     

  • v-mengmli-msft Profile Picture
    Microsoft Employee on at

    Hi @sandivaughn ,

     

    Sorry, I mean this.

    vmengmlimsft_0-1709133134870.png

     

     

    Best regards,

    Rimmon

     

  • sandivaughn Profile Picture
    18 on at

    I'm not sure I know how to get to that screen @v-mengmli-msft 

  • v-mengmli-msft Profile Picture
    Microsoft Employee on at

    Hi @sandivaughn ,

     

    Test your flow and click the compose.

    vmengmlimsft_0-1709134049881.png

  • sandivaughn Profile Picture
    18 on at

    Sorry about that - here you go. @v-mengmli-msft 

    sandivaughn_1-1709134275690.png

     

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!

Congratulations to the March Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Haque Profile Picture

Haque 594

#2
Valantis Profile Picture

Valantis 328

#3
David_MA Profile Picture

David_MA 281 Super User 2026 Season 1

Last 30 days Overall leaderboard