web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id : w7Pl037MPxmWxWxlBR/Gid
Power Automate - Using Flows
Unanswered

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

Like (0) ShareShare
ReportReport
Posted on 16 Nov 2018 17:57:03 by

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.

  • leyburn19 Profile Picture
    2,157 on 02 Oct 2019 at 21:54:07
    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 

  • DataViz Profile Picture
    13 on 18 Jun 2019 at 16:30:59
    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. 

  • Community Power Platform Member Profile Picture
    on 25 Jan 2019 at 18:05:44
    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!

  • GabrielStJohn Profile Picture
    on 03 Dec 2018 at 18:59:18
    Re: Excel connector - List rows present in a Table connecto causes a long lasting lock on the excel

    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

  • v-yamao-msft Profile Picture
    on 19 Nov 2018 at 06:12:34
    Re: Excel connector - List rows present in a Table connecto causes a long lasting lock on the excel

    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

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

Quick Links

Announcing our 2025 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for…

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 497 Super User 2025 Season 2

#2
David_MA Profile Picture

David_MA 436 Super User 2025 Season 2

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 244 Super User 2025 Season 2

Featured topics

Restore a deleted flow
Loading complete