How to Automatically Populate an Email Address from a Name in Microsoft Forms
Question details
The user wants to automatically fill in a respondent's email address field after selecting their name from a list or dropdown within the form.
- Product
- Microsoft Forms
- Device & OS
- not provided
- Scenario
- Creating a form where selecting an employee or contact name automatically retrieves and logs their corresponding email address without manual text entry.
- Observed behavior
- Microsoft Forms does not natively support looking up and populating a secondary question based on a previous selection during the live form entry process.
Verify whether your form respondents are internal members of your Microsoft 365 organization, as this significantly changes the available methods for capturing email addresses automatically.
Use Power Automate to Retrieve Emails Post-Submission
Since Microsoft Forms cannot perform live lookups before submission, use a Power Automate flow to match the submitted name to an email address in a backend database.
This method processes the data immediately after the user clicks submit. It requires a reference table (like an Excel file stored in SharePoint or OneDrive) that contains all names and their corresponding email addresses.
Create an Excel workbook in OneDrive or SharePoint. Insert a table with at least two columns: 'Name' and 'Email'. Ensure it is formatted as an official Excel Table.
Go to Power Automate and create an 'Automated cloud flow'. Set the trigger to 'When a new response is submitted' under Microsoft Forms.
Add a new step for 'Get response details'. Select your specific Form ID and map the Response ID dynamic content.
Add an 'Excel Online - List rows present in a table' action. Point it to your reference table. Add a Filter Query to match the 'Name' column with the name selected in the form response.
Add a final step (like sending an email or adding a row to another spreadsheet) using the dynamically retrieved email address from the previous Excel step.
Automatically Record Names and Emails for Internal Users
If your respondents are in the same Microsoft 365 organization, you can automatically capture their name and email without requiring them to fill out those fields.
Use Power Apps for Real-Time Lookups
If you strictly need an interactive form that populates fields live while the user is filling it out, Power Apps is the appropriate tool.
Collect and Process Data Effortlessly with WPS Office
If complex Power Automate workflows seem overwhelming for simple data processing, consider managing your workflows with WPS Office. With its powerful spreadsheet lookup functions and highly compatible suite, organizing respondent data is easier than ever.
- 1. Download and Install: Get WPS Office from the official website and install the lightweight suite on your PC or mobile device.
- 2. Import Your Data: Open your existing Excel databases or form response exports directly in WPS Spreadsheet with perfect formatting retention.
- 3. Use Advanced Lookups: Utilize WPS Spreadsheet's intuitive formulas to instantly match names to emails across different data tables.
Frequently Asked Questions
Can I use branching in MS Forms to auto-fill an email?
No, the branching feature in Microsoft Forms is only designed to direct users to different subsequent questions based on their answers. It cannot dynamically insert or populate text into another field.
Why doesn't the email field populate automatically in Microsoft Forms?
Microsoft Forms is built as a straightforward, lightweight surveying tool. It lacks native real-time database query capabilities (like VLOOKUP) during the form-filling process to keep the user experience fast and simple.
How do I automatically collect emails from external users?
You cannot automatically capture emails from users outside your organization without explicitly asking them to type it. You must add a standard 'Text' question asking for their email address and set it to 'Required'.
Is Power Automate free to use with Microsoft Forms?
Basic Power Automate features, including the standard Microsoft Forms and Excel Online connectors, are generally included at no extra cost with most Microsoft 365 business, education, or enterprise subscriptions.
