How do i consume ms graph api using power automate - have an issue only with parsing json correctly (inactive users)

[naijacoder]

Hi All,
I'm using the HTTP action(premium)
and i would like to consume this ms graph api

https://graph.microsoft.com/beta/users?filter=signInActivity/lastSignInDateTime le @{addDays(utcNow(), -90)}&$select=displayName,userPrincipalName,signInActivity

and then using the create item action for SharePoint insert the records into a SharePoint list.

The issue i have is when i select the fields below in power automate

displayName
userPincipleName

lastSignInDateTime - reckon this is the issue i have wit apply each as the values is under signInActivity

my apply each inserts the record multiple times

My output looks like this below

{
    "body": {
        "@odata.context": "https://graph.microsoft.com/beta/$metadata#users(displayName,userPrincipalName,signInActivity)",
        "@odata.nextLink": "https://graph.microsoft.com/beta/users?filter=signInActivity%2flastSignInDateTime+le+2022-01-04T08%3a55%3a56.6948537Z&$select=displayName%2cuserPrincipalName%2csignInActivity&$top=2&$skiptoken=1d99361f950b0b7d97f09f1d88ae205315ef4b8853b0206ef1fff12118b2d8a4",
        "value": [
            {
                "id": "ffc5cf8e-e27d-4c05-9e6f-2f38876e8c3c",
                "displayName": "Monge",
                "userPrincipalName": "email",
                "signInActivity": {
                    "lastSignInDateTime": "2021-11-26T06:36:36Z",
                    "lastSignInRequestId": "1f3a870f-be12-4841-97dc-4c807a9ccb00",
                    "lastNonInteractiveSignInDateTime": "2022-01-14T05:34:04Z",
                    "lastNonInteractiveSignInRequestId": "ff4f0c11-262e-4359-9b25-5c6e9ccb4903"
                }
            },
            {
                "id": "ffb0d421-d764-4acf-bb15-56877e5c0b46",
                "displayName": "Emily",
                "userPrincipalName": "email",
                "signInActivity": {
                    "lastSignInDateTime": "2021-05-14T06:22:28Z",
                    "lastSignInRequestId": "244735b4-8136-4b76-b112-e6eea7493600",
                    "lastNonInteractiveSignInDateTime": "2021-11-12T05:21:08Z",
                    "lastNonInteractiveSignInRequestId": "40bd5f40-4a60-49fc-a09e-8bad153b0d00"
                }
            }
        ]
    }
}

 Flow below

How can the values in on set like this (in my apply each)  displayName, userPincipleName and lastSignInDateTime

Thanks in Advance

[VictorIvanidze]

Show your flow please.

[naijacoder]

Thanks Victor I have added the flow.

Cheers

[VictorIvanidze]

And what's the problem? Just populate appropriate fields as you have shown by arrows.

[naijacoder]

The issue Victor is when i insert the lastSignInDateTime as i mentioned in my original post

It adds another apply to each and when i run it it inserts multiple items.

• Hope it makes sense

[naijacoder · Accepted solution]

Thanks I have actually fixed it thanks by using

items('Apply_to_each')?['signInActivity']['lastSignInDateTime']

[salihzett]

Hey @naijacoder ,

I am trying something similar but cannot run your url.

In Graph explorer I receive 

Parts between {} need to be replaced with real values

Could u share your flow here, also what u mean with

Thanks I have actually fixed it thanks by using

items('Apply_to_each')?['signInActivity']['lastSignInDateTime']

I dont know where u add this line, (i am pretty new in this stuff) thanks