Unanswered

"Office 365 Users Send an HTTP request (Preview)" Graph Query Issue

(0) Share

Report

Posted on by PowerAppUser875

I'm trying to use the "Office 365 Users Send an HTTP request (Preview)" action, and I'm getting a message that my query is invalid, even though it works in Graph Explorer. Any help would be appreciated!

https://graph.microsoft.com/beta/users?$select=displayName,signInActivity,deletedDateTime,createdDateTime,mail,usertype&$filter=userType eq 'guest'

I have the same question (0)

All responses (11)

Answers (0)

SudeepGhatakNZ 14,381 Most Valuable Professional on at

Like (0)

Report

Re: "Office 365 Users Send an HTTP request (Preview)" Graph Query Issue

@PowerAppUser875 , I suspect it is the authentication part
Watch this, there are couple to connectors you can use.
How to use Microsoft Graph API in Power Automate - Beginner Tutorial - YouTube

Was this reply helpful? Yes No
VictorIvanidze 12,868 on at

Like (0)

Report
Re: "Office 365 Users Send an HTTP request (Preview)" Graph Query Issue

Add / after users and before ?
...users/?$select...

Was this reply helpful? Yes No
PowerAppUser875 19 on at

Like (0)

Report

Re: "Office 365 Users Send an HTTP request (Preview)" Graph Query Issue

I tried that, and it gave me the same error. Maybe this endpoint is unsupported in this action? Thanks for the suggestion!

Was this reply helpful? Yes No
PowerAppUser875 19 on at

Like (0)

Report

Re: "Office 365 Users Send an HTTP request (Preview)" Graph Query Issue

I had another query that did work, so I don't think it's the authentication, but I will watch the video you linked. Thanks!

Was this reply helpful? Yes No
VictorIvanidze 12,868 on at

Like (0)

Report

Re: "Office 365 Users Send an HTTP request (Preview)" Graph Query Issue

I've got the same error as you trying to execute
https://graph.microsoft.com/v1.0/users/
Looks like a bug.

Was this reply helpful? Yes No
Expiscornovus 32,910 Most Valuable Professional on at

Like (0)

Report

Re: "Office 365 Users Send an HTTP request (Preview)" Graph Query Issue

Hi All,

Like the error states, it looks like you need to use 2 segments in this specific action.

https://learn.microsoft.com/en-us/connectors/office365users/#send-an-http-request-(preview)

So, it might be a by design kind of thing and not a bug.

Have you tried the Send an HTTP request from the Office 365 Groups connector instead?

In that specific action escape the ? character with a / like @VictorIvanidze suggested btw 🙂

Was this reply helpful? Yes No
PowerAppUser875 19 on at

Like (0)

Report

Re: "Office 365 Users Send an HTTP request (Preview)" Graph Query Issue

Ahh... thanks! I used the Office 365 Groups Connector, not the v2 preview connector, and was able to connect, but now I am getting a permissions error: Calling principal does not have required MSGraph permissions AuditLog.Read.All

The account I'm running the flow under is a global admin. Any suggestions on how to add the graph api permissions to this user in power automate to run the query?

Was this reply helpful? Yes No
Expiscornovus 32,910 Most Valuable Professional on at

Like (0)

Report

Re: "Office 365 Users Send an HTTP request (Preview)" Graph Query Issue

Hi @PowerAppUser875,

You used the Graph Explorer with the same query to test it, right? Did you logon (right top corner) with that same account in the Graph Explorer?

Normally that application also gives the option to assign/give consent for the correct Graph permissions.

Was this reply helpful? Yes No
PowerAppUser875 19 on at

Like (0)

Report

Re: "Office 365 Users Send an HTTP request (Preview)" Graph Query Issue

Yes, same account, but I did manually consent to the permissions in Graph Explorer. Is there a way to consent to permissions for Power Automate. Thanks!

Was this reply helpful? Yes No
SudeepGhatakNZ 14,381 Most Valuable Professional on at

Like (0)

Report

Re: "Office 365 Users Send an HTTP request (Preview)" Graph Query Issue

@PowerAppUser875 , you need to create an access_token to authenticate the Graph API. You need to generate the clientid, secretid and tenantid. Check this
Build a Power Automate flow using the Graph API (techtarget.com)

Was this reply helpful? Yes No