Send one weekly email with data from multiple form submissions.

(0) Share

Report

Posted on by StreetMA

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.

Favorite Color: Blue

Favorite Sport: Hockey

Favorite Day: Tuesday

Favorite Food: Pizza

Favorite Animal: Cat

…

Favorite Color: Red

Favorite Sport: Football

Favorite Day: Friday

Favorite Food: Pasta

Favorite Animal: Giraffe

etc.

Thanks in advance!

All responses (1)

Answers (0)

Andrew_J 1,962 Super User 2025 Season 1 on at

Like (1)

Report

Re: Send one weekly email with data from multiple form submissions.

@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