How do you update a SharePoint page with Microsoft Form submissions kept in an Excel file?

Hi Geocie,

You have two options:

1) Embed the Excel File

• Go to your SharePoint Site
• Go to "Gear"->"Add a Page"->"Create Page"
• Name that Page "Schedule of Change"
• Remove the text webpart from that page by selecting it and clicking the "recycle bin" icon
• Press the "plus" sign in the middle and add a "File and Media" Webpart
• Browse to the Excel File
  
  

Now your Excel file is embedded on that page. 

If the form refreshes the file, then you will see the updates.
But this always looks like an excel file and the page might take some time to load

1) With a List and a Flow

• Go to your SharePoint Site
• on the left side click "New" and select "List"
•  
• Create a "Blank list" and name it "Change Requests"
• Add all the columns you want to display in that list
  

   

• Go to "Gear"->"Add a Page"->"Create Page"
• Name that Page "Schedule of Change"
• Remove the text webpart from that page by selecting it and clicking the "recycle bin" icon
• Press the "plus" sign in the middle and add a "List" Webpart
• Select the "Change Request" List
• Publish your page

Now you have a page and a blank list. You can customize that list view to look totally different, if you like. (using view formatting: https://learn.microsoft.com/en-us/sharepoint/dev/declarative-customization/view-formatting).
But that list is still empty. Now you need to build an automation that fills that list, if a new entry has been submitted.

• Go to https://make.powerautomate.com/
• On the left side, click create
• Select "Automated cloud flow"
• Name it "Change Requests" and select "When a new response is submitted" (Microsoft Forms) as a trigger
• Press "Create"
• Select your form in the Form id column of the "When a new response is submitted" Action
• Click "New Step" and select "Get Response Details" (Microsoft Forms)
• Select your form in the Form id column of the "Get Response Details" Action
• For the "Response id" select the field and then select "Response Id" from Dynamic Content
  

   

• Click "New Step" and select "Create Item" (SharePoint)
• Select your SharePoint Site Adress and the list name "Change Requests"
  
  
• Now it depends on how many fields you added to your list. In my example i only used the column title.
  Click into each column of your list and select the corresponding dynamic content from the "Get Response details" Action
  

   

  
  

   

• Now the flow is complete... click the save button on the upper right
  
  

Now everytime someone enter data into your form, this flow is activated and creates a new list item in the "Change Request" list.

Best Regards,

Sven