Logic APP - For Each from a Filtered Array - retrieve Object ID trough API

Question

I'm trying to create a loop, but I cant seem to get it to work. I filter a sharepoint list and have the below output as a result.

Next I want to loop over the 2 Ad groups and get their Object ID back. For some reason I cannot seem to get the correct reference.

I tried multiple things, this is the last one I tried:

What expressions do I need to retreive the AD group name?

enter image description here

{
    "body": [
        {
            "@odata.etag": "\"4\"",
            "ItemInternalId": "1",
            "ID": 1,
            "Title": "Access Rights",
            "ReportName": {
                "@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
                "Id": 4,
                "Value": "WOL Campaign Report"
            },
            "Environment#Id": 1,
            "Azure_x0020_AD_x0020_Group": "PT_PBI_TST_AR_WOLCAMPAIGN_APPViewer",
            "Modified": "2022-01-14T16:30:47Z",
            "Created": "2022-01-13T23:56:02Z",
            "Author": {
                "@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",
                "Claims": "",
                "DisplayName": "",
                "Email": "",
                "Picture": ""
            },
            "Author#Claims": "",
            "Editor": {
                "@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",
                "Claims": "",
                "DisplayName": "",
                "Email": "",
                "Picture": ""
            }
        },
        {
            "@odata.etag": "\"1\"",
            "ItemInternalId": "4",
            "ID": 4,
            "Title": "66",
            "ReportName": {
                "@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
                "Id": 4,
                "Value": "WOL Campaign Report"
            },
            "Environment#Id": 1,
            "Azure_x0020_AD_x0020_Group": "PT_PBI_TST_RLS_WOLCAMPAIGN_AdminViewer",
            "Modified": "2022-01-14T16:32:00Z",
            "Created": "2022-01-14T16:32:00Z",
            "Author": {
                "@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",
                "Claims": "",
                "DisplayName": "",
                "Email": "",
                "Picture": ""
            },
            "Author#Claims": "",
            "Editor": {
                "@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",
                "Claims": "",
                "DisplayName": "",
                "Email": "",
                "Picture": ""
            }
        }
    ]
}

score 0 · Accepted Answer · answered Jan 19 '22 at 11:14

You shouldn't actually need to write any specific expression, the standard dynamic content should give you what you need.

If you use the Parse JSON action, it will make life a lot easier. I can't tell if you are or not but it looks little different to my example.

