I have a flow which checks every few minutes for new rows on a form which collects form results and also has a few columns of calculated content.
The flow runs well except that for any form submissions in the last couple of hours (it seems), my flow returns calculated cells as #N/A, even though when I open the excel sheet the data is there.
Any ideas why this may be and/or a good workaround?