Share via

How to add end of day reports for an existing Power Automated Form

Escamilla, Cecilia 0 Reputation points
2026-05-15T21:04:44.3466667+00:00

Hi - I currently have a Microsoft Form connected to Power Automate. Whenever a new form submission is received, the response is automatically posted into a Teams Channel. We also have an Excel spreadsheet that records all form submissions.

I'm looking for guidance on setting up an automated flow that can send these form responses via email to a selected group of users on a scheduled basis. Preferably either by end of day or weekly, the goal is to make it easier to track trends and review submissions without having to manually go through each form response individual.

Ideally, the email summary could include key details such as trends or grouped responses to help with visibility and follow up.

any help or guidance is greatly appreciated!

Microsoft 365 and Office | Microsoft Forms | For business
0 comments

Answer accepted by question author

  1. Ruby-N 11,245 Reputation points Microsoft External Staff Moderator
    2026-05-15T21:44:50.2666667+00:00

    Good day @Escamilla Cecilia, and I appreciate the clear explanation of your concern.  

    From what you described, you already have an event-driven flow that runs “per submission” (Forms submission posts to a Teams channel and logs to an Excel file). 

    Since my current category primarily focuses on Office 365 products, and your concern relates to Microsoft Power Automate, I want to ensure you receive the most accurate and effective assistance. For this reason, I recommend posting your question in the Microsoft Power Platform Community Forum. In this forum, you'll get the most qualified group of respondents and other partners who read the forums regularly can share their knowledge or learn from your interaction.    

    User's image

    I apologize for redirecting you to a different community, as the members of this category focus on Office 365 concerns and have limited knowledge about Power Automate. To help you get quicker and better assistance, we are guiding you to the appropriate resource. 

    As community moderators, we kindly ask for your understanding that our access to internal development details is limited. Our primary role is to guide users toward the appropriate resources and support channels. While we may not have visibility into performing deeper backend analysis, we’ll continue doing our best to support you within the scope of our responsibilities.     

    Thank you once again for your precious time and engagement.  

    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have any extra questions about this answer, please click "Comment".  

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.  

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Q&A Assist
    2026-05-15T21:04:59.7+00:00
    AI generated content. This question contains an answer created with AI from Q&A Assist. Learn more

    Use the existing Form → Excel setup as the data source, then create a separate scheduled flow in Power Automate that reads from Excel and sends a summary email.

    A simple approach based on the available guidance:

    1. Ensure the Excel file is ready
      • Store the workbook in OneDrive or SharePoint.
      • Make sure the data is in an Excel table (use Format as Table in Excel) and that columns match the form fields being collected.
    2. Keep (or create) the Form → Excel flow
      • If not already in place, use a flow that:
        • Trigger: Microsoft Forms – When a new response is submitted.
        • Action: Microsoft Forms – Get response details.
        • Action: Excel Online (Business) – Add a row into a table to write each response into the Excel table.
      • This is the same pattern described for adding form responses to Excel.
    3. Create a scheduled summary flow
      • In Power Automate, select Create → Scheduled cloud flow.
      • Set the schedule (e.g., every day at 23:59 for end-of-day, or once a week for weekly).
    4. Read the data from Excel
      • Add a new step: Excel Online (Business).
      • Use an action such as List rows present in a table (not shown explicitly in the context but is the standard companion to Add a row into a table).
      • Point it to the same Location, Document Library, File, and Table that the Form → Excel flow uses.
    5. Build the email body
      • Add an email action (for example, from Outlook) and set To to the distribution list or group of users.
      • In the Body, use dynamic content from the Excel rows to build a summary:
        • For a simple list: include key columns (e.g., Date, Category, Status, etc.).
        • For basic trend visibility: group or highlight key fields (for example, count how many responses per category) using expressions or by aggregating in Excel itself (pivot table or summary sheet) and then reading that summary range instead of raw rows.
    6. Save and test
      • Save the scheduled flow.
      • Manually trigger it once (using Run in Power Automate) to confirm that:
        • It reads the expected rows from Excel.
        • The email is delivered to the target users with the expected content.
    7. Optional: separate daily vs. weekly summaries
      • Create two scheduled flows with different recurrence settings (daily and weekly) that both read from the same Excel table but build different summaries (for example, weekly flow referencing a weekly summary sheet in Excel).

    This design uses:

    • The Forms trigger When a new response is submitted and action Get response details.
    • Excel Online (Business) Add a row into a table to store responses.
    • A separate scheduled flow that reads from the Excel table and sends an email summary on the desired cadence.

    References:

    Was this answer helpful?

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.