You’re offline. This is a read only version of the page.
Hi all,
I'm struggling in my first attempt to create a flow that will trigger when an email is received into a shared mailbox, and will then copy the sender's name and email subject, and append them to the next available row in a specific Excel worksheet.
As per the image below, if we receive an email into our mailbox, the sender's name and email subject are added to the highlighted row below:
And then when the next email arrives, the same thing occurs...it adds the next sender's name and email subject to the next row.
Is something like this possible to do? The spreadsheet is kept in Sharepoint.
TIA, Smorty.
Hi @smorty ,
If you have set the worksheet to table, you will see that all columns appear automatically in the "Add a row into a table" action.
Best Regards,
Habsburg Qian
If this post helps, then please consider Accept it as the solution to help the other members find it.
Sorry, what I mean is, I don't know how to setup the flow so it takes the information from the email, and outputs that information into specific cells in the worksheet.
As an example (see below), when the email comes into the shared mailbox, how do I add a new row and capture the:
Apologies if I am not explaining it correctly.
Also, this worksheet is not setup as a table. Does it need to be to allow this flow to work?
Hi @smorty ,
I don't understand what you mean. Why not set column I to 'sender' and column J to 'subject' in the excel file beforehand?
Best Regards,
Habsburg Qian
If this post helps, then please consider Accept it as the solution to help the other members find it.
Is it also possible to specify the column that I need to have the data in as well?
In our file, the 'sender' information needs to be added into column I, and the 'subject' information into column J.
Is that also possible? Or do I need to look at swapping the columns around. Swapping them around would be the last option though.
Hi @smorty ,
You can create flows like this:
The result of the example flow is like:
The first column is a value include date and time.
"sender" column is the email address of sender.
To get the same data format as in your picture, we need to use some formulas.
Best Regards,
Habsburg Qian
If this post helps, then please consider Accept it as the solution to help the other members find it.
#1
Michael E. Gernaey
223
Super User 2025 Season 1
#2
David_MA
222
Super User 2025 Season 1
#3
stampcoin
194
Share
Report
All responses (
Answers (