Skip to main content

Notifications

Community site session details

Community site session details

Session Id : SxAOCqrjA93PCveX8fsIFV
Power Automate - Building Flows
Answered

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

Like (0) ShareShare
ReportReport
Posted on 14 May 2019 16:00:39 by 52

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. 

  • Verified answer
    v-yamao-msft Profile Picture
    on 17 May 2019 at 09:26:27
    Re: Send copy of email to SharePoint Folder when email address is in SharePoint list

    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

     

  • mhines Profile Picture
    52 on 16 May 2019 at 15:13:20
    Re: Send copy of email to SharePoint Folder when email address is in SharePoint list

    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? 

     

     

  • Verified answer
    v-yamao-msft Profile Picture
    on 16 May 2019 at 08:47:06
    Re: Send copy of email to SharePoint Folder when email address is in SharePoint list

    Hi @mhines ,

     

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

    1.PNG

     

    Best regards,

    Mabel

     

  • mhines Profile Picture
    52 on 15 May 2019 at 18:15:30
    Re: Send copy of email to SharePoint Folder when email address is in SharePoint list

    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? 

  • v-yamao-msft Profile Picture
    on 15 May 2019 at 07:15:34
    Re: Send copy of email to SharePoint Folder when email address is in SharePoint list

    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

     

  • Brad_Groux Profile Picture
    4,556 on 14 May 2019 at 16:48:13
    Re: Send copy of email to SharePoint Folder when email address is in SharePoint list

    @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!

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Markus Franz – Community Spotlight

We are honored to recognize Markus Franz as our April 2025 Community…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,679 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 66,015 Most Valuable Professional

Leaderboard