cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
New Member

Excel Online (Business) - Add a row into a table - error

whenever i try and use my simple workflow to add rows within a table - that the spreadsheet is open I get:

 

"Cannot write file to filesource. File is being locked.\r\nclientRequestId"
 
don't get this when the spreadsheet is closed.
 
Tried deleting replication (as read this could cause a lock) - no joy.
 
H E L P....... or suggestions?
4 REPLIES 4
Highlighted
Community Support
Community Support

Re: Excel Online (Business) - Add a row into a table - error

Hi @tonyjduk,

 

Could you share a screenshot of your flow?

I have created a flow to add a row into a table on SharePoint library when an item is created in a list. With the Excel table being opened, the flow still ran succeed.

1.PNG

What do you mean by “Tried deleting replication”?

Could you try again with it?

 

Best regards,

Mabel

Community Support Team _ Mabel Mao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
New Member

Re: Excel Online (Business) - Add a row into a table - error

thanks for that. I'm capturing the data via a form, and have adapted this now to include your approach of using a sharepoint table, which currently i can have the spreadsheet open and running the flow doesn't give me an error now - but hasn't populated anything in the excel spreadsheet. THe sharepoint table shows me what i'm capturing - but this is reflecting on the excel file - that's now being stored in a TEAM document location
Highlighted
Community Support
Community Support

Re: Excel Online (Business) - Add a row into a table - error

Hi @tonyjduk,

 

Could you share a screenshot of your flow?

Where is the Excel file stored?

From your description, it seems that the flow didn’t populate anything to the Excel table though it ran succeed.

Please make sure you have formatted the Excel spreadsheet as a table.

 

Best regards,

Mabel

Community Support Team _ Mabel Mao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
New Member

Re: Excel Online (Business) - Add a row into a table - error

Hi Mabel,

 

yes now all woking via teh sharepoint route, instead of teh direct to excell route, as looking at other forums tehre is clearly a limitation/bug in the direct to excell route with having the document open whilst trying to have a workflow that adds rows (not evident in google docs though, and strange how when your're sharing an excel spresheet amongst peoe, this also isnt evident.

 

appreaciate your help on this.

 

thanks,

 

Tiny

Helpful resources

Announcements
firstImage

Now Live: Power Virtual Agents Community!

We are excited to announce the launch of Power Virtual Agents Community. Check it out now!

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

Top Solution Authors
Users online (6,706)