When I try to access an excel file from an email attachment with a Power Automate flow, I receive the error, that the file is locked for shared use by myself. How can I make changes to the file?

Question

I'm using a power automate flow to create a file in SharePoint out of an excel attachment sent to my inbox. Whenever the flow attempts to create the file, I received the error shown in the image. I'm not sure if there's something I'm missing in the flow or if the file is just not accessible.

Answer 1

Hi, As per my understanding, you are saving the email attachment(s) in the SharePoint library. If yes, it should be straight using power automate.
Please use the following connectors and action in your power automate flow and test if you are able to save the attachment:

To <highlight in yellow>: add your email address or user on which excel file is received. Next action is to iterate & save attachments in SharePoint document library folder:

Please try using these steps & let me know if you need any other help.

Answer 2

Hi @Matamoros, Santiago ,

According to the error message, please check the file for the following conditions:

1. The library enables check-in and check-out. When the file is checked out by other users, other users cannot use it. If yes, check in or discard check out the file. Then run the flow to see whether the error still occur.
2. The file has unique permission, and the account running flow has no permission. Please use an authorized account or grant account permissions.

===

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".