Skip to main content

Notifications

Power Automate - Building Flows
Unanswered

The excel which logs Microsoft Form responses doesnt sync data automatically

Like (0) ShareShare
ReportReport
Posted on 14 Jan 2025 11:33:06 by 2
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
  • diltonthomas Profile Picture
    diltonthomas 2 on 14 Jan 2025 at 14:06:53
    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 Profile Picture
    narayan225 2,298 on 14 Jan 2025 at 13:09:04
    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.
     
    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!

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

End of Year Newsletter…

End of Year Community Newsletter…

Tuesday Tip #12 Start your Super User…

Welcome to a brand new series, Tuesday Tips…

Tuesday Tip #11 New Opportunities…

Welcome to a brand new series, Tuesday Tips…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 144,609

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,420

Leaderboard
Loading started
Loading complete