Unanswered

The excel which logs Microsoft Form responses doesnt sync data automatically

(0) Share

Report

Posted on 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:

Building flows

I have the same question (0)

All responses (3)

Answers (0)

narayan225 2,547 Moderator on at

Like (1)

Report
Copy link

Link copied!

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!

Was this reply helpful? Yes No
DT-24030957-0 2 on at

Like (0)

Report
Copy link

Link copied!

you can periodically run the Power Automate flow to get all form responses and save them in excel table.
Is this through api call?

Was this reply helpful? Yes No
narayan225 2,547 Moderator on at

Like (1)

Report
Copy link

Link copied!

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!

Was this reply helpful? Yes No