Answered

Send copy of email to SharePoint Folder when email address is in SharePoint list

(0) Share

Report

Posted on by mhines

We would like to setup a Workflow that checks the "From" email address in incoming email against a list that is maintained in a Microsoft Team.

That list would basically include the email addresses and then a folder location within that Microsoft Team.

If the email address matches, the email would be copied to that folder location.

I can't seem to find a template that would get me started on this and any help/guidance would be appreciated.

Categories:

Building flows

I have the same question (0)

All responses (6)

Answers (2)

Brad_Groux 4,556 on at

Like (0)

Report

@mhines wrote:
I can't seem to find a template that would get me started on this and any help/guidance would be appreciated.
You won't find templates with super-specific needs like you are seeking. The templates are there more for very generic workloads and should be used as inspiration for ideas on how to expand your Flows. Your desired Flow could look something like this:
Note, this is the bare mininum for the actions you are seeking, and is only mean to be a guide.
If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Was this reply helpful? Yes No
v-yamao-msft on at

Like (0)

Report
Hi @mhines ,

Do you want to save emails to corresponding folders according to the “From” email address?

Please check if the following flow will be working for you.

First, the SharePoint list contains two columns, From and FolderPath, both of them are of type Single line of text.

Then start the flow likes below. In the action Get items, input below statement to filter out the specific item:

From eq 'From'

Note: dynamic content comes from the trigger, which should be surrounded with a single quote.

Then within the apply to each, export the email first, then create a file to the corresponding folder path. Note, select dynamic content FolderPath from action Get items for the Folder path field.

An image for your reference.

Best regards,

Mabel

Was this reply helpful? Yes No
mhines 52 on at

Like (0)

Report

This has been a great help.

It's at least launching and getting past a couple steps. Where I'm trying with is what information gets inputted into the Folder Path field. I've tried the full address that I get when I use the "Copy Link" from within SharePoint - that errors out. I tried the full address that is in the address bar when I'm in that folder, and that errors.

I thought perhaps it is adding the Folder Path to the already entered Site Address so I just entered just the address portion beyond the Site Address, but that errors also.

Any ideas on what part/portion/format the Folder Path should be in?

Was this reply helpful? Yes No
Verified answer

v-yamao-msft on at

Like (0)

Report

Hi @mhines ,

When testing this issue, I just configured the Folder path to something likes below in the list:

Best regards,

Mabel

Was this reply helpful? Yes No
mhines 52 on at

Like (0)

Report

I had just figured that out late yesterday and didn't get a chance to respond.

I also was able to figure out how to get embedded images to get into the email, but now I'm looking for tips on dealing with attachments. I see the name being listed in the email, but the actual attachment isn't included.

Is the only way to do this is to save the attachment outside of the email?

Was this reply helpful? Yes No
Verified answer

v-yamao-msft on at

Like (0)

Report

Hi @mhines ,

If you want to check the attachments, you may need to save the attachments outside of the .msg file under the same folder.

Best regards,

Mabel

Was this reply helpful? Yes No