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

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Excel Get Rows Error 423
Power Automate
Answered

Excel Get Rows Error 423

(0) ShareShare
ReportReport
Posted on by 4

Problem: Individuals use a tablet at our front desk to provide contact information. The organization requires that we use Microsoft Forms. I want to automatically send a confirmation email to the person once they have filled out the form.

Attempted Solution: I am trying to create a flow to send an email to a person once they've submitted a response in a form. These individuals are not a part of my organization, so I have to access the email address they supply in the form. I have created the following steps so far:

flow.png
The flow fails each time it gets to the Get Rows line due to a 423 error, with the document being locked for editing. The document is saved in OneDrive for Business.

 

I have tried the workaround solution from:
https://powerusers.microsoft.com/t5/Using-Flows/Excel-Get-Rows-Error-423-Cannot-write-file-to-filesource-File-is/td-p/155540

https://powerusers.microsoft.com/t5/Using-Flows/Microsoft-Flow-Excel-File-Locked-While-Not-Open/m-p/83380/thread-id/2393/highlight/true

 

I have delayed it for 3 minutes, 5 minutes, and 10 minutes. I still get the 423 error. I'm also afraid that this work around won't work when I get a lot of submissions at once.

I'm not attached to this solution, if there's another option, I'm open to that.

But if I have to use a flow, my main question is: how can I get the flow to access a specific row via Get Rows when I always get an error stating that I am locked out of the document?

Thanks!

Categories:
I have the same question (0)
  • Community Power Platform Member Profile Picture
    on at

    Hi All,

    I don't know if that is the solution, but at least I had that problem "423". At first I had the file only "on-line" in SharePoint and also I tried on OneDrive. But those folders wasn't sync with my PC. 

    I tried in one SharePoint Folder sync with my computer and the same Flow works, then I sync the folder where it was the original file and works too.

    Hope help you.

  • TGPDenver Profile Picture
    4 on at

    Awesome, that fixed it. Thanks!

  • Verified answer
    v-zhos-msft Profile Picture
    on at

    Hi TGPDenver,

    According to you description, you want to send an email to the person who has submitted a form at your front desk.

    The problem is you want to get a specific row, I suggest you to use the Get a row action.

    I have made a test for you on my side, shown as below:

    3.png4.png

    Best Regards,

    Zhongys

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
David_MA Profile Picture

David_MA 245 Super User 2025 Season 2

#2
Expiscornovus Profile Picture

Expiscornovus 207 Most Valuable Professional

#3
trice602 Profile Picture

trice602 185 Super User 2025 Season 2

Last 30 days Overall leaderboard