Convert String/text to Array

(0) Share

Report

Posted on by lui

178

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

Categories:

Building flows

I have the same question (0)

All responses (9)

Answers (1)

Pstork1 68,697 Most Valuable Professional on at

Like (4)

Report
Use Split() based on ',' to convert the comma delimited string to an array.

split(stringvariable, ',')

Was this reply helpful? Yes No
lui 178 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Pstork1 68,697 Most Valuable Professional on at

Like (0)

Report

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.

Was this reply helpful? Yes No
lui 178 on at

Like (0)

Report

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"

Was this reply helpful? Yes No
lui 178 on at

Like (0)

Report

@Pstork1 Hope it makes sense, i can send more screenshots if you like.

Was this reply helpful? Yes No
Verified answer

Pstork1 68,697 Most Valuable Professional on at

Like (3)

Report

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.

https://veenstra.me.uk/2019/04/01/microsoft-flow-update-a-multi-select-choice-field-in-a-sharepoint-list/

Was this reply helpful? Yes No
ComputerHabit2 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Pstork1 68,697 Most Valuable Professional on at

Like (0)

Report

You wouldn't split on the spaces. You would split on the commas.

Was this reply helpful? Yes No
ComputerHabit2 on at

Like (0)

Report

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.

Was this reply helpful? Yes No