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

All responses (2)

Answers (1)

jesser 10 on at

Like (0)

Report

Re: Expression to convert Multiple Managed Metadata Column to comma separated string

@Expiscornovus Great solution. Thanks!
Verified answer

Expiscornovus 31,897 Most Valuable Professional on at

Like (1)

Report

Re: Expression to convert Multiple Managed Metadata Column to comma separated string

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: