Oct 05 2020 06:07 PM
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.
Oct 05 2020 09:19 PM
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.
Oct 06 2020 08:53 PM - edited Oct 06 2020 08:54 PM
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?
Oct 07 2020 10:19 AM
SolutionI 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.
Oct 08 2020 01:47 PM - edited Oct 08 2020 01:48 PM
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.
Feb 11 2021 01:52 AM
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?)