cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Advocate I
Advocate I

Create a list of office 365 users that has not completed a Microsoft Form

Hi everyone,

 

I need help with a new flow I'm building, may you please give me ideas on how you would achieve the following task:

Every month there is an online Microsoft Form Quiz sent out to all employees, I need a list of all employees that didn't complete the Microsoft Form Quiz

 

All the employees have a Microsoft Office 365 account, I can get data on who has completed the form, but I need to know who has not done it

 

Any idea is much appreciated,

Thank you very much,

Kind Regards,

GK

2 ACCEPTED SOLUTIONS

Accepted Solutions
Highlighted
Dual Super User III
Dual Super User III

Re: Create a list of office 365 users that has not completed a Microsoft Form

Hi @GK_BPL 

 

Can you share more details on this? How are you sending the forms to the employees? Is there a list or something that is being used to send these forms on the emails? 

 

You can get that list and store it as a list on SharePoint/ As a table in excel on sharepoint/ Onedrive etc. 

 

Now, you can create another table in the Excel or another List in SharePoint and then keep updating these as people start responding  (when a resposne is submitted to MS Forms Trigger) and then you can have a separate flow that gets you the comparision between the 2 tables/ Lists and you can send reminders to people who have not filled the forms.  

 

There are a couple ways you can do this using flows and SharePoint/ Excel etc. 

 

Hope this Helps!

 

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

View solution in original post

Highlighted
Community Support
Community Support

Re: Create a list of office 365 users that has not completed a Microsoft Form

 

Hi @GK_BPL ,

 

Please try the following methods to achieve your needs. It is recommended to add an EmailAddress field in the Form and require user populating.

116.PNG

  • Then you could click on the location of the icon after the due date to download all the responses.

117.PNG

 

  • Store this file in OneDrive, then configure List rows present in a table action to configure the specified file and table.
  • Filter out the user information not included in the table and send it to you by email.

Image reference:

113.PNG114.PNG115.PNG

Hope it helps.

 

Best Regards,

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

4 REPLIES 4
Highlighted
Dual Super User III
Dual Super User III

Re: Create a list of office 365 users that has not completed a Microsoft Form

Hi @GK_BPL 

 

Can you share more details on this? How are you sending the forms to the employees? Is there a list or something that is being used to send these forms on the emails? 

 

You can get that list and store it as a list on SharePoint/ As a table in excel on sharepoint/ Onedrive etc. 

 

Now, you can create another table in the Excel or another List in SharePoint and then keep updating these as people start responding  (when a resposne is submitted to MS Forms Trigger) and then you can have a separate flow that gets you the comparision between the 2 tables/ Lists and you can send reminders to people who have not filled the forms.  

 

There are a couple ways you can do this using flows and SharePoint/ Excel etc. 

 

Hope this Helps!

 

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

View solution in original post

Highlighted
Community Support
Community Support

Re: Create a list of office 365 users that has not completed a Microsoft Form

 

Hi @GK_BPL ,

 

Please try the following methods to achieve your needs. It is recommended to add an EmailAddress field in the Form and require user populating.

116.PNG

  • Then you could click on the location of the icon after the due date to download all the responses.

117.PNG

 

  • Store this file in OneDrive, then configure List rows present in a table action to configure the specified file and table.
  • Filter out the user information not included in the table and send it to you by email.

Image reference:

113.PNG114.PNG115.PNG

Hope it helps.

 

Best Regards,

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Highlighted
Advocate I
Advocate I

Re: Create a list of office 365 users that has not completed a Microsoft Form

Hi @v-bacao-msft ,

 

 

Thank you very much for the step by step guide, I tweaked it a bit but it was really usefull and I wanted you to know it is much appreciated

 

 

Kind Regards,

GK

BPL

Highlighted
New Member

Re: Create a list of office 365 users that has not completed a Microsoft Form

Hi,

 

Thanks for the example @v-bacao-msft. However, I don't understand the point of the 2nd array variable you created called 'Table' - it looks like it never gets used? When I try to recreate your example, I also don't have the option to choose the Name from the array 'body' where you create the HTML table. Am I missing something?

Helpful resources

Announcements
firstImage

Super User Program Update

Three Super User rank tiers have been launched!

firstImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

Top Solution Authors
Top Kudoed Authors
Users online (10,126)