SOLVED

How to collect users emails without asking them to enter it

%3CLINGO-SUB%20id%3D%22lingo-sub-1567291%22%20slang%3D%22en-US%22%3EHow%20to%20collect%20users%20emails%20without%20asking%20them%20to%20enter%20it%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1567291%22%20slang%3D%22en-US%22%3E%3CP%3EWe%20are%20looking%20to%20develop%20a%20way%20to%20track%20users%20that%20are%20taking%20a%20specific%20training%20courses%20and%20we%20were%20thinking%20to%20use%20a%20feedback%20form.%20Can%20MS%20Forms%20capture%20the%20users%20email%20or%20should%20i%20use%20PowerApps%20or%20something%20else%3F%3C%2FP%3E%3CP%3EApologies%20if%20my%20question%20sounds%20stupid%2C%20novice%20O365%20user%20here%3C%2FP%3E%3CP%3Emany%20thanks%20%3A)%3C%2Fimg%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1567291%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMicrosoft%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1571427%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20collect%20users%20emails%20without%20asking%20them%20to%20enter%20it%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1571427%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F750159%22%20target%3D%22_blank%22%3E%40Katerina_sie%3C%2FA%3E%2C%26nbsp%3BMS%20Forms%20can%20do%20this%20if%20the%20setting%20for%20'%3CSPAN%3EWho%20can%20fill%20out%20this%20form'%20is%20set%20to%20'Only%20people%20in%20my%20organization%20can%20respond'.%20If%20you%20click%20the%20'Open%20in%20Excel'%20link%20in%20the%20Responses%20section%2C%20email%20is%20one%20of%20the%20categories%20it%20records.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%222020-08-06.png%22%20style%3D%22width%3A%20404px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F210721i8E272C62446A75F2%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%222020-08-06.png%22%20alt%3D%22Forms%20settings%22%20%2F%3E%3CSPAN%20class%3D%22lia-inline-image-caption%22%20onclick%3D%22event.preventDefault()%3B%22%3EForms%20settings%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EYou%20could%20also%20access%20this%20by%20using%20Power%20Automate%20on%20the%20Form%20data%20(if%20you%20wanted%20to%20automate%20the%20storage%20of%20responses%20or%20something%20like%2C%20for%20instance).%20There%20is%20a%20field%20called%20Responders'%20Email%20that%20will%20return%20just%20that.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EPower%20Apps%20is%20certainly%20another%20great%20method.%20There%20is%20a%20User%20function%20that%20can%20access%20the%20email%20from%20the%20current%20user's%20Office%20account.%20Here%20is%20how%20that%20function%20looks%3A%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-csharp%22%3E%3CCODE%3EUser().Email%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3BYou%20could%20then%20use%20that%20email%20as%20needed%20with%20any%20data%20in%20the%20app.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20hope%20that%20helps!%3C%2FP%3E%3C%2FLINGO-BODY%3E
Regular Visitor

We are looking to develop a way to track users that are taking a specific training courses and we were thinking to use a feedback form. Can MS Forms capture the users email or should i use PowerApps or something else?

Apologies if my question sounds stupid, novice O365 user here

many thanks :)

1 Reply
best response confirmed by Katerina_sie (Regular Visitor)
Solution

Hi @Katerina_sie, MS Forms can do this if the setting for 'Who can fill out this form' is set to 'Only people in my organization can respond'. If you click the 'Open in Excel' link in the Responses section, email is one of the categories it records.

Forms settingsForms settings

 

You could also access this by using Power Automate on the Form data (if you wanted to automate the storage of responses or something like, for instance). There is a field called Responders' Email that will return just that.

 

Power Apps is certainly another great method. There is a User function that can access the email from the current user's Office account. Here is how that function looks:

 

User().Email

 

 You could then use that email as needed with any data in the app.

 

I hope that helps!