web

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

News and Announcements icon

Power Platform CommunityForums Power Automate Expression to convert ...

Power Automate

Answered

Expression to convert Multiple Managed Metadata Column to comma separated string

(0) Share

Report

Report

Posted on by jesser

10

Hello,

i have a SharePoint managed metadata column called "Scope" (Allow multi select). Where the user can select multiple scopes for an document like IT, HR or Operations.

In a flow I want to save them in another column as string e.g. "IT, HR"

First Idea, expression:

join(triggerBody()?['Scope']?['Label'],', ')

But this results in an error: "Array elements can only be selected with an integer index."

Do you have any solution for this?

Best regards,

Jonas

Categories:

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Verified answer

Expiscornovus 33,914 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @jesser,

You can use a select action to collect the label values. After that you can use a join function.

@tom_riha has a nice blogpost about that approach: https://tomriha.com/how-to-convert-array-to-a-string-in-power-automate/

In your case it could be a setup like this:

Was this reply helpful? Yes No
jesser 10 on at

Like
a
(0)

Report
Copy link

Link copied!

@Expiscornovus Great solution. Thanks!

Was this reply helpful? Yes No

Join the conversation