Date output a day before the chosen date from Adaptive Card form

(0) Share

Report

Posted on by fernandosilva Super User 2024 Season 1

Hi there,

I have seen other similar threads about the date conversion and seems like there is something weird going on around.

On my PVA my adaptive card has a formula to convert string to date which is :

Text(Topic.PurchaseDate)

On my Power Automate flow I have the following set up:

2023-08-08 13.43.28 make.powerautomate.com b4becfdc68b0.png

Where the Compose 2 set up is:

formatDateTime(outputs('Compose'),'dd/MM/yyyy', 'en-GB')

Even so, my output date is always a day before the chosen date from the Adaptive Card form.

If I choose the date to 01/08/2023

The output that comes through is:

2023-08-08 16.30.45 outlook.office.com d8bd8bf8bd79.png

Any help will be appreciated.

Kind regards,

Fernando

Categories:

General topics

I have the same question (0)

All responses (6)

Answers (0)

Sort by

fernandosilva Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Anyone in the community to share any experience with the adaptive card/date/output?

Thank you.

Was this reply helpful? Yes No
v-jefferni Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @fernandosilva ,

Could you please go into one run history of the flow, checking the outputs in Compose and Compose2?

Best regards,

Was this reply helpful? Yes No
fernandosilva Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @v-jefferni ,

Sure, see below both compose connectors with the values.
Since the 1st of August was chosen, I'm not sure why it's output 31st of July.

Cheers ,

Fernando

Was this reply helpful? Yes No
v-jefferni Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @fernandosilva ,

You can see "31/07/2023" is the value passed to your flow from the Adaptive Card. So, the question now becomes how you custom the adaptive card. Could you please share more details?

Best regards,

Was this reply helpful? Yes No
fernandosilva Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @v-jefferni ,

My Adaptive Card date picker is set as follow:

{ "type": "Input.Date", "label": "Device purchase date", "id": "PurchaseDate", "style": "text", "isRequired": true, "errorMessage": "Purchase date is required" },

If you need more details from the Adaptive Card, please let me know.

Cheers,

Fernando

Was this reply helpful? Yes No
fernandosilva Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi All,

Have anyone here found a solution for the date bug?

Cheers,

Fernando

Was this reply helpful? Yes No