See who did not take the survey in Microsoft Form

%3CLINGO-SUB%20id%3D%22lingo-sub-1480378%22%20slang%3D%22en-US%22%3ESee%20who%20did%20not%20take%20the%20survey%20in%20Microsoft%20Form%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1480378%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20I%20created%20a%20survey%20form%20in%20my%20organization.%20But%20I%20want%20to%20see%20who%20are%20those%20members%20in%20the%20organization%20who%20haven't%20answer%20the%20survey%20I%20created.%2C%20so%20I%20can%20make%20an%20email%20reminder%20about%20it.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1480378%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMicrosoft%20Forms%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1480986%22%20slang%3D%22en-US%22%3ERe%3A%20See%20who%20did%20not%20take%20the%20survey%20in%20Microsoft%20Form%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1480986%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F706496%22%20target%3D%22_blank%22%3E%40Tebtim%3C%2FA%3E%26nbsp%3Bthere%20are%202%20answers%20to%20this%20depending%20on%20whether%20you%20have%20already%20sent%20out%20the%20form%20or%20not.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20you%20have%20sent%20it%20out%20then%20the%20only%20thing%20you%20can%20do%20is%20to%20do%20a%20manual%20comparison%20between%20the%20spreadsheet%20of%20responses%20against%20a%20list%20of%20the%20people%20you%20have%20sent%20the%20form%20to.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20you%20haven't%20yet%20sent%20out%20the%20form%20then%20you%20could%20do%20what%20we%20do%20in%20our%20company%20which%20is%20to%20create%20a%20list%20in%20SharePoint%20and%20in%20each%20row%20add%20the%20email%20address%20of%20each%20person%20you%20have%20sent%20the%20email%20to%20into%20the%20Title%20column.%20Then%20have%20a%20single%20line%20of%20text%20column%20called%20%3CEM%3EResponded%3C%2FEM%3E%20with%20a%20default%20of%20No.%20Next%20you'd%20need%20a%20flow%20in%20Power%20Automate%20to%20get%20the%20items%20in%20this%20SharePoint%20list%20and%20also%20get%20the%20details%20of%20each%20response%20as%20it%20comes%20in.%20Then%20you'd%20add%20a%20Condition%20to%20compare%20the%20responder's%20email%20address%20against%20the%20Title%20column%20in%20the%20list.%20If%20it%20isn't%20equal%20then%20do%20nothing%20and%20leave%20the%20red%20If%20No%20channel%20empty.%20If%20it%20%3CU%3Eis%3C%2FU%3E%20equal%20then%20in%20the%20green%20If%20Yes%20channel%20add%20an%20%3CEM%3EUpdate%20item%3C%2FEM%3E%20action%20and%20change%20the%20%3CEM%3EResponded%3C%2FEM%3E%20column%20to%20Yes.%20You%20could%20also%20have%20a%20column%20for%20each%20question%20in%20the%20form%20and%20add%20the%20answer%20in%20there%20as%20well%20which%20is%20what%20we%20do%20for%20audit%20or%20reporting%20reasons.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENext%20you%20would%20need%20a%20separate%20flow%2C%20probably%20a%20manually%20triggered%20flow%2C%20to%20get%20the%20items%20from%20your%20SharePoint%20list%20and%20have%20a%20condition%20that%20if%20the%20Responded%20column%20is%20equal%20to%20No%26nbsp%3B%20then%20send%20a%20reminder%20email.%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
Highlighted
Frequent Visitor

Hi I created a survey form in my organization. But I want to see who are those members in the organization who haven't answer the survey I created., so I can make an email reminder about it. 

1 Reply
Highlighted

@Tebtim there are 2 answers to this depending on whether you have already sent out the form or not.

 

If you have sent it out then the only thing you can do is to do a manual comparison between the spreadsheet of responses against a list of the people you have sent the form to.

 

If you haven't yet sent out the form then you could do what we do in our company which is to create a list in SharePoint and in each row add the email address of each person you have sent the email to into the Title column. Then have a single line of text column called Responded with a default of No. Next you'd need a flow in Power Automate to get the items in this SharePoint list and also get the details of each response as it comes in. Then you'd add a Condition to compare the responder's email address against the Title column in the list. If it isn't equal then do nothing and leave the red If No channel empty. If it is equal then in the green If Yes channel add an Update item action and change the Responded column to Yes. You could also have a column for each question in the form and add the answer in there as well which is what we do for audit or reporting reasons.

 

Next you would need a separate flow, probably a manually triggered flow, to get the items from your SharePoint list and have a condition that if the Responded column is equal to No  then send a reminder email.

 

Rob
Los Gallardos
Microsoft Power Automate Community Super User