web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Convert excel string i...
Power Automate
Unanswered

Convert excel string into a list choice array

(0) ShareShare
ReportReport
Posted on by 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']), '  '' '), ' ')
hetupm_0-1700862134104.png

 

I need help to implement this into a batch input.

hetupm_3-1700862394928.png

 

 Thanks for your help

 
 

 

 

 

 

 

Categories:
I have the same question (0)
  • hetupm Profile Picture
    2 on at
    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"
      }
    ]

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Tomac Profile Picture

Tomac 497 Moderator

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 477 Super User 2025 Season 2

#3
chiaraalina Profile Picture

chiaraalina 242

Last 30 days Overall leaderboard