Automated Flow to Send Email with Forms Dashboard

%3CLINGO-SUB%20id%3D%22lingo-sub-1771346%22%20slang%3D%22en-US%22%3EAutomated%20Flow%20to%20Send%20Email%20with%20Forms%20Dashboard%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1771346%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20used%20%22Forms%22%20to%20create%20a%20form%20which%20is%20filled%20out%20with%20multiple%20entries%20per%20day.%20I%20would%20like%20to%20automate%20a%20single%20email%20to%20be%20sent%20out%20at%20a%20specific%20time%20with%20just%20the%20Dashboard%20from%20the%20responses%20tab.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESpecifically%20the%20pie%2Fbar%20graphs%20from%20the%20responses%20section.%20I%20have%20seen%20in%20the%20Forums%20how%20to%20send%20an%20email%20of%20each%20response%20entered%2C%20but%20I%20would%20like%20the%20response%20dashboard%20only%20instead%20of%20each%20submission.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20this%20possible%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1771346%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EForms%20Flow%20Automate%20Dashboard%20Email%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1772189%22%20slang%3D%22en-US%22%3ERe%3A%20Automated%20Flow%20to%20Send%20Email%20with%20Forms%20Dashboard%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1772189%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F829032%22%20target%3D%22_blank%22%3E%40Dwnmb%3C%2FA%3E%26nbsp%3Bunfortunately%20it's%20not%20possible.%20You%20could%20use%20Power%20Automate%20to%20send%20the%20responses%20to%20a%20list%20in%20SharePoint%20and%20then%20do%20the%20dashboard%20email%20from%20there%2C%20or%20potentially%20send%20the%20responses%20to%20Power%20BI%20and%20do%20the%20dashboard%20from%20there.%20But%20from%20Forms%20itself%20there%20is%20currently%20no%20way%20to%20do%20what%20you%20want.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERob%3CBR%20%2F%3ELos%20Gallardos%3CBR%20%2F%3E%3CFONT%20size%3D%222%22%20color%3D%22%23006400%22%3EMicrosoft%20Power%20Automate%20Community%20Super%20User%3C%2FFONT%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

I have used "Forms" to create a form which is filled out with multiple entries per day. I would like to automate a single email to be sent out at a specific time with just the Dashboard from the responses tab.

 

Specifically the pie/bar graphs from the responses section. I have seen in the Forums how to send an email of each response entered, but I would like the response dashboard only instead of each submission.

 

Is this possible?

2 Replies

@Dwnmb unfortunately it's not possible. You could use Power Automate to send the responses to a list in SharePoint and then do the dashboard email from there, or potentially send the responses to Power BI and do the dashboard from there. But from Forms itself there is currently no way to do what you want.

 

Rob
Los Gallardos
Microsoft Power Automate Community Super User

Hi @Dwnmb 

 

If you want the summary of the responses that include the pie charts, you could try and generate the summary link and put it into an email in Power Automate.

 

In your Form, go to the Responses tab and click ... and Create a summary link.

 

capture20201013171058160.png

 

Drop the link into a Send an email (V2) action (or other action as needed).

 

When the recipient views the link in the email, they will see the latest results by clicking onto the summary link.

 

capture20201013171439362.png

 

I happened to use a Quiz as the example but it's the exact same steps for a Form as well.

 

Hope that is what you were after?

 

Cheers & best wishes

Damien