Get File Contents of Excel File Missing Rows

(1) Share

Report

Posted on by MrRK

This is a fun one...

The flow does the following:

Pull the current rows from an Excel sheet in Sharepoint and delete all the rows.
Insert some new data into the Excel sheet.
Wait for 90 seconds.
Get the contents of the excel file from Sharepoint.
Get another word document from Sharepoint (irrelevent to the issue, but I wanted to explain where there are two 'Get File Contents').
Send both files in an email.

When the file arrives by email, it's missing most of the added Rows.

If I view the excel file in sharepoint, all the rows are there.

If I view the excel file during the delay, all the rows are there.

What's going on? It's like the Get File Contents is looking at an older version of the file in Sharepoint... surely 90 seconds is more than enough to wait?

Any help appreciated.

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

ChrisPiasecki 6,422 Most Valuable Professional on at

Like (1)

Report

Hi @MrRK,

According to the Excel connector docs, the connection can hold a lock up to 6 min after an update. Since you're using a SharePoint connector to get the file contents within that window, that introduces a concurrency/locking issue. I imagine if you increased your delay to say 10 min, the previous connection and lock "should" be released.

---
Please click Accept as Solution if my post answered your question. This will help others find solutions to similar questions. If you like my post and/or find it helpful, please consider giving it a Thumbs Up.

Was this reply helpful? Yes No
MrRK 32 on at

Like (0)

Report

Nice, thanks for your help.

I’ll adjust the delay to 6 minutes and see how we get on.

Was this reply helpful? Yes No
kyleb350 15 on at

Like (0)

Report

Hi @MrRK . Old issue, but did that delay end up helping?

Was this reply helpful? Yes No