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 da...
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 User
Thanks 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