Answered

Copying email data into a new row in Excel

(0) Share

Report

Posted on by smorty

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.

Categories:

Building flows

I have the same question (0)

All responses (6)

Answers (1)

v-zhoqian-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
smorty 8 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
v-zhoqian-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
smorty 8 on at

Like (0)

Report
Copy link

Link copied!
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:
date and add that into column A
the sender's name and add that into column I
the email subject and add that into column J

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?

Was this reply helpful? Yes No
Verified answer

v-zhoqian-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
smorty 8 on at

Like (0)

Report
Copy link

Link copied!

Perfect and thanks for all your help, I can see the fields now, and also know for next time that any updates need to going into a worksheet that has been formatted as a table.

Was this reply helpful? Yes No