Split Columns in a List - step by step needed

[triciaryan76]

I have a List that is updated from data from a MS Form.  One of the column contains data separated by a semi colon.

I need to create a flow that updates the form data received, and splits the data in one column into separate columns using semi colon in that List as the delimiter.  The columns are already created, and I just need to move the data(in the Facilitator column) into those three different columns Facilitator Name, Facilitator Employee ID and Facilitator Email.

What would be the step-by-step process for this flow?  

[Shuvam-rpa]

@triciaryan76 According to your query you're getting data like this xyz,123,xyz@gmail.com ??

[triciaryan76]

Yes, I am getting data like that in one column...  I need to split into three columns

[Shuvam-rpa]

@triciaryan76 I have try to solve your issue by creating a test flow, Please check the below screenshot for your reference.

In the test flow i have initialize Two variables one is string variable and other is array variable. In string variable i pass your string with the semi colon same as like you, and in the Array variable i separate it with using split function. and to fetch the exact value from array i use the expression--> 

variables('MyArray')[0] ,

variables('MyArray')[1],

variables('MyArray')[2]  for all three value.

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

[triciaryan76]

@Shuvam-rpa thank you.  So my content comes from a cell in a list (Image attached) .  For the initialize variable step, how would I grab the content from the list?  And how would you recommend setting this up to happen as when the item is added to the list that the cell is split on that trigger?

[triciaryan76]

@Shuvam-rpa  I think I am close to what you are suggesting... but not sure on if I did the When item is created and update SharePoint steps item correctly.  See attached images.  Any additional suggestions?

When new response submitted from MS From, Create new item in LIist

Initialize Variable stepsSplit Variable steps

Update Item with split variable

 

[Shuvam-rpa · Accepted solution]

@triciaryan76 Yes you are correct , have you try to test it out and check if the flow update the list item as you want.

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

[triciaryan76]

Thank you so much!  It worked!! I can't tell you how much time this is going to save in my life...:) 

[Shuvam-rpa]

@triciaryan76 You're most welcome 😊