Forms data sync to Excel is now fully available with more functionality

Hello!

For a Power Automate flow I need the Form Excel file to sync anytime a new response is submitted. Currently, the Excel file is only syncing with the Form when someone opens the file. This however does not work because my Power Automate flow will look for the newly submitted data but wont find it.

I already transferred it to a private group but that did not make a difference. Anyone now a solution? There must be a way to sync the Excel file upon a newly submitted form without opening the excel file manually.

Greetings,

Tim