web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Move a File from One S...
Power Automate
Unanswered

Move a File from One SharePoint Folder to Another Based on Received Email

(0) ShareShare
ReportReport
Posted on by 9

Hello,

 

I am trying to automatically create a copy of a file in a SharePoint folder and move that copy to another SharePoint folder. The trigger to create the copy would be based on a response to an email containing the original file. The response would say "approved" in the email body, but not contain the email attachment (original file).

 

The flow would look like the following in my mind-

1. Send emails with attached reports to clients for approval (this process is already automated)

2. Client sends email response back approving report accuracy. (email response does not contain original attachments)

3. Based off of email response, locate reports saved in SharePoint folder and create copies of reports.

4. Move copies of reports to a 2nd SharePoint folder for "approved" reports.

 

Thank you for any help!

Categories:
I have the same question (0)
  • SudeepGhatakNZ Profile Picture
    14,394 Most Valuable Professional on at

    @GraceHerbert ,

    The following video describes how you can parse the content of an email to extract relevant information

    https://youtube.com/watch?v=7tZ6bRtco3Y&feature=share&si=EMSIkaIECMiOmarE6JChQQ

    Once you know the file location, you could just use the Copy to action to achieve what you want.

    SudeepGhatakNZ_0-1666846853498.png

     

  • GraceHerbert Profile Picture
    9 on at

    This is helpful. I was able to use the parse content to extract the email elements needed. However, my other problem is in this example the email text always remains in the same sequence. We will be extracting text after a reply email so the initial email text range may be like this:

     

    Original email sent: Text sits in row 5

    Reply email is received: Test sits in row 5+n

  • SudeepGhatakNZ Profile Picture
    14,394 Most Valuable Professional on at

    @GraceHerbert ,

     

    Are you able to share a screenshot of your flow and its output?

     

  • GraceHerbert Profile Picture
    9 on at

    Attached screenshots.

     

    In this example the rows I am grabbing the information from are on 13 and 14 (report name) & (accept/reject). The issue though would be if text is included in the email reply above the original email then the relevant info I need may shift down by n lines depending on the email response length.

     

    Thank you.

    Screenshot (21).png
    PA Array Output.JPG
    Screenshot (22).png
  • SudeepGhatakNZ Profile Picture
    14,394 Most Valuable Professional on at

    @GraceHerbert ,

     

     

    Can you not get rid of everything before "Report Name:" using split?

    split(Outputs('HtmlToText"),'Report Name:')[1]

     

    You can break the remaining text into multiple lines.

    That way the Report Name will always appear on top of the line.

     

  • GraceHerbert Profile Picture
    9 on at

    When adding the split after the Filter Array I'm getting an error message around object/string. 

     

    GraceHerbert_0-1667484302673.png

     

  • SudeepGhatakNZ Profile Picture
    14,394 Most Valuable Professional on at

    What expression are you using in Compose?

    What are the inputs to your Compose action?

     

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
David_MA Profile Picture

David_MA 262 Super User 2026 Season 1

#2
Haque Profile Picture

Haque 227

#3
Expiscornovus Profile Picture

Expiscornovus 225 Most Valuable Professional

Last 30 days Overall leaderboard