You’re offline. This is a read only version of the page.
16
Hi,
I have a PVA which allows people to request Holiday Cover. I have:
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?
Hi @Shelzinho,
To reference variables in Power Fx in PVA, you need to prefix the name with Topic. (for topic-level variables) or Global. (for global variables).
E.g.:
Text(Topic.varStartDate)
Henry
I did see the formula tab but I'm not able to select the output from the adaptive data card in the formula section. I tried Text(varStartDate) but it couldn't find varStartDate or for that matter any of the variables set before that step.
If you are using the new editor you can use PowerFX functions in the Set Variable action. Using PowerFX you can format the date as a UTC string. That is what Power Automate is expecting.
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.
Share
Report
All responses (
Answers (
