Answered

Expression to convert Multiple Managed Metadata Column to comma separated string

(0) Share

Report

Posted on by jesser

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:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

Expiscornovus 33,194 Most Valuable Professional on at

Like (1)

Report

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 (0)

Report

@Expiscornovus Great solution. Thanks!

Was this reply helpful? Yes No