Others

How to Add Outlook Address Book Autocomplete to Microsoft Forms

Khadija KhanKhadija Khan Nov 3, 2026 869 views

Question details

The user wants to connect a Microsoft Forms field to the Outlook address book to provide automatic email address suggestions for respondents.

Adding Outlook Address Book Autocomplete to Microsoft Forms
Product
Microsoft Forms
Device & OS
not provided
Scenario
Creating a form or survey where respondents need to input email addresses, ideally leveraging the organization's existing directory for auto-completion.
Observed behavior
Microsoft Forms currently lacks a built-in feature to link text fields to the Outlook address book or Global Address List (GAL) for directory lookup and autocomplete.
Before you start

Keep in mind that Microsoft Forms is designed for simple, lightweight data collection and currently does not support advanced live data lookups from Exchange or Outlook directories.

Solution 1Recommended

Build a Custom Form with Microsoft Power Apps

If directory lookup and autocomplete functionality are strict requirements for your form, you should transition from Microsoft Forms to Microsoft Power Apps.

Microsoft Power Apps is a more robust solution within the Microsoft 365 ecosystem. It allows you to build custom canvas apps that can connect directly to the Office 365 Users directory, enabling intelligent auto-complete functionality for email addresses inside your organization.

1
Launch Power Apps

Log into your Microsoft 365 portal, open the app launcher (waffle icon), and select Power Apps.

2
Create a New Canvas App

Click 'Create' from the left menu and choose to build a Blank Canvas App. Give your app a name and select a layout.

3
Add the Data Source

Navigate to the Data tab on the left panel, select 'Add data', and search for 'Office 365 Users'. Click it to connect the directory to your app.

4
Insert a Combo Box Control

Go to the 'Insert' tab and add a 'Combo box' to your screen. In the properties panel on the right, set its 'Items' property to search the Office 365 Users directory. This will enable the autocomplete feature when users start typing a name or email.

Build a Custom Form with Microsoft Power Apps
Licensing Requirement: Using Power Apps requires the appropriate Microsoft 365 or Power Apps licensing for both the creator and the users who will be filling out the custom form.
Free Microsoft Office alternative

Switch to WPS Office for Efficient Form Data Processing

While Microsoft Forms is great for basic surveys, managing the exported email addresses and response data often requires a powerful spreadsheet tool. WPS Office provides a lightweight, comprehensive, and highly compatible alternative to Microsoft Office. With WPS Spreadsheet, you can easily process, filter, and apply data validation to the email addresses collected from your forms without heavy subscription fees.

  1. 1. Download WPS Office: Visit the official WPS website and download the free installation package for your operating system.
  2. 2. Install the Suite: Run the downloaded installer and follow the simple on-screen prompts to set up the software.
  3. 3. Manage Form Responses: Export your Microsoft Forms data as an Excel file and open it instantly in WPS Spreadsheet to begin organizing your collected emails.
Fully compatible with Microsoft Excel (.xlsx) formats, making it easy to open and manage exported form responses.Built-in data validation and duplicate removal tools to easily clean up collected email addresses.Free, lightweight, and consumes minimal system resources.Familiar tabbed user interface for a seamless migration from Microsoft Office.
microsoft office alternative - wps office

Frequently Asked Questions

Can I automatically collect respondent email addresses without asking them in Microsoft Forms?

Yes, if the respondents are within your organization. In the Form settings, choose 'Only people in my organization can respond' and check the 'Record name' box. This will automatically capture their name and associated email address upon submission without needing an autocomplete field.

Does Microsoft Forms support custom scripts to add an autocomplete feature?

No, Microsoft Forms is a closed platform that does not support adding custom JavaScript, HTML, or external APIs to modify form behavior. You cannot code a custom autocomplete field into it.

Where can I request Microsoft to add the Outlook autocomplete feature to Forms?

You can submit feature requests directly to Microsoft through the Microsoft Forms feedback forum. Access it by clicking the 'Help' or 'Feedback' icon usually located in the bottom right corner or the top menu of the Forms interface.