cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Resolver II
Resolver II

Split string into multiple rows

Hello All

 

I am looking for a way for users to paste a series of reference numbers seperated by commas which is obtained from another system for example; ref1,ref2,ref3,ref4,ref5.

 

Essentially, my plan was to have a Microsoft Form that has a text field where they can paste that series and submit the form then using Power Automate to split the string and to create 5 seperate items in SharePoint.

 

For example:

 

ID            Title
1             Ref1
2             Ref2
3             Ref3
4             Ref4
5             Ref5


Anyone able to advise if this is even possible? If not, we will find another way around it.

Best regards,

Bradley
If this post helps, then please consider Accept it as the solution to help the other members find it more
1 ACCEPTED SOLUTION

Accepted Solutions
Super User II
Super User II

Hey @burgett94 

Here's quick example of how to split the string and create the items in SharePoint:

The Form

a.png

The Flow

b.png

 

The split expression for the 'Set variable' action is: split(<formQuestion/>,',')

 

The complete example from my flow: split(body('Get_response_details')?['rkjehfie7yir7yf2ecbf32c79daad'],',')

The Output

a.png

 

HTH

Jay

-------------------------------------------------------------------------

If I have answered your question, please mark your post as Solved.

If you like my response, please give it a Thumbs Up

View solution in original post

3 REPLIES 3
Super User III
Super User III

Hi @burgett94 

 

Follow the below steps. 

 

image.png



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog

Power Automate Video Tutorials
Super User II
Super User II

Hey @burgett94 

Here's quick example of how to split the string and create the items in SharePoint:

The Form

a.png

The Flow

b.png

 

The split expression for the 'Set variable' action is: split(<formQuestion/>,',')

 

The complete example from my flow: split(body('Get_response_details')?['rkjehfie7yir7yf2ecbf32c79daad'],',')

The Output

a.png

 

HTH

Jay

-------------------------------------------------------------------------

If I have answered your question, please mark your post as Solved.

If you like my response, please give it a Thumbs Up

View solution in original post

Community Support
Community Support

Hi @burgett94 ,

 

Have your problem been solved?  If yes, please go ahead and mark the post as solved by clicking “Accept as Solution” so that this thread will be marked for other users to easily identify!

 

Best regards,

Alice       

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

New Super Users

Meet the Power Automate Super Users!

Many congratulations to the Season 1 2021 Flownaut Crew!

New Badges

New Solution Badges!

Check out our new profile badges recognizing authored solutions!

MPA Community Blog

Power Automate Community Blog

Check out the community blog page where you can find valuable learning material from community and product team members!

Users online (92,042)