Forum Discussion
Power Automate a flow based on Forms submittal
RobElliott is it possible to summarise responses to a form on a daily basis and send one email instead of one email per response?
Rahim_UoB yes but you would need to save each response into a SharePoint list, you can't do it just from the spreadsheet behind the form. Then your flow would get the items from the list with a filter query set to just bring back responses since the previous day. Instead of the normal apply to each you would need a Select action to get the responses, then a create html table action to build the table then a compose action with the CSS styles for the table. Finally you'd add a send email action and put into it the outputs of the previous compose action. We do this daily where a list of desk bookings goes to the relevant building receptionists. The original booking is made via a Power App instead of a Forms form but the follow-on actions are the same.
Rob
Los Gallardos
Microsoft Power Automate Community Super User