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-1752170%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-1752170%22%20slang%3D%22en-US%22%3E%3CP%3EThanks%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F116966%22%20target%3D%22_blank%22%3E%40Dominique%20Pollard%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20not%20sure%20if%20I%20got%20what%20you%20are%20trying%20to%20say.%3C%2FP%3E%3CP%3ELet%20me%20say%20the%20issue%20in%20another%20way.%3C%2FP%3E%3CP%3EIn%20Forms%2C%20if%20I%20select%20%22Choice%22%2C%20then%20I%20would%20have%20to%20provide%20a%20long%20list%20of%20people%20who%20might%20be%20the%20answer.%20While%2C%20if%20I%20select%20%22Text%22%2C%20then%20the%20respondent%20would%20have%20to%20type%20the%20name%20of%20the%20related%20people%20which%20would%20be%20definitely%20a%20smaller%20portion%20of%20the%20people%20group.%20But%2C%20then%20in%20Power%20Automate%2C%20where%20I%20need%20to%20set%20an%20automatic%20email%20to%20the%20mentioned%20people%2C%20I%20would%20have%20to%20come%20up%20with%20a%20solution%20to%20separate%20the%20names%20and%20then%20find%20their%20email%20addresses%20to%20send%20the%20email%20to%20them.%3C%2FP%3E%3CP%3ESo%2C%20if%20Forms%20had%20an%20option%20for%20%22Organisation%20Active%20Directory%22%20to%20simply%20pick%20the%20employees%20with%20their%20email%20addresses%20in%20one%20place%2C%20that%20would%20be%20great.%20Don't%20you%20think%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
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.

 

 

4 Replies
Highlighted

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 

Highlighted

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?

Highlighted
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 

Highlighted

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.