You’re offline. This is a read only version of the page.
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.
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.
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.
#1
WarrenBelz
146,743
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
66,079
Most Valuable Professional
Share
Report
All responses (
Answers (