cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Frequent Visitor

Generate list of users who have not submitted a form and email it to a manager

Hello Experts,

 

Is there a way to populate a list/file/database in sharepoint automatically with the answers that were submitted in a MS Form? Additionally, is there way to send an email to all users (automatically) who have not submitted the form once the form expires? (or at a specific day and time)  AND at the same time another email to a manager with the list of users who have not submitted the form? Thanks! I am hoping power automate can do this

1 ACCEPTED SOLUTION

Accepted Solutions
Super User II
Super User II

@ITlearner20 

Hi there.  Yes and Yes.  Loads of videos/blogs out there on getting information from a Forms response into various places.

 

For the second bit, you'll probably want to maintain a list somewhere (SharePoint?) of who all you sent the Forms link to, and also have a "response" column/flag, to change once they respond.  Then, you can have a separate flow to look for expired forms and check the respective list for folks who have not responded and send the email.

 

Good luck and keep us posted.

-Ed

 

 

If you liked this reply, please give it a thumbs up! If this reply has answered your question or resolved your challenge, please consider marking it as a Solution. This helps other users find it more easily via search.

View solution in original post

2 REPLIES 2
Super User II
Super User II

@ITlearner20 

Hi there.  Yes and Yes.  Loads of videos/blogs out there on getting information from a Forms response into various places.

 

For the second bit, you'll probably want to maintain a list somewhere (SharePoint?) of who all you sent the Forms link to, and also have a "response" column/flag, to change once they respond.  Then, you can have a separate flow to look for expired forms and check the respective list for folks who have not responded and send the email.

 

Good luck and keep us posted.

-Ed

 

 

If you liked this reply, please give it a thumbs up! If this reply has answered your question or resolved your challenge, please consider marking it as a Solution. This helps other users find it more easily via search.

View solution in original post

Regular Visitor

Creating a record of a form responses is the easy part of this, Forms automatically tabulate the data and at any time the results can either be manually or automatically saved to an excel file or sharepoint list.
The second part would make use of a fairly new connector Office 365 Groups. This connector will allow you to manage an Office 365 Group and pull data from it. When the form is created the group can be used to manage access to the form and to track the ones who have not filled it out.
Setting this up you would create the form and the Office 365 Group with the list of users that need to complete it. You would create 2 flows for this. One would be triggered each time a form is submitted. The main action it would take is to remove the submitter from the Office 365 Group. The second flow would be triggered on a schedule. It could be set to go off just once or be recurring until the form expires. Each time it is triggered it would send emails to each person still a member of the Office 365 Group and an email to the manager with a current list of the members of the Group. A report of the results of the form can be generated each time the flow is triggered or only the last time.
In addition a test to see if there are any member left in the group and if there are none the report would be generated and the flow would be disabled.

Helpful resources

Announcements
PP Bootcamp Carousel

Global Power Platform Bootcamp

Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.

secondImage

Power Platform Community Conference On Demand

Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!

MPA Community Blog

Power Automate Community Blog

Check out the community blog page where you can find valuable learning material from community and product team members!

Top Solution Authors
Users online (9,459)