Power Automate seems to change variable values mysteriously. I am reading date values from an excel table. If the date value is greater than today's date, I want to blank it, otherwise, I want to write the date to the output file.
I use a variable to hold the date if less than today's date or blank if greater than today's date.
I use a COMPOSE step to view the excel value, a COMPOSE step to view value of variable, SET VARIABLE to set the variable to the date value from excel, and use a COMPOSE step to view the variable value after the set. The value of the variable has changed.
Looking at the run history, here is what I see (sorry, I can't provide a picture. Company machine and I can't install a snagit-like program):
COMPOSE to see excel value: Input value: 44265 Output value: 44265
COMPOSE to see variable value before SET VARIABLE: Input value: NA Output value: NA
SET VARIABLE Step: Input Value: 44265 Output Value: 44265
COMPOSE to see variable value: Input value: 42710 Output value: 42710
Any idea why the value mysteriously changes?
Here are screen grabs (I apologize for the piecemeal approach):
Here is the script logic - only tracking down the "NO" condition
