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

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

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.

Categories:

Using flows

I have the same question (0)

All responses (5)

Answers (0)

Sort by

v-yamao-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous,

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-Business/idi-p/107822

Best regards,

Mabel

Was this reply helpful? Yes No
GabrielStJohn Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hey, @Anonymous!

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

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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!

Was this reply helpful? Yes No
DataViz 13 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
leyburn19 2,157 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No