Select sub / nested property within a loop | From a Multi Choice Sharepoint List | To Print out as HTML Table

[KayTannee]

Hi,

I am pulling the data from a Sharepoint List where I have a multi-choice option set.

The goal is to produce a HTML table that can be emailed, with each value concatenated in a <ul><li> within a single <td>.

JSON source looks like this.

        "Objective": [
            {
                "@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
                "Id": 0,
                "Value": "Try Something"
            },
            {
                "@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
                "Id": 3,
                "Value": "Don't bother"
            },
            {
                "@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
                "Id": 4,
                "Value": "Do Something"
            }
        ],
        "Objective@odata.type": "#Collection(Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference)",
        "Objective#Id": [
            0,
            3,
            4
        ],
        "Objective#Id@odata.type": "#Collection(Int64)",

I've filtered the sharepoint list object that comes from Get Items to each person I want to email the table to. Which converts it to a JSON array.

Based on my understanding of Power Automate, Intellisense equivalent will stop working at this point and even if want a single point of data from the loop need to use an expression. Which is fine for simple data types.

But when using Item()['Objective'] on a data type that contains an object, then it returns...

{"@odata.type":"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference","Id":2,"Value":"Client Outcomes"}

Attempting the below and other stuff that I've forgotten now, all fail, :

Item()['Objective/Value']

concat(Item()['Objective/Value'])

concat(items('Apply_to_each')?['Objective/Value'])

Thanks for any help can give.