Others

How to Use an Excel Employee List for SharePoint or Microsoft Forms

Khadija KhanKhadija Khan Nov 4, 2026 869 views

Question details

A company needs supervisors to select employee names from a local Excel workbook in an incentive submission form, especially when many employees lack Microsoft 365 accounts.

How to Use an Excel Employee List for SharePoint or Microsoft Forms
Product
Microsoft Forms, SharePoint, Power Apps
Device & OS
not provided
Scenario
Creating an incentive submission form where supervisors can pick names from a pre-existing employee list instead of manually typing them out.
Observed behavior
The user wants to connect a local Excel workbook to a form to utilize a searchable choice or lookup field, but faces limitations with standard Microsoft Forms and Microsoft 365 account requirements.
Before you start

Ensure that the supervisors who will be filling out the form have the necessary Microsoft 365 licenses to access Power Apps and SharePoint, even if the employees listed in the workbook do not.

Solution 1Recommended

Create a Form with Power Apps Connected to a SharePoint List

The most robust way to use an Excel list for form selection is by importing your data into a SharePoint list and building a customized Power App.

Microsoft Forms natively lacks the ability to pull dynamic dropdown data directly from a local Excel file. By leveraging Power Apps, you can create a customized application that uses a SharePoint list as its data source. This allows you to add searchable combo boxes for supervisors to easily select employee names.

1
Import Excel to SharePoint

Open your SharePoint site, click 'New', select 'List', and choose 'From Excel'. Upload your local Excel employee list and map the columns to create a new custom list.

2
Create the Power App

Navigate to the Power Apps portal, click on 'Create', and select 'SharePoint'. Connect the app to your newly created SharePoint site and select the employee list.

3
Add a Searchable Dropdown

In your Power App form screen, insert a 'Combo box' control. Set its 'Items' property to the SharePoint list and configure it to display the employee name column.

4
Enable Searching

Select the Combo box, go to the properties pane, and ensure that 'IsSearchable' is toggled to true so supervisors can easily search through hundreds of names.

5
Publish and Share

Save and publish your Power App. Share the application with your supervisors, ensuring they have the necessary permissions to read the SharePoint list and submit form entries.

Create a Form with Power Apps Connected to a SharePoint List
Licensing Notice: While the employees listed in the dataset do not need Microsoft 365 or Azure accounts, any supervisor submitting the incentive form via Power Apps will require an appropriate M365 license.
Free Microsoft Office alternative

Manage Your Excel Employee Lists Easily with WPS Office

While building dynamic cloud forms requires Microsoft 365 ecosystems like Power Apps and SharePoint, managing the underlying local Excel employee data can be done efficiently with WPS Office. WPS Office is a free, lightweight suite that serves as an excellent alternative to Microsoft Excel.

  1. 1. Download the Software: Visit the official WPS Office website and click 'Free Download' to get the installer for your operating system.
  2. 2. Install WPS Office: Run the installation file and follow the quick setup wizard to install the suite on your computer.
  3. 3. Open Your Spreadsheets: Launch WPS Spreadsheets and open your local employee list workbook to seamlessly edit and format your data.
Fully compatible with Microsoft Excel (.xlsx, .xls, .csv) formatsLightweight and fast, making it ideal for managing large employee data lists locallyFamiliar user interface requires no learning curve, enabling a seamless migrationCompletely free to use for daily spreadsheet editing and sorting
microsoft office alternative - wps office

Frequently Asked Questions

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

No, standard Microsoft Forms does not support dynamic dropdowns linked directly to a local Excel workbook. You must use Power Apps to create a custom form that pulls data from a connected source, such as SharePoint or Excel Online.

Do supervisors need Microsoft 365 accounts to use the Power App form?

Yes. Any user, including supervisors, who accesses and submits data through a Power App needs an appropriate Microsoft 365 license and permissions to view the underlying data source (like the SharePoint list).

How do I make the employee list searchable in a Power Apps form?

In Power Apps, use a 'Combo box' control linked to your employee list data source. In the control's properties panel on the right side, toggle the 'IsSearchable' option to true, and specify which data fields should be searched.