Skip to main content

Notifications

Power Automate - Building Flows
Unanswered

The excel which logs Microsoft Form responses doesnt sync data automatically

(0) ShareShare
ReportReport
Posted on 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
  • narayan225 Profile Picture
    narayan225 2,425 on at
    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.
     
     
    Hope this helps.
    Cheers!
  • diltonthomas Profile Picture
    diltonthomas 2 on at
    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,425 on at
    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

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,580

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,909

Leaderboard