Forum Discussion
Microsoft Forms Beginner - Can You Use Excel to Generate a Form?
Hi, I am a complete beginner on Microsoft Forms and have been tasked with creating a front end to an excel database using a form. The idea is the form is completed and it writes the answers to the database.
The database is about 100- rows deep and has KPIs and metrics on along with names of people responsible for them. I want people to select their team and then name from a drop down list which then populates the KPIs they need to answer questions about. I want this to be drawn from an excel sheet rather than me having to manually type in 1000 questions manually. Also I need the answers given to populate the database where I need them to go. Can this be done?
DanFirth I think you should be using Power Apps for this. Your app can have the Excel spreadsheet as a data source, you can then have cascading dropdowns for the team and team members and the data can be written back to the row in the Excel spreadsheet. Forms won't be able to do this for you unless you save the responses to the relevant Excel row via a flow in Power Automate.
Rob
Los Gallardos
Microsoft Power Automate Community Super UserThanks RobElliott Apologies if this is an obvious question but if I use power apps, can I have the form that I want people to complete on a sharepoint site...I'm a complete novice so apologies if this should be obvious. Thanks again
DanFirth yes a Power Apps app can be added to a SharePoint page with the Microsoft Power Apps web part, in the same way that a Forms form can be added to a page.
Rob
Los Gallardos
Microsoft Power Automate Community Super User
