Hello
I am very new to O365 tools, but I am looking to automate an approvals process and retrieve personal O365 email addresses from a distribution group.
I tried two solutions, none of which worked for me due to lack of knowledge.
Test 1: I wanted to use the O365 Groups activities connector so I didn't need to authenticate.
I have the distribution email address, and want to use the 'List Group members' activity
In order to use it I need to get the ID dynamically for the specific distribution email address.
I tried using the O365 Send Http Request which uses the graph groups, I tested the request in the Graph explorer, all worked well.
However when I use it in the power automate flow I get the error message below.
the URI is
https://graph.microsoft.com/v1.0/groups?$filter=mail eq 'my_email@xx.com'
the error is URI path is not a valid Graph endpoint, path is neither absolute nor relative or resource is not one of the supported (me, users, groups, sites, search, planner, teams, chats): https://graph.microsoft.com/v1.0/groups?$filter=mail eq 'my_email@xx.com'
Here I have also tried replacing spaces with %20 URI https://graph.microsoft.com/v1.0/groups?$filter=mail%20eq%20'my_email@xx.com', with no luck.
I tried putting the URI in a variable, same problem. I tried adding ConsistencyLevel: eventual and $count=true in case the issue was to do with filter being an advance query capability, same error as above.
The only thing that worked was if I use the URI without the OData query, e.g. https://graph.microsoft.com/v1.0/groups
That means that I can fetch all the groups but not a specific one. The problem that I faced here is that this only returns the first 100 results, not the whole list of groups, therefore I am unable to work with filtering the JSON file later on in the flow, and of course I cannot use the $top query option as I'm faced with the above error.
URI path is not a valid Graph endpoint, path is neither absolute nor relative or resource is not one of the supported (me, users, groups, sites, search, planner, teams, chats): https://graph.microsoft.com/v1.0/groups?$top=200
Test 2
I used a generic HTTP request for the URI with the filter https://graph.microsoft.com/v1.0/groups?$filter=mail eq 'my_email@xx.com' and it worked. However I didn't know how to authenticate, so copied the temporary Bearer token from Graph explorer for testing purposes, but obviously it expired so I cannot use this solution.
I tried using Basic authentication using the O365 email and password, but the HTTP request failed with error CompactToken parsing failed with error code: 80049217.
My question is please could you help me with why the Test 1 might not be working in power automate when working fine in Graph explorer, or why the basic authentication isn't working for Test2?
Thank you!
J
