web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / How to email data from...
Power Automate
Unanswered

How to email data from the Microsoft Graph API in Array format

(0) ShareShare
ReportReport
Posted on by 364

Hi All, 

 

like the subject line suggests, I am looking for help emailing data as an array. 

 

I have a flow that send out an email when accounts are deactivated in Azure AD, so that our various IT users know to remove licenses and app permissions from the deactivated users. I would like to use Graph to send an email that provides a list of all the licenses that user has assigned to them, so the person removing the licenses can be doubly sure they have removed them all. 

 

My issue is in formatting the Graph data:

Aurora_0-1694620799923.png

^here is how Graph return the data, and how I would like to email it (or insert into a word document but I know how to do that part) 

 

My issue is when I try to append it to a variable and email it to anyone, it loses the formatting: 

Aurora_1-1694621045148.png

Here is part of my flow:

Aurora_2-1694621155151.png

Aurora_3-1694621409648.png

 

Does anyone have any suggestions for how I can send the data in an email with its original array format? 

Categories:
I have the same question (0)
  • VictorIvanidze Profile Picture
    13,073 on at

    Create a HTML document and use it as the email body.

  • Aurora Profile Picture
    364 on at

    @VictorIvanidze 

     

    I have tried, but am still getting all of the data returned in one large paragraph instead of the Array format

    Aurora_1-1694630287541.png

    Aurora_2-1694630331740.png

     

  • VictorIvanidze Profile Picture
    13,073 on at

    Please show what exactly you want a recipient will see in email?

  • Aurora Profile Picture
    364 on at

    I want them to see this output: 

    Aurora_0-1694631781283.png

    It does not matter if the text is in the body of the email or an attachment, but I just need to keep this formatting so it is readable for end users

  • VictorIvanidze Profile Picture
    13,073 on at

    Place the output of Compose action to the body of email.

  • Aurora Profile Picture
    364 on at

    The result is the same when using the output of the Compose action. The formatting is lost.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 522 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 364 Moderator

#3
abm abm Profile Picture

abm abm 243 Most Valuable Professional

Last 30 days Overall leaderboard