Hi @jimbobuk,
Yes, no problem. Here is step-by-step walkthrough. Btw, the screenshots should be clickable (which should open a dialog with a clearer picture).
1. Add a Initialize variable action
a. Provide a name, OwnerandMemberArray
b. Select Array Type
c. In Value use []
2. Add a second Initialize variable action
a. Provide a name, MembershipArray
b. Select Array Type
c. In Value use []
3. Add a Get User Profile (v2) action
a. use the email of the user for which you want to lookup the memberships
4. Add a Send an HTTP request (Office 365 Groups connector action)
a. Rename action to Send an HTTP request - ownedObjects
b. Use the following URI
https://graph.microsoft.com/v1.0/users/@{outputs('Get_user_profile_(V2)')?['body/id']}/ownedObjects/?$select=id,displayName
5. Add a Select action
a. Rename action to Select - ownedObjects
b. Use the following expression in From
body('Send_an_HTTP_request_-_ownedObjects')['value']
c. Switch map to text mode and use the following expression
item()['id']
6. Add an Apply to Each action
a. Rename action to Apply to each - ownedObjects
a. Use the following expression in the Select an output from previous steps field
body('Send_an_HTTP_request_-_ownedObjects')['value']
7. Add an append to Array variable action (within Apply to each - ownedObjects)
a. Select the MembershipArray
b. Use the following value
{"id":"@{item()['id']}","displayName":"@{item()['displayName']}","role":"owner"}
8. Add a Send an HTTP request (Office 365 Groups connector action)
a. Rename action to Send an HTTP request - memberOf
b. Use the following URI
https://graph.microsoft.com/v1.0/users/@{outputs('Get_user_profile_(V2)')?['body/id']}/memberOf/?$select=id,displayName,role
9. Add a Select action
a. Rename action to Select - memberOf
b. Use the following expression in From
body('Send_an_HTTP_request_-_memberOf')['value']
c. Switch map to text mode and use the following expression
item()['id']
10. Add a Set Variable action
a. Select the OwnerandMemberArray
b. Use the expression below for the Value field
intersection(body('Select_-_ownedObjects'),body('Select_-_memberOf'))
11. Add an Apply to Each action
a. Rename action to Apply to each - memberOf
a. Use the following expression in the Select an output from previous steps field
body('Send_an_HTTP_request_-_memberOf')['value']
12. Add a Filter Array action (within Apply to each - memberOf)
a. Use the OwnerandMemberArray variable in the From
b. Click Edit in advanced mode and add the following expression
@equals(item(), items('Apply_to_each_-_memberOf')['id'])
13. Add a Condition action (within Apply to each - memberOf)
a. Use the following check
length(body('Filter_array'))
is equal to 0
14. Add a Append to array variable (within Apply to each - memberOf, in the If yes of the Condition)
a. Rename action to Append to array variable - memberOf
b. Select the MembershipArray
c. Add the following to the Value field
{"id":"@{item()['id']}","displayName":"@{item()['displayName']}","role":"member"}
