Hello - I have a column in excel with calculated values. Power Automate is setup to list rows present in table, run a condition on the values in the column, and then send an email based on the condition. The power automate condition will return FALSE but after an hour or so it starts to return TRUE.
I've tried adding a delay before the condition to give excel time to calculate but that didn't make a difference. The only thing that makes a difference is waiting an hour and then power automate will be able to read the value each time. If there is a calculated value in cell J1 and J2, then power automate will only recognize the value that has been there for more than an hour.

Report
All responses (
Answers (