web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / issue moving data from...
Power Automate
Unanswered

issue moving data from a form to excel

(0) ShareShare
ReportReport
Posted on by 2

Hello I am having an issue getting a flow setup where I take information from a Form and dump it into Excel.  I keep getting the following error of could not retrieve values the dynamic invocation request failed with error: "status": 409 "message": Graph api is unable to acquire or refresh a lock on the file because it is already locked.  Please close edit sessions and try again"

 

I've tried this a few different times and cannot get any further then that.  Is this how I have the excel table formatted?  Any help would be greatly appreciated. 

Categories:
I have the same question (0)
  • Verified answer
    Brad_Groux Profile Picture
    4,556 on at
    Re: issue moving data from a form to excel

    This is because of the file lockout issues of Excel, range from 6-12 minutes in time. That means, each time a form submission is made and the Excel file is updated, another user cannot submit a form for 6-12 minutes.

    You should use a SharePoint list for this sort of operation.

    If you could provide an expanded screenshot of your Flow and steps, your Flow run history, and of any detailed error messages you're receiving we could likely better assist you. Also, for the best results, you may want to review How to write a good forum post.

    If this reply answers your question or solves your issue, please ACCEPT AS SOLUTION ☑️. If you find this reply helpful, please consider giving it a LIKE.

     

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Tomac Profile Picture

Tomac 497 Moderator

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 477 Super User 2025 Season 2

#3
chiaraalina Profile Picture

chiaraalina 242

Last 30 days Overall leaderboard