Answered

Count incoming email in a shared mailbox and save to a file in Sharepoint

(0) Share

Report

Posted on by Ash-PA

Hi,

I'm new to Power Automate and would like to build a flow for counting incoming e-mail in a shared mailbox. The purpose is to count incoming e-mail (have one row per e-mail), save this in Sharepoint and then display the data in Power BI.

I've set up a connection to the shared mailbox and the Sharepoint. But don't really know what the next step is.

Ultimately I'd like to save every incoming email in one .csv-file (or .xlsx-file is .csv isn't optional) in a Sharepoint-folder with columns/data such as:

From
To
CC
Date
Subject
Body

And more if possible.

The best thing would be if I could have one .csv/.xlsx-file with rows of emails per year.

Thanks in advance!

Sincerely

Ash

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

v-LilyW-msft on at

Like (2)

Report
Re: Count incoming email in a shared mailbox and save to a file in Sharepoint

Hi @Ash-PA
Thank you for your posting.
According to your description, you want to save every incoming email to a csv-file or xlsx-file.
I have made a test on my side and please take a try with the following workaround
Add a proper trigger：When a new email arrives in a shared mailbox (V2)
Add a "Add a row into a table" action, File field set to dynamic content of the " When a new email arrives in a shared mailbox (V2)" trigger.
Then save the flow and test it.
When a new email be sent to shared mailbox
The new row will be added into the excel.
If you want to receive an email with the file every year, you can create a scheduled cloud flow to send an email to you every year.
Please refer to as below:
After Flow runs, can receive an email as below:
Hope the content above may help you.
Best Regards
Lily

Was this reply helpful? Yes No
Ash-PA 5 on at

Like (0)

Report

Re: Count incoming email in a shared mailbox and save to a file in Sharepoint

Hi @v-LilyW-msft,

Thank you so much for the help.

It really did just what I wanted it to do 😊

Sincerely
Ash

Was this reply helpful? Yes No