Skip to main content

Notifications

Calling Actions from Copilot Studio
Unanswered

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

Posted on by 16

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)
    • stanswell84_0-1687363654824.png

If I select dates in January, February and March the Output before and after the Date Format flow is correct and the dates match 

stanswell84_1-1687363691711.pngstanswell84_2-1687363699409.png

 

stanswell84_3-1687363704634.png

 

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:

 

stanswell84_4-1687363730356.pngstanswell84_5-1687363740518.png

 

Does anyone know why it is doing this and how to correct it?

 

stanswell84_0-1687363944359.png

 

Categories:
  • HenryJammes Profile Picture
    HenryJammes on at
    Re: PVA - Date Input Adaptive Card + Power Automate Flow: Incorrect Date Output

    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

  • Shelzinho Profile Picture
    Shelzinho 4 on at
    Re: PVA - Date Input Adaptive Card + Power Automate Flow: Incorrect Date Output

    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. 

  • Pstork1 Profile Picture
    Pstork1 63,085 on at
    Re: PVA - Date Input Adaptive Card + Power Automate Flow: Incorrect Date Output

    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.

    image.png

  • Shelzinho Profile Picture
    Shelzinho 4 on at
    Re: PVA - Date Input Adaptive Card + Power Automate Flow: Incorrect Date Output

    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 

  • Pstork1 Profile Picture
    Pstork1 63,085 on at
    Re: PVA - Date Input Adaptive Card + Power Automate Flow: Incorrect Date Output

    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.

Helpful resources

Quick Links

Welcome to the Power Platform…

We are thrilled to unveil the newly-launched Power Platform Communities!…

Getting Started…

Welcome to the Power Platform Community! We appreciate your visit…

Welcome to the new Power Platform Community!…

We are excited to announce our new Copilot Cookbook Gallery in the Community…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 138,030

#2
RandyHayes Profile Picture

RandyHayes 76,308

#3
Pstork1 Profile Picture

Pstork1 63,085

Leaderboard

Featured topics