Unanswered

Split Columns in a List - step by step needed

(0) Share

Report

Posted on by 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?

Categories:

General topics

I have the same question (0)

All responses (8)

Answers (1)

Shuvam-rpa 891 Super User 2024 Season 1 on at

Like (0)

Report

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

Was this reply helpful? Yes No
triciaryan76 12 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Shuvam-rpa 891 Super User 2024 Season 1 on at

Like (0)

Report

@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!

Was this reply helpful? Yes No
triciaryan76 12 on at

Like (0)

Report

@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?

Was this reply helpful? Yes No
triciaryan76 12 on at

Like (0)

Report

@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

Was this reply helpful? Yes No
Verified answer

Shuvam-rpa 891 Super User 2024 Season 1 on at

Like (0)

Report

@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!

Was this reply helpful? Yes No
triciaryan76 12 on at

Like (1)

Report

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

Was this reply helpful? Yes No
Shuvam-rpa 891 Super User 2024 Season 1 on at

Like (0)

Report

@triciaryan76 You're most welcome 😊

Was this reply helpful? Yes No