Latency in Get Rows Rows Input Version

[sara_microsoft]

Hi!

I have a flow that triggers every morning at 8am.

The first action it does is get rows from an Excel file in OneDrive.

However, even if I update the Excel file the night before and it saves, the input is still from an older version.

I have to manually trigger the flow again for it to input the rows from my most updated Excel table.

Is this type of latency expected?

Is there anything I can do to avoid this latency? Ideally, i'd like to be able to edit the rows being input minutes before the flow triggers. 

Thanks!

 

[v-yamao-msft · Accepted solution]

Hi @sara_microsoft,

According to your description, I created a simple flow with the trigger Recurrence. For testing, I set the frequency as minute, and the interval as 10 minutes. Then get rows from an Excel file on OneDrive.

After the first run, I modify the Excel file, in the second run, it returns the updated Excel table. I don’t need to manually trigger the flow.

The issue is not able to be produced on my side. Not sure if it is caused by the Frequency. I will change the frequency and try it later.

Best regards,

Mabel Mao

[sara_microsoft]

Thanks @v-yamao-msft!!

10 minute intervals seemed to be working for me when I just tested. When I previously noticed the issue, I was using a 1 day interval (which is what my ideal set up is). I'm going to test again with 1 day intervals and will report back!

[v-yamao-msft]

Hi @sara_microsoft,

I made a 1 day interval test. It returned all the rows in the Excel. Have you tested it again on your side? Is it working now?

Best regards,

Mabel Mao

[sara_microsoft]

Hi @v-yamao-msft. I set up the one day interval today and will report back tomorrow on whether it's returning all the rows in the most recent version of my Excel table. Thanks for following up!

[sara_microsoft]

Hi @v-yamao-msft, Update that my run this morning grabbed the most recent version of the Excel table! Going to let it run one more round before calling it good. Thanks for your patience!