Forms EXCEL sheet not updating

Copper Contributor

I have created a FORM and used Power Automate to update my spreadsheet.  My EXCEL spreadsheet does not update until I access FORMS and open the EXCEL spreadsheet.  Any suggestions?

2 Replies

@KDFowler I'm a bit confused as to what you are doing as normally when you create a form and users respond their responses are automatically saved to the spreadsheet behind the form (in the responses tab -> open in Excel) without the need to create to create a separate spreadsheet and have a flow populate it. Are you just using the out-of-the-box functionality to create your spreadsheet or are you trying to do something else with Power Automate?

 

Rob
Los Gallardos
Microsoft Power Automate Community Super User

@RobElliott  I have multiple users viewing the spreadsheet without having to go into forms.