How to Connect Microsoft Forms to Outlook Global Address List Contacts
Question details
The user wants to add Outlook Global Address List (GAL) type-ahead suggestions to a form to easily search for organizational contacts.
- Product
- Microsoft Forms
- Device & OS
- not provided
- Scenario
- Creating an internal organizational form where respondents need to search and select contacts dynamically from the company directory.
- Observed behavior
- Microsoft Forms does not natively support Outlook GAL type-ahead suggestions, requiring a customized solution.
Ensure you have access to Microsoft Power Apps and Power Automate through your enterprise subscription, as you will need these tools to create this customized integration.
Build the Form in Power Apps
Since Microsoft Forms cannot query the GAL, you must build the form as a Canvas app in Power Apps to enable type-ahead contact searching.
Microsoft Forms is designed for simple surveys and lacks the capability to query the Outlook Global Address List dynamically. Power Apps, however, can easily connect to Office 365 Users to provide real-time type-ahead suggestions.
Open Microsoft Power Apps in your browser, select 'Create', and choose to build a blank Canvas app.
Navigate to the 'Data' tab on the left sidebar, click 'Add data', and search for 'Office 365 Users'. Connect it to your app.
Go to the 'Insert' menu and add a 'Combo box' control to your app screen. This will serve as your type-ahead search field.
Select the Combo box, navigate to its 'Items' property in the formula bar, and enter: Office365Users.SearchUser({searchTerm: Self.SearchText}).
Add a submit button to your app and trigger a Power Automate flow on selection to capture the chosen contact and process the form data.
Boost Your Productivity with WPS Office
While complex enterprise data integrations like GAL require specialized Microsoft Power Platform tools, WPS Office provides a free, lightweight, and highly compatible alternative for your everyday document, spreadsheet, and presentation needs. Experience familiar interfaces and seamless file transitions without the heavy subscription costs.
- 1. Download the installer: Visit the official WPS Office website and download the free installer for your operating system.
- 2. Install the software: Run the setup file and follow the quick on-screen instructions to install the office suite.
- 3. Open your files: Launch WPS Office and open your existing Microsoft Office files with zero formatting loss.
Frequently Asked Questions
Can I embed a Power App into a Microsoft Form?
No, Microsoft Forms and Power Apps are entirely separate platforms. You cannot directly implement Power Apps search functionalities or data controls inside a standard Microsoft Form.
Why doesn't Microsoft Forms support Outlook GAL type-ahead?
Microsoft Forms is designed as a lightweight, simple tool for quick surveys and quizzes. It intentionally omits complex database queries or dynamic directory integrations to maintain simplicity and fast load times.
Do I need an extra license to use Power Apps for this form?
It depends on your current Microsoft 365 plan. Many Enterprise and Business plans include standard Power Apps usage, which is usually sufficient to connect to the standard Office 365 Users directory (GAL).
Can I use Power Automate to link MS Forms and the GAL after submission?
Yes, you can use Power Automate to look up a user in the GAL based on an email address submitted in a Microsoft Form, but this will not provide a real-time type-ahead search experience while the user is filling out the form.
