Answered

Invoke HTTP Request for Groups using MS Graph

(0) Share

Report

Posted on by PowerPlatform24

Hi,

I’m experimenting with using Invoke HTTP request (preauthorised) to retrieve office 365 groups using Microsoft Graph endpoint.

Where I’m struggling is the output of this connector returns an object, I want to filter the data for say all groups where the parameter visibility is public as an example.

Unfortunately visibility is not supported as filter currently by adding it to the endpoint directly, therefore my only option seems is to filter after retrieving the data inside of Power Automate.

I’ve then been able to parse the object to make the values selectable, however if I then add the filter connector it will only work with an array not an object.

Do I need to create an array somehow from the object? I’ve seen you can add a compose and then use CreateArray(‘’) but not sure if this is the correct approach.

My end goal is to then either create an excel file containing the information or create a html table and send via email.

Any help would be greatly appreciated.

Thanks,

Categories:

Business Process Flows

All responses (6)

Answers (1)

PowerPlatform24 15 on at

Like (0)

Report

Re: Invoke HTTP Request for Groups using MS Graph

I think it’s something to do with pagination, because if I add to the endpoint $top=999 it returns another 10 public results, but still a further 10 are missing.
PowerPlatform24 15 on at

Like (0)

Report

Re: Invoke HTTP Request for Groups using MS Graph

@ManishSolanki

Thanks again for your help. I have a question on the filter, it’s only returning one group where the visibility is public. However, when I export my groups from the 365 admin centre, I can see that there are several which are public. Why are these not being displayed in the output? Is it something to do with using the pre authorised invoke http request? Also, When I check in browser through the graph explorer, I get the same one group returned and that’s with all the permission consents are allowed. Thanks
ManishSolanki 15,085 Super User 2025 Season 1 on at

Like (1)

Report

Re: Invoke HTTP Request for Groups using MS Graph

Yes, you are right. The output body of http action is a JSON object and inside it we have an array object (value) that can be referenced in the "Filter array" using an expression.

If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.
Verified answer

PowerPlatform24 15 on at

Like (0)

Report

Re: Invoke HTTP Request for Groups using MS Graph

I think what you’re saying from your example is that the array already exists inside of the object. I just need to use the expression on the Filter to select the value array rather than the object as a whole? Thanks
ManishSolanki 15,085 Super User 2025 Season 1 on at

Like (1)

Report
Re: Invoke HTTP Request for Groups using MS Graph

Hi @PowerPlatform24

Here is the sample flow.

In "Filter array" pass the value object from the output body of graph api. We need to use an expression to fetch the value array. Expression needs to be added in the expression box:

body('Invoke_an_HTTP_request')?['value']

Click 'Edit in advanced mode' button on the bottom of this action and enter the below query:

@equals(item()?['visibility'], 'Public')

Output:

If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.
VictorIvanidze 12,534 on at

Like (1)

Report

Re: Invoke HTTP Request for Groups using MS Graph

Please show output of your HTTP request.