Skip to main content

Notifications

Announcements

Replay: Power Platform Community AMA - Copilot Studio | April
Welcome to the Power Platform Communities
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate - Using Flows / 'Add a row into a tabl...
Power Automate - Using Flows
Unanswered

'Add a row into a table' action started to fail after running fine for 6 months

(0) ShareShare
ReportReport
Posted on by Community Power Pla...

I have a simple flow, where I copy an Excel file to an target location then I will add rows into the table. Within the Excel, there is a table where I write the rows to. This has been working for the last 6 months and suddenly failed since last Thursday with the following error: 

No table was found with the name '{CC700916-B4B0-4C58-A562-577DB6A393DB}'.
clientRequestId: 06660efd-6f46-4f29-a55d-eaf2189c75e7
serviceRequestId: 7bf38641-7fd6-4d1a-ab69-4ce09a612226

 

Need some help to resolve this issue as (1) the intended table to add a row exists in Excel (2) this has been working for 6 months and suddenly started to fail.

 

pix.JPG

  • miguelcas Profile Picture
    miguelcas Microsoft Employee on at
    Re: 'Add a row into a table' action started to fail after running fine for 6 months

    Hi @Anonymous  

     

    can you share screenshots of your flow, the error and the action that it's giving you the error?

     

    Please make sure your credentials are setting up as the connection of the action Copy File.  You need to have access to the source folder/file and to the destination folder/file in SharePoint. 

  • Community Power Platform Member Profile Picture
    Community Power Pla... on at
    Re: 'Add a row into a table' action started to fail after running fine for 6 months

    Hi miguelcas, 

    The lock is happening on the original file that is only used by this automation (and no human using that file). Hence, it is quite weird that it locks itself. 

    I have also deleted the file and created a new one. However, same thing happens i.e. the 'Copy File' reports that the source file is locked. 

    This did not happen 2 weeks ago. Did anything change?

  • miguelcas Profile Picture
    miguelcas Microsoft Employee on at
    Re: 'Add a row into a table' action started to fail after running fine for 6 months

    Hi @Anonymous 

     

    Looks like the excel file you are trying to edit it's locked by other user or flow. Just to know the table that you are updating it's in the original excel or in the copy one? This error could be  for some reasons

     

    1. because the flow is using the excel file for the copy action and the resource can not be open by the add row action. Adding a delay to the flow may solve this issue. 

     

    2. Other flow or user it's using the same excel file. Like another automated flow that is trigger by an update. Same solution here, adding a delay. 

  • Community Power Platform Member Profile Picture
    Community Power Pla... on at
    Re: 'Add a row into a table' action started to fail after running fine for 6 months

    Hi miguelcas,

    I tried that but still could not work. Now on a different error (see below). This excel file is in SharePoint.

    Is there a way to force the unlock? 

     

    Microsoft.SharePoint.SPFileLockException: The file https:TSL_temp.xlsx is locked for shared use by (unknown user).
    at Microsoft.SharePoint.SPFile.MoveCopyInternal(SPResourcePath newUrl, MoveUrlFlags grf, Boolean requireWebFilePermission, String etagMatch, Guid originatorId, String& newETag, Boolean allowNoExecuteWebFileUpdate, Int32 searchFlags)
    at Microsoft.SharePoint.SPFile.CopyTo(SPResourcePath newPath, SPCopyOperations copyOperations)
    at Microsoft.SharePoint.Administration.SPMigrationOrchestrator.PerformCopyWithinWeb(SPCopyMigrationParameters migParams)

  • miguelcas Profile Picture
    miguelcas Microsoft Employee on at
    Re: 'Add a row into a table' action started to fail after running fine for 6 months

    Hi @Anonymous 

     

    Looks like your excel table name change in that's why the flow cannot found the table. Sometimes we need to delete the actions and add the action again to refresh the links and data that comes from the action. So, try deleting the "Add row into table 2" action and then add it again to refresh the data and locate the excel table

     

    Thank you for using Microsoft Power Platform Communities.
    Community Support Team - Miguel Castro.
    If this Post helps, then please consider Accept as solution to help the other members find it more quickly.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Replay: Power Platform Community AMA - Copilot Studio | April
Welcome to the Power Platform Communities

Quick Links

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Markus Franz – Community Spotlight

We are honored to recognize Markus Franz as our April 2025 Community…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,668 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 66,004 Most Valuable Professional

Leaderboard

Featured topics

Restore a deleted flow

Product updates

Microsoft Power Platform Community release plans