Unanswered

Get Item action and for each label returned in a String

(0) Share

Report

Posted on by HV-23070504-0

I have a flow that Get Item from a image file in SharePoint.

And I am using For Each and compose. There are 8 labels under "MediaServiceImageTags":
 
How do I get the Label values "Building","Boat","dock","docked","lake","outdoor"   etc.
in 1 string as Output?
 
{

    "@odata.etag": "\"30\"",

    "ItemInternalId": "106",

    "ID": 106,

    "OData__ExtendedDescription": "a boat on the water",

    "Tag": "zeilboot",

    "MediaServiceLocation": "Netherlands    Flevoland    Dronten",

    "MediaServiceImageTags": [

        {

            "@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedTaxonomy",

            "TermGuid": "ffffffff-ffff-ffff-ffff-fffffffffd33",

            "WssId": 60,

            "Label": "boat",

            "Path": null,

            "Value": "boat|ffffffff-ffff-ffff-ffff-fffffffffd33"

        },

        {

            "@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedTaxonomy",

            "TermGuid": "ffffffff-ffff-ffff-ffff-fffffffff8e7",

            "WssId": 61,

            "Label": "dock",

            "Path": null,

            "Value": "dock|ffffffff-ffff-ffff-ffff-fffffffff8e7"

        },

        {

            "@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedTaxonomy",

            "TermGuid": "ffffffff-ffff-ffff-ffff-fffffffff8e5",

            "WssId": 62,

            "Label": "docked",

            "Path": null,

            "Value": "docked|ffffffff-ffff-ffff-ffff-fffffffff8e5"

        },

        {

            "@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedTaxonomy",

            "TermGuid": "ffffffff-ffff-ffff-ffff-fffffffff33f",

            "WssId": 65,

            "Label": "lake",

            "Path": null,

            "Value": "lake|ffffffff-ffff-ffff-ffff-fffffffff33f"

        },

        {

            "@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedTaxonomy",

            "TermGuid": "ffffffff-ffff-ffff-ffff-fffffffff006",

            "WssId": 1,

            "Label": "outdoor",

            "Path": null,

            "Value": "outdoor|ffffffff-ffff-ffff-ffff-fffffffff006"

        },

        {

            "@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedTaxonomy",

            "TermGuid": "ffffffff-ffff-ffff-ffff-ffffffffef03",

            "WssId": 67,

            "Label": "pier",

            "Path": null,

            "Value": "pier|ffffffff-ffff-ffff-ffff-ffffffffef03"

        },

        {

            "@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedTaxonomy",

            "TermGuid": "ffffffff-ffff-ffff-ffff-ffffffffec94",

            "WssId": 68,

            "Label": "sailboat",

            "Path": null,

            "Value": "sailboat|ffffffff-ffff-ffff-ffff-ffffffffec94"

        },

        {

            "@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedTaxonomy",

            "TermGuid": "ffffffff-ffff-ffff-ffff-ffffffffec23",

            "WssId": 69,

            "Label": "sea",

            "Path": null,

            "Value": "sea|ffffffff-ffff-ffff-ffff-ffffffffec23"

        },

        {

            "@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedTaxonomy",

            "TermGuid": "ffffffff-ffff-ffff-ffff-ffffffffebc4",

            "WssId": 70,

            "Label": "ship",

            "Path": null,

            "Value": "ship|ffffffff-ffff-ffff-ffff-ffffffffebc4"

        },

        {

            "@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedTaxonomy",

            "TermGuid": "ffffffff-ffff-ffff-ffff-ffffffffeb3d",

            "WssId": 11,

            "Label": "sky",

            "Path": null,

            "Value": "sky|ffffffff-ffff-ffff-ffff-ffffffffeb3d"

        },

        {

            "@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedTaxonomy",

            "TermGuid": "ffffffff-ffff-ffff-ffff-ffffffffe75d",

            "WssId": 13,

            "Label": "vehicle",

            "Path": null,

            "Value": "vehicle|ffffffff-ffff-ffff-ffff-ffffffffe75d"

        },

        {

            "@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedTaxonomy",

            "TermGuid": "ffffffff-ffff-ffff-ffff-ffffffffe6cc",

            "WssId": 73,

            "Label": "watercraft",

            "Path": null,

            "Value": "watercraft|ffffffff-ffff-ffff-ffff-ffffffffe6cc"

        }

Thanks for any suggestion

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (0)

Sort by

Building with Why 351 Moderator on at

Like (0)

Report
Copy link

Link copied!

Try this in the Compose:

items(For_each)?['Label']

then a compose outside the For each

outputs('Compose')

Alternatively, since you want to concat, you could have string variable. Append to String in the For Each with: items(For_each)?['Label'] . If you want to add a delimiter manually add it to the end of the Append to String statement.

The the Compose outside the For each is just the variable.

Was this reply helpful? Yes No
creativeopinion 10,508 Moderator on at

Like (2)

Report
Copy link

Link copied!

@HV-23070504-0 You don't need a For Each (aka Apply to Each) action in your flow. Use a Select action.

Since your MediaServiceImageTags column is a multi-choice column you need to use a Select action to transform the array. in the From field, insert the dynamic content of your multi-choice column.

Note: Ensure you are inserting the correct dynamic content. It should be the dynamic content that has the same name as your multi-choice column.

Click on the icon to change from map to text mode.

In the map field, insert the value dynamic content from your multi-choice column

Run a test. Review the output. The Select action will output an array of the values selected.

To convert the array to a string, insert the Join action. In the From field, insert the output from the Select action. In the Join with field insert a separator. In my case I used a comma and a space—customize this to suit your requirements.

You might bet interested in this YT Tutorial as well:

5 Power Automate Troubleshooting FAQs and Helpful Tips for Creating Better Flows

In this Power Automate tutorial, I explore 5 frequently asked questions that pop up when troubleshooting a flow. If you’d like to to level up your Power Automate flow skills and learn how to troubleshoot your Power Automate flow—this tutorial is for you!

IN THIS VIDEO:
✓ How to troubleshoot a false Condition action result
✓ How to get dynamic content when it isn’t selectable from the list of dynamic content
✓ How to troubleshoot an Apply to Each action that isn’t looping through
✓ How to troubleshoot a skipped Apply to Each action
✓ How to troubleshoot a Filter Query
✓ How to use a SharePoint yes/no column in a Filter Query
✓ How to use Compose actions to troubleshoot a Power Automate flow
✓ How to troubleshoot multiple emails being sent
✓ How to troubleshoot multiple Teams messages being sent

Hope this helps!

Consider giving me a ❤️ if you liked my response!

👉 Level up your Power Automate skills by checking out my tutorials on YouTube
👉 Tips and Tricks on TikTok and Instagram

Was this reply helpful? Yes No
HV-23070504-0 7 on at

Like (0)

Report
Copy link

Link copied!

Thank you very much, I am almost there :-)

The response is now like below, but I want it like "Building","Boat","dock","docked","lake","outdoor"

{

"body": [

{

"building": ""

},

{

"klok": ""

},

{

"outdoor": ""

},

{

"road": ""

},

{

"sky": ""

},

{

"tower": ""

},

{

"town": ""

},

{

"tree": ""

}

]

}

Was this reply helpful? Yes No