Power Platform Community Forum Thread Details

'List rows present in a table' does not always capture correct data in cells with a formula

I have a PAD automation which creates an Excel file with multiple sheets. The main sheet is using different formulas to different sheets to get the correct data, and all of this works fine. The file is opened via browser URL, and OneDrive is turned off on the computer running the synchronization (to mitigate any OneDrive sync issues, which we have seen too many times...). PAD saves the file, and then closes the file. A new Chrome instance is opened in PAD, which then opens a PowerApps for a specific screen, which starts the synchronization.

Power Automate Flow then starts by using 'List rows present in a table' for the aforementioned Excel file.

The issue I have only appears occasionally, but when they do happen, it can have some dire consequences, which is why I am posting here; the issue is that the cells which has a formula does have data in the Excel file, but Power Automate captures this data as '0' instead of what it should display.

When looking at the Excel file itself, one can clearly see that there is data, but when looking at the 'List rows...' Outputs from the flow, all the columns displays '0'.

Most often, it happens during one synchronization, and fixes itself on the next, but not always.

Would anyone know why this happens, or possibly have a quick solution to mitigate this? It just happened now, and it continued happening (we synchronize every 10 minutes) - the solution was to download the file, and then replace the file on SharePoint with the downloaded one, and everything worked fine afterwards. Such a strange issue....

Quick Links

Leaderboard