Power Platform Community Forum Thread Details

*Update-------------------------------------------------------------------------------------------------------------------------------

Hi again, I identified the issue, it is because power automate recalculate the formulas in the excel, instead of using the values directly from the excel. From the following picture, the "today" column is calculate as 2022/6/2 in Taiwan time zone, however in power automate it is evaluate as 2022/6/1, which I assume is USA time zone.

Hence the formulas related to today(), or now(), will be recalculated in power automate using USA time zone, which explains why the formula are evaluate to TRUE in excel, but FALSE when power automate recalculate the value.

And I don't know how we can change the time zone in power automate...So I guess this problem doesn't have a solution for now? Hope this helps bring up the attention from Microsoft though...

-------------------------------------------------------------------------------------------------------------------------------------------

Hi everyone,

I am working on an reminder system where the logic are already implemented using excels formulas as follows.

This should not be a problem but when I head over to power automate and create a very simple flow like follows,

The condition is evaluated to be false, hence I checked the results of previous step, which is as follow,

so as the results showed, power automate get the value of "Send Notify" column as False, however in the Excel file it is clearly a True. After this I checked other rows and found out that the False in Excel are recognized as False in power automate, strangely, True in Excel are treated as False in power automate.

However if I set the excel formula as =TRUE, power automate seems to correctly fetch the True. Just when the formula is complicated, power automate will treat everything as False, regardless of the real Boolean in Excel.

Any Idea?

Categories:

Building flows