Others

How to Populate Microsoft Forms Choices from Outlook or Teams Data

Khadija Khan Oct 10, 2026 869 views

Question details

The user wants to automatically populate a dropdown question in Microsoft Forms using names or data directly from an Outlook or Teams organization directory.

How to Populate Microsoft Forms Choices from Outlook or Teams Data

Product: Microsoft Forms
Device & OS: not provided
Scenario: Creating an internal company form where respondents need to select an employee name or specific department from automatically maintained organization data.
Observed behavior: Microsoft Forms does not natively support pulling dynamic dropdown choices directly from Outlook, Teams, or Microsoft 365 organization directories.

Before you start

Ensure you have administrative access to export your Microsoft 365 directory data, as a direct real-time sync with Forms is not natively available.

Solution 1Recommended

Use Power Automate to Retrieve Directory Data Post-Submission

While you cannot dynamically populate the form's dropdown in real-time, you can use Power Automate to automatically fetch directory details based on the submitter's email.

Since Microsoft Forms lacks the ability to actively read Outlook or Teams data for dropdowns, the best automated workaround is to capture the respondent's email and let Power Automate fetch their associated directory data (like manager, department, or display name) in the background.

Create a Power Automate Flow

Go to Microsoft Power Automate, click 'Create', and select 'Automated cloud flow'. Choose the 'When a new response is submitted' trigger for Microsoft Forms.

Retrieve Respondent Details

Add a new step and search for the 'Get response details' action to pull the submitted form data.

Fetch Office 365 Users Data

Add another step using the 'Get user profile (V2)' action from the Office 365 Users connector. Map the 'User (UPN)' field to the 'Responders' Email' dynamic content from your form.

Utilize the Directory Data

Use the retrieved directory data for your subsequent actions, such as automatically emailing the respondent's manager or populating a SharePoint list with their exact organizational details.

Use Power Automate to Retrieve Directory Data Post-Submission

Dynamic Dropdown Limitation: Power Automate cannot push new options into a live Microsoft Forms dropdown question. It can only process and enrich the data after the form is submitted.

Solution 2

Manually Update the Choice List Using Copy and Paste

If your organization list changes infrequently, manually copying and pasting names from an Excel export is the most straightforward method.

Solution 3

Submit a Feature Request to Microsoft

Advocate for native synchronization by submitting feedback directly to the Microsoft Forms development team.

Free Microsoft Office alternative

Try WPS Office for Efficient Form Data Management

While Microsoft Forms has limitations with dynamic dropdowns, managing and analyzing your collected survey data shouldn't be a hassle. WPS Office provides a lightweight, highly compatible alternative to Microsoft Office, featuring powerful spreadsheet tools to organize, analyze, and format your exported form data effortlessly.

1. Download and Install: Visit the official WPS website to download and install the free WPS Office suite on your preferred device.
2. Open Form Exports: Export your Microsoft Forms responses to an Excel file and open it seamlessly in WPS Spreadsheet.
3. Analyze the Data: Use WPS Office's advanced pivot tables, filters, and chart tools to process your organizational data easily.

Free, lightweight, and easy to use across all your devicesFully compatible with Microsoft Excel (.xlsx) formats for analyzing exported form dataSeamlessly integrates documents, spreadsheets, and presentations in one appIncludes built-in PDF tools and intelligent data management features

microsoft office alternative - wps office

Frequently Asked Questions

Can I link an Excel spreadsheet to a Microsoft Forms dropdown?

No, Microsoft Forms does not currently support dynamically linking a live Excel spreadsheet or SharePoint list to a Choice question. Options cannot be fed from an external file automatically.

Is there any way to automatically capture a respondent's name without a dropdown?

Yes. If you share the form within your organization (requiring login), you can go to the form's settings and check 'Record name'. This automatically captures their directory name and email upon submission, eliminating the need for a dropdown list of names.

Will Power Automate change my form dropdown options?

No, Power Automate cannot actively modify or push new choices into a Microsoft Forms dropdown. It is primarily used to trigger workflows and enrich data after a user has already submitted the form.

Office Quick Solutions