Forum Discussion
Populate report with email content
If your organization is using Microsoft Exchange Server to provide email, you can use Microsoft Exchange connector to import email data into Power Query Editor. Go to Get Data > Other > Microsoft Exchange.
Once you connect to your email account and select Mail in Navigation window, it will load all emails under this account. You can filter rows to keep only survey emails and remove unneed columns. In Body column, you will see all data in Email body. You can expand this column and select TextBody.
Then you can transform the TextBody column to extract questions and answers into the format you want. Once you have shaped the data into the format you want, you can create a report based on it easily.
Here is a blog for your reference: Using PowerQuery with Email - The Excelguru Blog
Regards,
Community Support Team _ Jing
If this post helps, please Accept it as the solution to help other members find it.
Yes. Your Flow could write each email to a file on SharePoint/OneDrive and then use PBI to transform and combine those files. Or your Flow could parse the data and send it to a SharePoint list, Dataverse for Teams, or a PBI Streaming Dataset.
Pat