Hello Team,
I'm transferring information from one list to another. I'm coming across an issue of converting from a text field to a choice column.
Here are the details:
Field A from List A = Single line of text
Field B from List B = Choice Column with multi selections
The string value from Field A in List A = "1, 2, 3"
How do i convert this field to an array so i can be read to the choice column (multi selections) in List B?
Thanks ahead
I reposted in forum. I was having a moment last Friday. To much repetition for testing and trying and no results.
Solved: Re: Convert a string to array - Power Platform Community (microsoft.com)
The answer here seemed more what I was looking for.
You wouldn't split on the spaces. You would split on the commas.
I tried following the details and it doesn't work for me. Split doesn't work for me. I guess for my string there are spaces and so on. THere isn't enough detail in the linked article to tell me the proper parts to use. Help.
Take a look at this blog post. It walks through the whole process of how to update a choice field in SharePoint using Flow when starting with a delimited string.
@Pstork1 Hope it makes sense, i can send more screenshots if you like.
im creating an item for a SharePoint list so the field is a choice column. As you can see on the screenshot, the column requires an array input. How do i move a text/string field to this choice column? I found a way to do it for a single selection, but it gets difficult when multiple selections happen. For example: "1, 2, 3"
You are in Flow, so there is no dropdown. Are you asking how to build an array that you can pass back to Power Apps to set a dropdown value or how to build an array that you can use in an Update action to update a choice field in SharePoint? Split() is how you convert the string to an array. Depending on what you are doing with it you may need to make other changes.
@Pstork1 I did that but it doesnt select the items in the choice dropdown. Dont I have to create a step like initialize array variable?
Use Split() based on ',' to convert the comma delimited string to an array.
split(stringvariable, ',')
Michael E. Gernaey
196
Super User 2025 Season 1
David_MA
181
Super User 2025 Season 1
stampcoin
169