Hello I am trying to get list of users using power automate flow and save it as xlsx file. See below.
I get all the properties except signInActivity.
I get the result as below:
thank you i was able to solve it but using HTTP. Graph api is not consistant.
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.
Best Regards,
Wearsky