Unanswered

The excel which logs Microsoft Form responses doesnt sync data automatically

Like (0) Share

Report

Posted on 14 Jan 2025 11:33:06 by DT-24030957-0

I'm using Power Automate to read an Excel file that is linked to a Form.
However , the new responses the are not synced if the Excel file is open on the web. This doesnt work for Power Automate as someone has to open the Excel every time to sync the latest responses.
Is there a way to solve this issue, like using Office script etc?
The "htttp call action to sharepoint" in power automate doesnt work in every organization

Categories:

Business Process Flows

All responses (3)

Answers (0)

narayan225 2,507 Super User 2025 Season 1 on 21 Jan 2025 at 21:56:03

Like (0)

Report

The excel which logs Microsoft Form responses doesnt sync data automatically

You can use the following video as a reference. It uses an unpublished API to achieve this work.

https://www.youtube.com/watch?v=eq6QRz29q9Q

Hope this helps.

Cheers!
DT-24030957-0 2 on 14 Jan 2025 at 14:06:53

Like (0)

Report

The excel which logs Microsoft Form responses doesnt sync data automatically

you can periodically run the Power Automate flow to get all form responses and save them in excel table.
Is this through api call?
narayan225 2,507 Super User 2025 Season 1 on 14 Jan 2025 at 13:09:04

Like (0)

Report

The excel which logs Microsoft Form responses doesnt sync data automatically

They updated the sync engine that sync the responses to the Excel recently and it is because of that.

https://techcommunity.microsoft.com/blog/microsoftformsblog/update-to-the-new-solution-for-syncing-forms-responses-to-excel/4229844

You can use Power Automate to trigger upon form submission and save each response in an excel table if you want.

Or you can periodically run the Power Automate flow to get all form responses and save them in excel table.

Hope this helps.

Cheers!