powerapps - Microsoft Power Automate Flow action "List Rows present in a table" - Stack Overflow

List rows present in table action

This action sometimes picks up the rows but sometimes it does not. This is trying to connect to a live share point excel sheet people are constantly editing throughout the whole day. There will be days this flow runs successfully without any issues but some days where it cannot pick up any rows.

The current temporary solution we have it to rerun the flow and this works every time on the first rerun. Has anyone else run into this issue ?

List rows present in table action

This action sometimes picks up the rows but sometimes it does not. This is trying to connect to a live share point excel sheet people are constantly editing throughout the whole day. There will be days this flow runs successfully without any issues but some days where it cannot pick up any rows.

The current temporary solution we have it to rerun the flow and this works every time on the first rerun. Has anyone else run into this issue ?

• power-automate
• powerapps
• power-automate-desktop

Share Improve this question Follow asked Jan 30 at 21:16 Ethical_QueryEthical_Query 1

Add a comment  | 

1 Answer 1

Sorted by: Reset to default 0

this may happen if the file at the time of run is locked for editing for any user publishing or saving changes - right at the moment. a solution is to check after completion if the output has nay value. If it is zero, do a retry after a delay of 5-10 minutes and list again. this would work as until then the lock is released.