cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
sliorbar
Level: Powered On

Excel connector - List rows present in a Table connecto causes a long lasting lock on the excel file

We have  a simple flow

1 - Copy excel file from sharepoint location to a onedrive folder,

2 - Extract infomation from the excel file using the "List rows present in a Table" 

3 - Delete the file from step 1

 

For some reason, the List rows present in a Table action (step 2) casues a long lasting lock on the files created in step 1 and step 3 is failing... even after more than 1 hr.

5 REPLIES 5
Community Support Team
Community Support Team

Re: Excel connector - List rows present in a Table connecto causes a long lasting lock on the excel

Hi @sliorbar,

 

How is your flow created? Could you share a screenshot of your flow?

In the action List rows present in a table, are you getting the file using the dynamic content from the previous action?

However, I am afraid that dynamic contents in File/Table inputs in connector Excel (Business) haven’t been supported yet. If you need this feature, please vote and comment the idea at here:

https://powerusers.microsoft.com/t5/Flow-Ideas/Dynamic-content-in-File-amp-Table-inputs-Excel-Busine... 

 

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

Re: Excel connector - List rows present in a Table connecto causes a long lasting lock on the excel

Hey, @sliorbar!

Thank you for posting on the Flow Community Forum! It appears as though @v-yamao-msft would like some more information in order to further assist you properly with your issue. Please share any additional information that was requested in order to decrease the amount of time that it will take for you to be assisted!

Thank you for being an active member of the Flow Community!

-Gabriel
Flow Community Manager

-Gabriel
Microsoft Power Automate Community Manager
Are YOU a member of your local Power Automate User Group?
Fill out This Form to claim your Community User Group Member Badge!
sliorbar
Level: Powered On

Re: Excel connector - List rows present in a Table connecto causes a long lasting lock on the excel

I am not sure I understand the question from the previous message. 

Let me re-iterate what is the flow.

Step 1 - Flow copies a file from one SharePoint Library to another

Step 2 - Flow uses "List rows present in a table" to extract information from the excel

Step 3 - Flows tries to delete the copy of the file from step 1

 

Problem - The file is locked and step 3 fails.

In step 2, we use the output of step 1 (new file name) when opening the file and extracting information in a table.

It would be great if the file will be available for deletion at step 3 without the need to wait hours...

 

Thank you!

DataViz
Level: Powered On

Re: Excel connector - List rows present in a Table connecto causes a long lasting lock on the excel

I am having the same issue. However, I am using onedrive for business to copy a file and then extract the rows. 

Super User
Super User

Re: Excel connector - List rows present in a Table connecto causes a long lasting lock on the excel

When dealing with excel I have found I need to add some strategic placed delay actions.  I believe that while you may concider the file to closed and accessible there are actions that ofetn still taking palce for up to 2 or 3 minutes and excel is concidered still in use on one drive. Place in a delay can overcome that.  Type in Delay in add new actions 

Helpful resources

Announcements
firstImage

Incoming: New and improved badges!

Look out for new contribution recognition badges coming SOON!

firstImage

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

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!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Users online (4,901)