Oct 05 2020
- last edited on
Feb 01 2023
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 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 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?)
May 02 2022 01:27 AM
I have been using Forms since it first appeared and it is a pain that there is no people picker field available.
I ended up going the same way as @Dominique Pollard, but my form has about 30 options for email contacts, which means that the form needs updating if department managers change. A user used a text input field in their form, but this leads to constant issues where other users of the form then mistypes an address, add a name instead of an address (even though the requirement for the address format is shown in the subheader), or even add several addresses.
Fortunately I capture all the Form input in a Power Automate flow and add it to an Excel spreadsheet, so that when there is an error at least the department for whom the form was created can later get back to the user and deal with any open issues, however any approval will fail and cause the Flow to fail, so there needs to be a workaround to deal with a failed flow.
Enabling the user to pick from a people picker field (allowing more than one address too) would greatly improve usability.