Split string into multiple rows

[burgett94]

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.

[abm]

Hi @burgett94 

Follow the below steps. 

[Jay-Encodian · Accepted solution]

Hey @burgett94 

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

The Form

The Flow

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

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

[v-alzhan-msft]

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.