Expression to convert Multiple Managed Metadata Column to comma separated string

[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

[Expiscornovus · Accepted solution]

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:

[jesser]

@Expiscornovus Great solution. Thanks!