Power Platform Community Forum Thread Details

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!

Categories:

Building flows

Power Automate Desktop

Using flows

Hi @Cece-1612,

You can absolutely set this up in Power Automate, and honestly your current process already has most of the foundation in place. Since the Microsoft Form responses are already being saved into Excel, the easiest option would be to create a second flow that runs on a schedule and sends a summary email automatically to your selected users.

What I’d personally recommend is creating a Scheduled Cloud Flow that runs either daily or weekly depending on how often your team wants updates. Instead of sending every individual submission manually, the flow can pull all responses from the Excel spreadsheet for a specific timeframe and compile them into one clean email summary.

The setup would look something like this:

Use a Recurrence trigger to run the flow daily/weekly
Pull the form responses from Excel using List rows present in a table
Filter the rows by submission date (today, last 7 days, etc.)
Format the results into an HTML table or summary section
Send the report using Send an email (V2) in Outlook

You can keep the email simple at first with things like:

Total number of submissions
Submission dates
Key response details
Request types or categories
Follow-up items

Then later, if needed, you can make it more advanced by grouping responses or showing trends. For example, you could summarize:

Most common request types
Number of submissions per category
Open vs completed items
Weekly trends or recurring issues

One thing that really helps is having a timestamp column in the Excel table. That makes it much easier to filter only the responses from the current day or week.

Hopefully that points you in the right direction.

✅ If this helped solve your issue, please Accept as Solution so others can find it quickly.

❤️ If it didn’t fully solve it but was still useful, please click “Yes” on “Was this reply helpful?” or leave a Like :).

🏷️ For follow-ups @Sajeda_Sultana