I have an app that reloads every hour, and after it reloads it sends an email showing the status of various data pipelines.
I've created a couple of variables that store the latest timestamp and hour that data entered the app.
vLatestData, and vLatestDataHour and for the most part it works, below are both variables working as intended.
The automation runs after reload is successful and checks the vLatestDataHour variable and uses it in the email body, along with a screenshot of the sheet (In the screenshot, you can see the vLatestData variable at the bottom left of the sheet.
The problem is they don't match when the email is sent, however as soon as i open the app they're matching like what I shared above.
Is it a cache thing? do I need to add an extra step at the beginning of the automation to save the app before proceeding?