Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Automate - Building Flows
Answered

Send all form results in daily email

(0) ShareShare
ReportReport
Posted on by

Sorry for what may be a simple request. I'm brand new to flows and still researching how to do this but thought I'd try here too.

 

I'd like to email all form results from a single form daily as an Excel attachment. I've played with a few flows on sending emails on form submission but can't figure out how to do that with an "occurrence" at the start.

 

 

 

 

 
 
  • v-litu-msft Profile Picture
    on at
    Re: Send all form results in daily email

    Hi @Anonymous,

     

    OK, if you want to collect all responses of 40 staff, you could follow my previous reply to create the Flow, but you need to remove send Email action.

     

    Then create the other Recurrence Flow runs on12:00 every day to send the Excel file:Annotation 2020-04-03 141335.png

     After sending the Excel file, if you want to use the excel file to accept responses of tomorrow, you could following these steps to empty the Excel file:

    Annotation 2020-04-03 141336.png

     

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

  • Community Power Platform Member Profile Picture
    on at
    Re: Send all form results in daily email

    @v-litu-msft @ChristianAbata  thanks for responses.

     

    @v-litu-msftyour solution looks close to what I want but I don't want the email sent per form submission I want an email sent once a day with all submissions from the day. What we're doing is having about 40 staff complete a form by 9:00 am for equipment requirements and I need to then have *all* form submissions sent as a spreadsheet to managers by noon. We're exporting and doing that manually right now.

  • Verified answer
    v-litu-msft Profile Picture
    on at
    Re: Send all form results in daily email

    Hi @Anonymous,

     

    So, you submit an MS Form daily and want to get these answers but do not know how to get it, right?

    You could add a Get response details action after the trigger, then append these answers into the Excel table by using Add a row into a table action, then just like @ChristianAbata shows, Get the Excel file content and put it into the Send Email action as a attachment:

    Annotation 2020-04-02 114858.png

     

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

  • Verified answer
    ChristianAbata Profile Picture
    8,949 Most Valuable Professional on at
    Re: Send all form results in daily email

    hi @Anonymous  what you can do is something like this.

    reponse.PNG

     

    Please note that responders email just works with users inside your Org. For externals you need to define a field like Give me your email to send after the email.

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