Split string into array of objects

(0) Share

Report

Posted on by AA-15040952-0

Hi,

I am trying to convert a string from a SharePoint column (type text) into an array of objects so that I can put it into another SharePoint column (type choice).

The text column holds data like 'APAC, EIMEA' or 'Global'. How can use Power Automate to do this?

Thank you

Categories:

Building flows

Using flows

General topics

I have the same question (0)

All responses (2)

Answers (0)

Sort by

Suggested answer

Fredrik_A 3,644 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Hey,

you can try something like this:

split(triggerOutputs()?['body/COLUMNNAME'], ', ')

And then map it like this to update your choice column:

[{"Value": "value1"}, {"Value": "value2"}]

If my response solved your issue, please mark it as ✅ Accepted Answer and give it a like.

Was this reply helpful? Yes No
Suggested answer

MS.Ragavendar 7,212 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
@AA-15040952-0,

Split the text into an array -> Add a Compose action with this expression:

split(triggerOutputs()?['body/YourTextColumnInternalName'], ',')

Add another Compose action for trim spaces

select(outputs('Compose'), trim(item()))

Add a Select action

From -> Output of Compose

Map: Key: Value, Value: item()

✅If this helped, please Accept as Solution to help others ❤️ A Like is appreciated 🏷️ Tag @MS.Ragavendar for follow-ups.

Was this reply helpful? Yes No