Skip to main content

Notifications

Power Automate - Using Connectors
Answered

Export list of users to xlsx with specific properties using automatic flow in powerautomate

(0) ShareShare
ReportReport
Posted on by

Hello I am trying to get list of users using power automate flow and save it as xlsx file. See below.

 

2022-09-19 12_57_51-Edit your flow _ Power Automate.png

 

I get all the properties except signInActivity. 

I get the result as below: 

 

{
      "displayName""Acronis Backup",
      "mail""xxxxxxxxxxxxxxxxxxx",
      "userType""Member",
      "accountEnabled"true,
      "createdDateTime""2022-08-30T08:32:16Z"
    },
 
No signingactivity properties. How can I get a record of the last sign in. I am new to the api graph. Any help would be appreciated.

 

  • Verified answer
    lG_2022 Profile Picture
    lG_2022 19 on at
    Re: Export list of users to xlsx with specific properties using automatic flow in powerautomate

    thank you i was able to solve it but using HTTP. Graph api is not consistant.

  • Re: Export list of users to xlsx with specific properties using automatic flow in powerautomate

    Hi @hamid280 ,

     

    Do you have the correct license?

    The following is an example of the request. Details for the signInActivity property require an Azure AD Premium P1/P2 license and the AuditLog.Read.All permission.

    https://learn.microsoft.com/en-us/graph/api/user-list?view=graph-rest-beta&tabs=http#request-2

     

    Besides, the oob http action from group connector does not seem to have enough permission i.e. AuditLog.Read.All permission.

     

    Maybe you need to create a custom connector or use the 'Http' action in flow with aad application.

    Also, this api has an error report. Luckily, it provides a workaround.

    vxiaochenmsft_0-1663647859856.png

    https://learn.microsoft.com/en-us/graph/known-issues#license-check-errors-for-azure-ad-activity-reports

     

    Best Regards,

    Wearsky

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

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,666

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,996

Leaderboard

Featured topics