Forum Discussion

DanFirth's avatar
DanFirth
Copper Contributor
Jun 15, 2020

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...
microsoft forms
RobElliott's avatar
RobElliott
Silver Contributor
Jun 15, 2020

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

  • DanFirth's avatar
    DanFirth
    Copper Contributor
    Jun 15, 2020

    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

    • RobElliott's avatar
      RobElliott
      Silver Contributor
      Jun 15, 2020

      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

Resources