1

I have used Power automate flow to return O365 group owners using Graph API. It has returned data in @odata.context. From that output I need only "Email" field so I can send it to Powerapps in a table format.

After I get output from Graph API I am using compose operation and after that select operation to get Email field of users.

But in compose operation not sure what expression to use in order to compose the data. Can you guide?

Improve this question
3
  • Can you show us the format of output/response you are getting? Based on that we can suggest the expression to use.
    – Ganesh Sanap - MVP
    Commented May 24, 2023 at 6:07
  • { "@odata.context": "graph.microsoft.com/v1.0/$metadata#directoryObjects", "value": [ { "@odata.type": "#microsoft.graph.user", "id": "123", "businessPhones": [ "82" ], "displayName": "abc", "givenName": "xyz", "jobTitle": "acb", "mail": "Email", "mobilePhone": null, "officeLocation": "OFFICES", "preferredLanguage": null, "surname": "bc", "userPrincipalName": "UPN mail" ] }, }
    – Prathamesh Bhalerao
    Commented May 24, 2023 at 6:30
  • Check my answer given below
    – Ganesh Sanap - MVP
    Commented May 24, 2023 at 6:52

1 Answer 1

Reset to default
1

You can directly use output from your Graph API call in Select action without using Compose action.

Use Power automate flow like this:

enter image description here

Expressions used:

From property:

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

Here, instead of body('HTTP'), you can write name/output of your actual Graph API action.

Map property: Right hand side expression for Email

@item()?['mail']

Output: Email addresses in table/array of objects format

enter image description here

Improve this answer
0

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.