Power Platform Community Forum Thread Details

I want to export mails to CSV, and this should be from a particular time period, and I'd want the Sender name, subject, date, Body to be added in diff columns. I am surprised that there is no simple way to achieve this.

So if someone has exported mails using Outlook, please help me.

Categories:

Building flows

You would just do this:

Make a call to the graph API to retrieve the e-mails: https://graph.microsoft.com/v1.0/me/messages, which you'll most likely want to filter. This post shows an example: How To Get Over 25 Emails In Power Automate
In your flow create a string variable. Make the default value the headings for the csv file. For example, Sender, Subject, Date, Body. Use this expression at the end to add a carriage return decodeUriComponent('%0A')
Add an apply to each to process each of the e-mails.
In the apply to each, use the append to string variable action to create the csv file and populate the values in the order you set the header as the default value for the string variable making sure to add a comma after each, and adding the carriage return at the end.
You can then save the output of the variable to a csv file.

The biggest challenge you will probably have is with the body. You will need to figure out how to deal with any potential commas in the body. You will also most likely want to use the convert html to text action on the body as well. I currently don't foresee me having any need to do something like this, so I am not even going to try and figure out how to deal with the body.

You may want to test what I outline above without adding the body. If it does what you want, then add the body and see what challenges you have and make a new post specific to that.