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?

Matamoros, Santiago 0 Reputation points
2023-04-17T17:01:12.7166667+00:00

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. Power Automate File Error

SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
9,868 questions
{count} votes

2 answers

Sort by: Most helpful
  1. Manish Solanki 155 Reputation points
    2023-04-18T06:42:35.28+00:00

    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: User's image

    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: User's image

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


  2. Yanli Jiang - MSFT 21,866 Reputation points Microsoft Vendor
    2023-04-25T02:18:50.8966667+00:00

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