web

You’re offline. This is a read only version of the page.

Power Platform CommunityForums Power Automate - Building Flows Convert excel string i...

Power Automate - Building Flows

Unanswered

Convert excel string into a list choice array

(0) Share

Report

Report

Posted on by hetupm

2

First big thanks to @takolota

I'm currently implementing his update/create flow and its working pretty well.

https://powerusers.microsoft.com/t5/Power-Automate-Cookbook/Batch-Update-Create-and-Upsert-SharePoint-Lists/m-p/2225500/highlight/true#M1703

I was doing the classic select to create the array and update the list for a multi choice column.

split(replace(trim(item()?['Status']), ' ', ' '), ' ')

I need help to implement this into a batch input.

Thanks for your help

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (0)

hetupm 2 on at

Like (0)

Report

Re: Convert excel string into a list choice array

on my quest for a solution I tried this json(concat('[{"Value":"',replace(replace(trim(item()?['Statut approbation']), ' ', ' '),' ','"},{"Value":"'),'"},]')) but it doesnt work ... the output seem ok in my test :
[
{
"Value": "RECU"
},
{
"Value": "1"
},
{
"Value": "2"
},
{
"Value": "3"
},
{
"Value": "4"
}
]

Was this reply helpful? Yes No

Join the conversation

Helpful resources

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Leaderboard > Power Automate

#1

Michael E. Gernaey 659 Super User 2025 Season 2

#2

Tomac 386 Moderator

#3

chiaraalina 290

Last 30 days Overall leaderboard

Featured topics

Share your ideas and struggles with building Power Automate flows!

Start and wait for an approval action

Product updates

Microsoft Power Platform Community release plans