SOLVED

How to pick email addresses in MS Forms

%3CLINGO-SUB%20id%3D%22lingo-sub-1747744%22%20slang%3D%22en-US%22%3EHow%20to%20pick%20email%20addresses%20in%20MS%20Forms%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1747744%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20all%3C%2FP%3E%3CP%3EI%20am%20creating%20a%20form%20in%20which%20I%20am%20to%20ask%20the%20respondents%20name%20a%20group%20of%20people%20in%20our%20business.%3C%2FP%3E%3CP%3EIs%20there%20anyway%20that%20I%20can%20embed%20a%20list%20of%20our%20employee's%20email%20address%20for%20them%20to%20pick%20from%3F%3C%2FP%3E%3CP%3ECurrently%2C%20what%20I%20see%20now%2C%20is%20using%20a%20text%20field%20and%20asking%20them%20to%20type!%3C%2FP%3E%3CP%3EHaving%20email%20addresses%20would%20be%20helpful%20once%20you%20are%20to%20send%20automated%20email%20to%20those%20team%20once%20the%20from%20was%20submitted.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1747744%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMS%20Forms%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EPower%20Automate%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1747910%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20pick%20email%20addresses%20in%20MS%20Forms%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1747910%22%20slang%3D%22en-US%22%3E%3CP%3EYou%20can%20through%20forms%20and%20power%20automate.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBy%20selecting%20Choice%20as%20an%20option%2C%20Power%20automate%20allows%20you%20to%20select%20the%20form%20as%20a%20flow%20entry%20and%20pull%20information%20from%20the%20form%20into%20another%20operation.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F821193%22%20target%3D%22_blank%22%3E%40ShN2020%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1755073%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20pick%20email%20addresses%20in%20MS%20Forms%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1755073%22%20slang%3D%22en-US%22%3E%3CP%3EI%20wanted%20to%20add%20this%20graphic%20to%20the%20first%20message%20hopefully%20it%20will%20work%20this%20time.%20Selecting%20choices%20you%20can%20provide%20the%20common%20email%20addresses%20and%20allow%20users%20to%20add%20a%20custom%20email%20in%20the%20text%20choice%20of%20other.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22forms.PNG%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F224880i0DEA814EBA4CE1E1%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22forms.PNG%22%20alt%3D%22forms.PNG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F821193%22%20target%3D%22_blank%22%3E%40ShN2020%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hi all

I am creating a form in which I am to ask the respondents name a group of people in our business.

Is there anyway that I can embed a list of our employee's email address for them to pick from?

Currently, what I see now, is using a text field and asking them to type!

Having email addresses would be helpful once you are to send automated email to those team once the from was submitted.

 

 

5 Replies

You can through forms and power automate.

 

By selecting Choice as an option, Power automate allows you to select the form as a flow entry and pull information from the form into another operation.

 

 

@ShN2020 

Thanks @Dominique Pollard 

I am not sure if I got what you are trying to say.

Let me say the issue in another way.

In Forms, if I select "Choice", then I would have to provide a long list of people who might be the answer. While, if I select "Text", then the respondent would have to type the name of the related people which would be definitely a smaller portion of the people group. But, then in Power Automate, where I need to set an automatic email to the mentioned people, I would have to come up with a solution to separate the names and then find their email addresses to send the email to them.

So, if Forms had an option for "Organisation Active Directory" to simply pick the employees with their email addresses in one place, that would be great. Don't you think?

best response confirmed by ShN2020 (New Contributor)
Solution

I wanted to add this graphic to the first message hopefully it will work this time. Selecting choices you can provide the common email addresses and allow users to add a custom email in the text choice of other.

forms.PNG

@ShN2020 

Thanks @Dominique Pollard 

So, I got it right. That's clever but if I don't know exactly who should be in the list to pick from, in the "Other" options, again I would have forced the respondent to type the email addresses which means more possibility of typo mistakes as well as more efforts to exclude the email addresses from the records while trying to automate the flow per each form submission.

The best solution would be having a field in Forms connected to the business active directory which pick quickly the email of people by typing a couple of their names alphabets. 

I totally agree.

My purpose would be slightly different, to have fill in a form that triggers a flow, using the (VALID!) internal email addresses to send out a notification.

I appreciate community members offering suggestions, but it is frustrating when they do not acknowledge they are answering a different question.  IMO It would be more beneficial to have a categorical answer that something cannot be done, so 'you and I' can stop looking for the impossible.

(I am assuming that you never found a method to add email addresses to a Form, or any other similar MS application?)