However, in the template (based on what I've put together) this is the expression that the dynamic content WYSIWYG editor generates ...

@items('For_Each_Item_on_Body')?['Azure_x0020_AD_x0020_Group']

You can import this JSON template (Code View) into you tenant for testing.

{
    "definition": {
        "$schema": "https://schema.management.azure.com/providers/Microsoft.Logic/schemas/2016-06-01/workflowdefinition.json#",
        "actions": {
            "For_Each_Item_on_Body": {
                "actions": {
                    "Set_variable": {
                        "inputs": {
                            "name": "Azure AD Group",
                            "value": "@items('For_Each_Item_on_Body')?['Azure_x0020_AD_x0020_Group']"
                        },
                        "runAfter": {},
                        "type": "SetVariable"
                    }
                },
                "foreach": "@body('Parse_JSON')?['body']",
                "runAfter": {
                    "Initialize_Azure_AD_Group_Variable": [
                        "Succeeded"
                    ]
                },
                "type": "Foreach"
            },
            "Initialize_Azure_AD_Group_Variable": {
                "inputs": {
                    "variables": [
                        {
                            "name": "Azure AD Group",
                            "type": "string"
                        }
                    ]
                },
                "runAfter": {
                    "Parse_JSON": [
                        "Succeeded"
                    ]
                },
                "type": "InitializeVariable"
            },
            "Parse_JSON": {
                "inputs": {
                    "content": {
                        "body": [
                            {
                                "Author": {
                                    "Claims": "",
                                    "DisplayName": "",
                                    "Email": "",
                                    "Picture": "",
                                    "odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser"
                                },
                                "Author#Claims": "",
                                "Azure_x0020_AD_x0020_Group": "PT_PBI_TST_AR_WOLCAMPAIGN_APPViewer",
                                "Created": "2022-01-13T23:56:02Z",
                                "Editor": {
                                    "Claims": "",
                                    "DisplayName": "",
                                    "Email": "",
                                    "Picture": "",
                                    "odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser"
                                },
                                "Environment#Id": 1,
                                "ID": 1,
                                "ItemInternalId": "1",
                                "Modified": "2022-01-14T16:30:47Z",
                                "ReportName": {
                                    "Id": 4,
                                    "Value": "WOL Campaign Report",
                                    "odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference"
                                },
                                "Title": "Access Rights",
                                "odata.etag": "\"4\""
                            },
                            {
                                "Author": {
                                    "Claims": "",
                                    "DisplayName": "",
                                    "Email": "",
                                    "Picture": "",
                                    "odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser"
                                },
                                "Author#Claims": "",
                                "Azure_x0020_AD_x0020_Group": "PT_PBI_TST_RLS_WOLCAMPAIGN_AdminViewer",
                                "Created": "2022-01-14T16:32:00Z",
                                "Editor": {
                                    "Claims": "",
                                    "DisplayName": "",
                                    "Email": "",
                                    "Picture": "",
                                    "odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser"
                                },
                                "Environment#Id": 1,
                                "ID": 4,
                                "ItemInternalId": "4",
                                "Modified": "2022-01-14T16:32:00Z",
                                "ReportName": {
                                    "Id": 4,
                                    "Value": "WOL Campaign Report",
                                    "odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference"
                                },
                                "Title": "66",
                                "odata.etag": "\"1\""
                            }
                        ]
                    },
                    "schema": {
                        "properties": {
                            "body": {
                                "items": {
                                    "properties": {
                                        "Author": {
                                            "properties": {
                                                "Claims": {
                                                    "type": "string"
                                                },
                                                "DisplayName": {
                                                    "type": "string"
                                                },
                                                "Email": {
                                                    "type": "string"
                                                },
                                                "Picture": {
                                                    "type": "string"
                                                },
                                                "odata.type": {
                                                    "type": "string"
                                                }
                                            },
                                            "type": "object"
                                        },
                                        "Author#Claims": {
                                            "type": "string"
                                        },
                                        "Azure_x0020_AD_x0020_Group": {
                                            "type": "string"
                                        },
                                        "Created": {
                                            "type": "string"
                                        },
                                        "Editor": {
                                            "properties": {
                                                "Claims": {
                                                    "type": "string"
                                                },
                                                "DisplayName": {
                                                    "type": "string"
                                                },
                                                "Email": {
                                                    "type": "string"
                                                },
                                                "Picture": {
                                                    "type": "string"
                                                },
                                                "odata.type": {
                                                    "type": "string"
                                                }
                                            },
                                            "type": "object"
                                        },
                                        "Environment#Id": {
                                            "type": "integer"
                                        },
                                        "ID": {
                                            "type": "integer"
                                        },
                                        "ItemInternalId": {
                                            "type": "string"
                                        },
                                        "Modified": {
                                            "type": "string"
                                        },
                                        "ReportName": {
                                            "properties": {
                                                "Id": {
                                                    "type": "integer"
                                                },
                                                "Value": {
                                                    "type": "string"
                                                },
                                                "odata.type": {
                                                    "type": "string"
                                                }
                                            },
                                            "type": "object"
                                        },
                                        "Title": {
                                            "type": "string"
                                        },
                                        "odata.etag": {
                                            "type": "string"
                                        }
                                    },
                                    "required": [
                                        "odata.etag",
                                        "ItemInternalId",
                                        "ID",
                                        "Title",
                                        "ReportName",
                                        "Environment#Id",
                                        "Azure_x0020_AD_x0020_Group",
                                        "Modified",
                                        "Created",
                                        "Author",
                                        "Author#Claims",
                                        "Editor"
                                    ],
                                    "type": "object"
                                },
                                "type": "array"
                            }
                        },
                        "type": "object"
                    }
                },
                "runAfter": {},
                "type": "ParseJson"
            }
        },
        "contentVersion": "1.0.0.0",
        "outputs": {},
        "parameters": {},
        "triggers": {
            "Recurrence": {
                "evaluatedRecurrence": {
                    "frequency": "Month",
                    "interval": 3
                },
                "recurrence": {
                    "frequency": "Month",
                    "interval": 3
                },
                "type": "Recurrence"
            }
        }
    },
    "parameters": {}
}

This is the result I get within the loop for the two items in the array ...

Result Item 1

Result Item 2

Hi! thanks, I already tried that, but seems I just had to read my error and convert with a variable to a string! ( still I had to write the code, it did not automatically show me the option "AD Group" ) — Robin666, Jan 19 '22 at 11:43
When you use `Parse JSON`, if you pass the JSON in as a template source for the schema, you'll get all of the properties you can pull out dynmically/easily. — Skin, Jan 19 '22 at 11:48
So you'd already solved it without my answer, is that right? — Skin, Jan 19 '22 at 11:53
Well, I had that solution, but your answer showed me how to fix it! :) — Robin666, Jan 20 '22 at 16:48
@Robin666, ok, well ... if it helped and is the correct answer then you should flag it as the answer. — Skin, Jan 21 '22 at 00:48

Logic APP - For Each from a Filtered Array - retrieve Object ID trough API

1 Answers1

Result Item 1

Result Item 2