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:
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!
