Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Automate - Using Flows
Unanswered

Report on Multi factor Authention using MS Graph

(0) ShareShare
ReportReport
Posted on by 6

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"
}
}
}

  • Expiscornovus Profile Picture
    31,643 Most Valuable Professional on at
    Re: Report on Multi factor Authention using MS Graph

    Hi @dharin-sukar,

     

    Can you copy paste the expression into the From field via the expression editor instead of pasting it as plain text?

     

    copypasteitinthexpressiontab.png

  • dharin-sukar Profile Picture
    6 on at
    Re: Report on Multi factor Authention using MS Graph

    Very cool thank you,

     

    I am getting an error on the filter array from the http output value, any ideas?

     

    dharinsukar_0-1662771323375.png

     

  • Expiscornovus Profile Picture
    31,643 Most Valuable Professional on at
    Re: Report on Multi factor Authention using MS Graph

    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.

     

    exportcsvtable.PNG

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

🌸 Community Spring Festival 2025 Challenge 🌸

WIN Power Platform Community Conference 2025 tickets!

Markus Franz – Community Spotlight

We are honored to recognize Markus Franz as our April 2025 Community…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,660 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 66,004 Most Valuable Professional

Leaderboard

Featured topics

Restore a deleted flow