PVA - Date Input Adaptive Card + Power Automate Flow: Incorrect Date Output

(0) Share

Report

Posted on by stanswell84

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?

Categories:

Calling actions from Copilot Studio

I have the same question (0)

All responses (5)

Answers (0)

Pstork1 68,898 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Shelzinho 4 on at

Like (0)

Report
Copy link

Link copied!

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.

@stanswell84 @Pstork1

Was this reply helpful? Yes No
Pstork1 68,898 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Shelzinho 4 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
HenryJammes on at

Like (2)

Report
Copy link

Link copied!
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

Was this reply helpful? Yes No