cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Advocate II
Advocate II

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

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. 

2 ACCEPTED SOLUTIONS

Accepted Solutions

Hi @mhines ,

 

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

1.PNG

 

Best regards,

Mabel

 

Community Support Team _ Mabel Mao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

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.

1.PNG

 

Best regards,

Mabel

 

Community Support Team _ Mabel Mao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

6 REPLIES 6
Super User II
Super User II


@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:SaveEmailToFolders.PNG

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!

Community Support
Community Support

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.

1.PNG

 

Best regards,

Mabel

 

Community Support Team _ Mabel Mao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

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? 

Hi @mhines ,

 

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

1.PNG

 

Best regards,

Mabel

 

Community Support Team _ Mabel Mao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

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? 

 

 

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.

1.PNG

 

Best regards,

Mabel

 

Community Support Team _ Mabel Mao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Helpful resources

Announcements
Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

New Super Users

Meet the Power Automate Super Users!

Many congratulations to the Season 1 2021 Flownaut Crew!

New Badges

New Solution Badges!

Check out our new profile badges recognizing authored solutions!

MPA Community Blog

Power Automate Community Blog

Check out the community blog page where you can find valuable learning material from community and product team members!

Users online (75,794)