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

Excel Online (Business) connector not closing files properly

I am having problems with Excel Online (Business) connector. I have a flow that adds a line to a table in excel but then proceeds to lock the document for a period of time after the edit is completed. I've seen it anywhere from 10 minutes to 30 minutes where it locks the file and prevents future flows from running and any manual edits to the file. 

3 REPLIES 3
Highlighted
Community Support
Community Support

Re: Excel Online (Business) connector not closing files properly

Hi @anthonyfz,

 

Could you please share a screenshot of the configuration of your flow?

 

I have made a test on my side and don't have the issue that you mentioned.

 

I afraid that the Excel Online (Business) connector would lock the file when it's update the excel,and when the update operation is down, you could modify the new file.

 

Best regards,

Alice

Highlighted
New Member

Re: Excel Online (Business) connector not closing files properly

Here is the screenshot - the Excel task is the last task in the flow. 

 

flowscreenshot.png

Highlighted
New Member

Re: Excel Online (Business) connector not closing files properly

I am still having this problem. Today we had a flow complete and 15 minutes later the document was still locked by the Flow account. This is super annoying. 

Helpful resources

Announcements
FirstImage

Microsoft Ignite 2020

Check out the announcement of Power Platform content at Microsoft Ignite!

thirdImage

Experience what's new for Power Automate

Join us for an in-depth look at the new Power Automate features and capabilities at the free Microsoft Business Applications Launch Event.

firstImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Users online (10,714)