Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Automate - Building Flows
Answered

Daily modification email through flow that shows who modified a file in that day

(0) ShareShare
ReportReport
Posted on by 14

Hi,

I am trying to create a flow that will give a daily email at the end of the day with who modified a specific file during that 24 hour day. If you could explain how to do this that would be great because every time I try to create this it gives me the wrong kind of email or errors. I am really struggling with this so if you could help me that would be great.

 
  • nathanbrey1 Profile Picture
    14 on at
    Re: Daily modification email through flow that shows who modified a file in that day

    @v-wenjuan-msft do you have an answer for me?

  • nathanbrey1 Profile Picture
    14 on at
    Re: Daily modification email through flow that shows who modified a file in that day

    nathanbrey1_0-1688585004763.pngScreenshot 2023-07-05 6969.png

    Hi @v-wenjuan-msft this is what comes up on the error. The email I received and then the error message on microsoft flows.

  • v-wenjuan-msft Profile Picture
    Microsoft Employee on at
    Re: Daily modification email through flow that shows who modified a file in that day

    Hi @nathanbrey1 ,

     

    According to your screenshot I cannot figure out where the issue happen.

    Would you please open one of the failed flow run history and let me see at which step does the flow fail and what's the error message?

     

  • nathanbrey1 Profile Picture
    14 on at
    Re: Daily modification email through flow that shows who modified a file in that day

    Hi @v-wenjuan-msft I am running into a few more issues. I got an email saying my flow failed. Maybe you can help? I created an empty list called Updates you can see in the create item and then have the create item flow step linked to an empty table on that list file. I am not sure why I keep running into these issues. Please give some help

    Web capture_29-6-2023_12517_make.powerautomate.com.jpegWeb capture_29-6-2023_125210_make.powerautomate.com.jpeg

  • v-wenjuan-msft Profile Picture
    Microsoft Employee on at
    Re: Daily modification email through flow that shows who modified a file in that day

    Hi @nathanbrey1 ,

     

    Here are some potential solutions for your reference:

    1. Are you sure you pick the right site where the newly created list exists?

    2. Check connection to ensure you have access to visit the list.

    3. Try to remove the action "Create item" and add a new one.

    4. Just create a new list in that site again for test.

     

    If none of above works, find your list ID like this.

    vwenjuanmsft_0-1687917294447.png

    vwenjuanmsft_1-1687917373708.pngvwenjuanmsft_2-1687917415339.png

     

    vwenjuanmsft_3-1687917449991.png

     

    Community Support Team _ Wenjuan Zou

    If this post helps, then please consider Accept it as the solution to help the other members find it.

  • nathanbrey1 Profile Picture
    14 on at
    Re: Daily modification email through flow that shows who modified a file in that day

    Hi @v-wenjuan-msft 

    I am just trying to complete this and I am running into an issue on the second part. I did the first part go to add second step and then run into problems. When selecting list name there is no list name unlike the library name in the previous step. If i just input a name into the List Name that I come up with there is not the same options you can see like A and B. Again thank you for all your help. I attached two pictures to show you the problem I am running into. 

     

     

     

     Screenshot 2023-06-27 121104.pngScreenshot 2023-06-27 120935.png

  • Verified answer
    v-wenjuan-msft Profile Picture
    Microsoft Employee on at
    Re: Daily modification email through flow that shows who modified a file in that day

    Hi @nathanbrey1 ,

     

    First you need to put the file in a separate folder, which means there should be only one file in that folder. Pre-create a list to store modification records.

    Next we build first flow to record each time modification into a SPO list:

    vwenjuanmsft_0-1687225711982.png

    Then we will create a schedule flow to send the modification list via email:

    vwenjuanmsft_2-1687226025085.png

    vwenjuanmsft_4-1687226116938.png

     

    Community Support Team _ Wenjuan Zou

    If this post helps, then please consider Accept it as the solution to help the other members find it.

  • nathanbrey1 Profile Picture
    14 on at
    Re: Daily modification email through flow that shows who modified a file in that day

    Hi! Thanks for the reply, the second option would be best. Can you explain how I can set that up? 

  • v-wenjuan-msft Profile Picture
    Microsoft Employee on at
    Re: Daily modification email through flow that shows who modified a file in that day

    Hi @nathanbrey1 ,

     

    As the SharePoint "Modified By" will only show the user who make the latest change. There are two potential solutions for your reference, I will help to complete it depends on your choice.

    1. Trigger a flow every time when the file get modified and send an email for notifications.

    2. Trigger a flow every time when the file get modified and record it to a list. Trigger another flow daily to send an email for notifications and clear the list.

     

    Community Support Team _ Wenjuan Zou

    If this post helps, then please consider Accept it as the solution to help the other members find it.

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

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 497 Super User 2025 Season 1

#2
David_MA Profile Picture

David_MA 436 Super User 2025 Season 1

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 244 Super User 2025 Season 1