In this Microsoft Excel video tutorial I explain how to sync Microsoft Forms responses with an Excel workbook stored on One Drive for Business. The same method would work if your Excel workbook is stored in SharePoint. This sync is achieved by creating a flow in Power Automate. This video also demonstrates how to trigger an Office Script as part of the same flow.

00:00 Introduction
00:17 Set up your table in Excel
00:52 Create a flow in Power Automate
03:34 Test if the flow works
04:09 Add a PivotTable to the worksheet
04:44 Record an office script that updates the PivotTable
05:26 Trigger the office script in the flow



#excel365 #exceltutorial #exceltutorial #microsoftexcel #microsoftforms #powerautomate