web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Send one weekly email ...
Power Automate
Unanswered

Send one weekly email with data from multiple form submissions.

(0) ShareShare
ReportReport
Posted on by 1

My client has asked I submit data in one weekly email.

 

At this time, my flow submits data via email from each form submission.  This results in 5-10 emails daily.

 

I am struggling to develop a flow that pulls data from each form submission, inputs the data from each form submission, then inserts the data into one email template.

 

My current flow logs each form submission into an excel table and inserts the data from each submission into an email template, then the data is pulled from excel and sends the email each time.

 

The data points from each form submission must be grouped, and submitted in one email, e.g.

 

1)

 

Favorite Color:  Blue

Favorite Sport: Hockey

Favorite Day:  Tuesday

Favorite Food:  Pizza

Favorite Animal:  Cat

 

…

 

2)

 

Favorite Color:  Red

Favorite Sport: Football

Favorite Day:  Friday

Favorite Food:  Pasta

Favorite Animal:  Giraffe

 

etc.

 

Thanks in advance!

Categories:
I have the same question (0)
  • Andrew_J Profile Picture
    1,962 Moderator on at

    @StreetMA 

     

    I essence you would like to send a weekly email on a certian day and time that contains the dta for all form submissions up and till that date and time.  The data of all the form submissions should be sent with a HTML table in the body of the email.  Then look at the following and copy this.

     

    https://www.youtube.com/watch?v=0TpjWPYlxY4

     

    You will need to record all the data in a SP list for the above to work.  Also we will need to ammend the above but look at the HTML at the end.

     

    Regards,

     

    Andrew

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 501 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 323 Moderator

#3
abm abm Profile Picture

abm abm 237 Most Valuable Professional

Last 30 days Overall leaderboard