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 / Flow OneDrive to E-Mail
Power Automate
Answered

Flow OneDrive to E-Mail

(0) ShareShare
ReportReport
Posted on by

I have a problem, I create a flow wth OneDrive - E Mails

 

Flow function:

When we change a file in a special folder, I get an info via E-Mail -- this is corect.

 

My problem is, when we change 10 or 100 times per day the files so I get 10 or 100 E-Mails per day.

This is very stupid.

What can I do, to get only one mail per day how matter the files are changed per day.

 

Thank you very much.

 

Regards

Categories:
I have the same question (0)
  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    I think the best idea is to create a Flow based on a schedule and run it every day. Then you can create an html table and do a for each for all changed files. At the end you can send the html table by email and I hope your problem is solved. 🙂

  • Verified answer
    v-xida-msft Profile Picture
    Microsoft Employee on at

    Hi @Chris-Spm,

     

    Could you please share a screenshot of your flow's configuration?

     

    If you want to achieve your needs within one single flow, I afraid that there is no way to achieve your needs in Microsoft Flow currently.

     

    You could consider take a try to create two separated flows to achieve your needs. The first flow is used to store the modification information of files in your specific folder, you could store these modification information in a Excel file stored in your OneDrive folder. The Second flow is used to send Email notification about the modification information per day.

     

    I have made a test on my side and create a Excel file (ModificationInformation.xlsx) to store the modification information (The Excel file is stored in my OneDrive folder), the data structure of it as below:23.JPG

     

     

    Please take a try with the following workaround:

    First Flow:24.JPG

    The flow works successfully as below:25.JPG

     

     

    Second Flow:26.JPG

     

    27.JPG

     

    28.JPG

     

    Note: Within "Create HTML table" action, set Include Headers to Yes and set Columns to Custom, type the entries as above. In addition, Within Body field of "Send an email" action, type Output dynamic content of "Create HTML table" action, Is HTML set to Yes.

     

    The flow works successfully as below:29.JPG

     

    30.JPG

     

     

    Best regards,

    Kris

     

     

     

     

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!

Congratulations to the March Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Haque Profile Picture

Haque 605

#2
Valantis Profile Picture

Valantis 340

#3
11manish Profile Picture

11manish 284

Last 30 days Overall leaderboard