Hello,
Trying to the build a FLOW that is using an HTTP GET https://graph.microsoft.com/beta/reports/credentialUserRegistrationDetails
It returns ODATA JSON object. Unable to get this into an array to select each return item for each user to send an email to indicate which is dont have 2FA enable.
Could someone please help build this flow? Please no shortcut answer, too many people are only posting basic stuff
{
"type": "object",
"properties": {
"id": {
"type": "string"
},
"userPrincipalName": {
"type": "string"
},
"userDisplayName": {
"type": "string"
},
"isRegistered": {
"type": "boolean"
},
"isEnabled": {
"type": "boolean"
},
"isCapable": {
"type": "boolean"
},
"isMfaRegistered": {
"type": "boolean"
},
"authMethods": {
"type": "array"
}
}
}
Hi @dharin-sukar,
Can you copy paste the expression into the From field via the expression editor instead of pasting it as plain text?
Very cool thank you,
I am getting an error on the filter array from the http output value, any ideas?
Hi @dharin-sukar,
When you use this in a HTTP action you should be able to return the results as an array from the body/value property.
Below is an example.
In this example I am using a Filter Array which uses the following expression for the From
body('HTTP')['value']
In the criteria it check if the isMfaRegistered field is false by using the follwing expression:
item()?['isMfaRegistered']
is equal to false
After that I use the output in a Create CSV Table action. But you could also loop through that filtered array output if you want.
WarrenBelz
146,660
Most Valuable Professional
RandyHayes
76,287
Super User 2024 Season 1
Pstork1
66,004
Most Valuable Professional