How to set up a recurring survey with Forms?

%3CLINGO-SUB%20id%3D%22lingo-sub-282837%22%20slang%3D%22en-US%22%3EHow%20to%20set%20up%20a%20recurring%20survey%20with%20Forms%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-282837%22%20slang%3D%22en-US%22%3E%3CP%3EWe'd%20like%20to%20set%20up%20a%20survey%20that%20before%20each%20morning%20meeting%20checked%20the%20mood%20of%20everyone%20in%20the%20meeting.%20Ideally%20this%20would%20be%20an%20automated%20survey%20that%20is%20triggered%20every%20morning%20and%20the%20graphical%20result%20posted%20either%20on%20the%20team%20SharePoint%20or%20in%20the%20Teams%20channel.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHowever%2C%20after%20much%20searching%20and%20fiddling%20with%20Forms%20and%20Flow%20(and%20other%20obscure%20ideas)%20I%20have%20not%20succeeded%20in%20making%20a%20Form%20reset%20every%20morning%20and%20to%20automatically%20display%20the%20result.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20%22closest%22%20I%20have%20managed%20is%20to%20use%20the%20Forms%20bot%20in%20the%20Teams%20channel%20to%20manually%20create%20the%20poll%20every%20time.%20But%20the%20downside%20is%20that%20it's%20manual%20and%20it%20disappears%20from%20the%20view%20when%20people%20chat%20in%20the%20channel.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDoes%20anyone%20have%20any%20thoughts%20on%20how%20this%20could%20be%20possible%3F%20If%20possible%20at%20all%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-282837%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EForms%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EPoll%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESurvey%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-282896%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20set%20up%20a%20recurring%20survey%20with%20Forms%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-282896%22%20slang%3D%22en-US%22%3EI%20personally%20would%20create%20a%20powerapp%20for%20this.%20But%20it%E2%80%99s%20not%20quiet%20as%20easy%20to%20do%20as%20a%20form%20but%20you%20really%20can%E2%80%99t%20do%20this%20with%20forms%20since%20the%20apis%20and%20what%20not%20aren%E2%80%99t%20there%20yet%20to%20really%20automate%20that%20part%20of%20forms%20yet.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1509291%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20set%20up%20a%20recurring%20survey%20with%20Forms%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1509291%22%20slang%3D%22en-US%22%3E%3CP%3EIs%20this%20functionality%20available%20yet%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

We'd like to set up a survey that before each morning meeting checked the mood of everyone in the meeting. Ideally this would be an automated survey that is triggered every morning and the graphical result posted either on the team SharePoint or in the Teams channel.

 

However, after much searching and fiddling with Forms and Flow (and other obscure ideas) I have not succeeded in making a Form reset every morning and to automatically display the result.

 

The "closest" I have managed is to use the Forms bot in the Teams channel to manually create the poll every time. But the downside is that it's manual and it disappears from the view when people chat in the channel.

 

Does anyone have any thoughts on how this could be possible? If possible at all?

4 Replies
I personally would create a powerapp for this. But it’s not quiet as easy to do as a form but you really can’t do this with forms since the apis and what not aren’t there yet to really automate that part of forms yet.

Is this functionality available yet?

@Jimmy Sjölund is there a workaround for this yet? My team wants to send a weekly form asking "How Was Your Week" and the president receives the emails. Is there a way to automate this and make it recurring?

@jsundstrom yes it's do-able if you use a flow in Power Automate with the trigger as a recurrence schedule set to 1 week and the action is to send an email to your users with a link to the form. A separate flow would grab the responses and send them via an email to your president.

 

Rob
Los Gallardos
Microsoft Power Automate Community Super User