cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
TGPDenver
Level: Powered On

Excel Get Rows Error 423

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-fileso...

https://powerusers.microsoft.com/t5/Using-Flows/Microsoft-Flow-Excel-File-Locked-While-Not-Open/m-p/...

 

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!

1 ACCEPTED SOLUTION

Accepted Solutions
v-zhos-msft
Level 10

Re: Excel Get Rows Error 423

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

View solution in original post

3 REPLIES 3
v-zhos-msft
Level 10

Re: Excel Get Rows Error 423

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

View solution in original post

TGPDenver
Level: Powered On

Re: Excel Get Rows Error 423

Awesome, that fixed it. Thanks!

attitude08980
Level: Powered On

Re: Excel Get Rows Error 423

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.

Helpful resources

Announcements
firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

firstImage

Incoming: New and improved badges!

We've given our badges an overhaul and also added some brand new ones!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Top Kudoed Authors (Last 30 Days)
Users online (5,325)