Data Import & Export

Populate Microsoft Forms Questions from Excel Data using Power Automate

Maira Mehtab Sep 20, 2026 868 views

Question details

The user wants to dynamically populate drop-down choices and apply branching logic in a Microsoft Form based on device serial numbers and staff members stored in an Excel spreadsheet.

Product: Microsoft Forms, Excel, Power Automate
Device & OS: not provided
Scenario: Creating a dynamic form that updates its branching and dropdown options automatically based on structured data within an Excel workbook.
Observed behavior: The user needs a way to integrate an Excel dataset containing staff members and serial numbers directly into Microsoft Forms to avoid manual entry.

Before you start

Ensure your Excel data is formatted as a Table (Insert > Table) and saved to a cloud location like OneDrive or SharePoint, as Power Automate cannot read standard ranges from locally stored files.

Solution 1Recommended

Use Microsoft Power Automate to Link Excel and Forms

Create an automated workflow in Power Automate to retrieve data from your Excel table and populate your Microsoft Form choices dynamically.

Since Microsoft Forms does not natively pull choices from Excel, you must use Power Automate to bridge the gap. Dynamically populating choices and setting up branching based on user selection involves creating a custom flow.

Format and upload your Excel data

Open your Excel spreadsheet, highlight your data, and click 'Insert' > 'Table'. Save this file to your OneDrive for Business or a SharePoint document library.

Create a new Power Automate flow

Log into Microsoft Power Automate, click 'Create' on the left menu, and select 'Automated cloud flow' or 'Instant cloud flow' depending on your trigger preference.

Fetch Excel data

Add a new step and search for the 'Excel Online (Business)' connector. Select the 'List rows present in a table' action. Choose your location, document library, file, and the specific table you created.

Apply logic and map to Forms

Use operations like 'Apply to each' or 'Filter arrays' to identify the selected staff member and retrieve their specific serial numbers. Since writing back to Form choices dynamically requires advanced JSON manipulation and API calls, it is highly recommended to seek template scripts from the Microsoft Power Automate Community.

Advanced Configuration Required: Dynamically altering Form choices and branching via Power Automate is an advanced developer task. If you are unfamiliar with APIs, posting your specific table structure in the Power Automate Community forums will help you get the exact workflow script needed.

Solution 2

Manually Configure Form Branching (Alternative)

If setting up a Power Automate workflow is too complex, you can manually build the branching logic directly inside Microsoft Forms.

Free Microsoft Office alternative

Manage Your Spreadsheet Data Efficiently with WPS Office

While advanced workflow integrations like Power Automate require the Microsoft ecosystem, WPS Office provides a lightweight, highly compatible, and free alternative for all your spreadsheet preparation and formatting needs. You can easily organize, clean, and format your Excel tables in WPS Spreadsheet before using them in complex cloud workflows.

Fully compatible with Microsoft Excel formats (.xlsx, .xls, .csv).Lightweight and fast, allowing you to clean and organize datasets before importing them to forms.Familiar user interface with zero learning curve for users switching from Excel.Free to use with comprehensive data analysis tools and built-in templates.

microsoft office alternative - wps office

Frequently Asked Questions

Can I link a local Excel file directly to Microsoft Forms?

No. To use Power Automate for dynamic data retrieval, your Excel file must be saved in a cloud storage service like OneDrive for Business or SharePoint.

Does Microsoft Forms natively support dynamic drop-downs from Excel without Power Automate?

Currently, Microsoft Forms does not have a built-in feature to automatically populate drop-down choices directly from a spreadsheet. You must use Power Automate to connect the two tools.

Why isn't my Excel data showing up in Power Automate?

Ensure that the data in your Excel file is formatted strictly as a Table. Power Automate's 'List rows present in a table' action requires a defined table (created via Insert > Table), not just a standard worksheet with data.

Excel & Data Problems