Hi,
I have a PVA which allows people to request Holiday Cover. I have:
-
An adaptive card (see bottom of question for code)
-
A Power Automate Flow which changes the output date from US to UK format (it works perfectly)
If I select dates in January, February and March the Output before and after the Date Format flow is correct and the dates match
However, if I start selecting dates from April onwards, the post flow output puts the dates back by 1 day. Looking at the Flow Run, the dates that Flow is receiving from the PVA (see below) are 1 day back instead of correct:
Does anyone know why it is doing this and how to correct it?
Interesting to see your solution. May I ask how you managed to input a date from PVA and pass it as a string to Power automate. I’m currently stuck at this. I have an adaptive data card to take the inputs which consist of two dates but I’m unable to pass it to flows as I can’t convert the dates to string format to pass to the Flow.
The dates are being handled as UTC time and you are running into an issue when Daylight Savings time starts. That's why it happens at the end of March beginning of April. The date is always handled as though it was midnight on that day. When daylight savings starts its treating it as though it were yesterday at 11:00PM instead of midnight.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email
Notification settings
across all subscriptions.
