How to Use an Excel Employee List for SharePoint or Microsoft Forms
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.

- 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.
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.
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.
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.
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.
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.
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.
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.

Connect a Local Excel Workbook using an On-Premises Data Gateway
If the Excel file must remain local and cannot be permanently migrated to SharePoint, you can use an On-Premises Data Gateway to synchronize the data.
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. Download the Software: Visit the official WPS Office website and click 'Free Download' to get the installer for your operating system.
- 2. Install WPS Office: Run the installation file and follow the quick setup wizard to install the suite on your computer.
- 3. Open Your Spreadsheets: Launch WPS Spreadsheets and open your local employee list workbook to seamlessly edit and format your data.

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.




