Hi valued Microsoft users,
I'm running into an error which I can't resolve on my own, thats why Ive created this post. (screenshot below).
What is my problem?
Im sending an Excel file with 2 tables inside to PowerAutomate by way of an webhook HTTP request (works), when the excel is received in B64 I want to decode the B64 string to an Excel file. However this part always seems to fail after the first try and I'm not sure why.
The error:
{
"status": 423,
"message": "The resource you are attempting to access is locked",
"source": "api.connectorp.svc.ms"
}
What have I tried?
1. Closing all apps that 'could' be using the Excel.
2. Asked my colleages to close everything OneDrive / Excel related
3. Different file names
4. Place a variable (for unique naming) inside the name, this doesnt work because you can't select the Excel in later stages to draw data from the tables.
5. Ask GPT
6. Tried to bypass the lock, couldnt really find anything about this.
What is a solution for me?
1. Finding a way to bypass/ undo the lock so the flow can complete.
2. Any alternative way within a reasonable scope of OneDrive / Excel combination of use.
The flow: