Unanswered

Getting the right date format

(1) Share

Report

Posted on by CP-19070958-0

Hi,

I need some help working with dates , adaptive cards and Http requests. Using CoPilot Studio for the first time, so bear with me

My Adaptive card looks like this:

When the user selects a date, it is coming back to me in the format dd/mm/yyyy (even if I try to change the format in the card itself, nothing happens)

In order to send the date to my Http call, I need the date to be in the format yyyy-mm-dd with the time element in the format 'T00:00:00.000Z'

I tried creating a variable setting it's value. But in the Set Variable function, using the datetimeformat gives me the following error

So I tried creating a formula like

Year(Topic.startDate) + "-" + Month(Topic.startDate) + "-" + Day(Topic.startDate) + "T00:00:00.000Z")
 
   But this is falling over with an error that says 'cannot convert '-' into a number'  I have tried putting the whole thing into a 'Text' call, individual parts into a Text call.  Still get the same error.  I'm stumped.  
 
   Can somebody please help?  Goal is to to take the date entered by the user and send it to the Http request in the format 'YYYY-DD-DDT00:00:00.000Z' 
 
Thanks

Categories:

General topics

I have the same question (1)

All responses (4)

Answers (0)

HenryJammes on at

Like (1)

Report
I think got this to work, like this:

The Text function in Power Fx can output a date in what is called the UTC format.

Text(Topic.SelectedDate, DateTimeFormat.UTC)

But because it's not a date/time, you may find yourself with a wrong date being sent, given the time zone different between the user and UTC (I'm not exactly sure what your API endpoint expects).

You can offset it by using this formula:

Text(DateAdd(Topic.SelectedDate, - TimeZoneOffset(Topic.SelectedDate), TimeUnit.Minutes), DateTimeFormat.UTC)

Was this reply helpful? Yes No
CP-19070958-0 18 on at

Like (2)

Report

Thank you Henry. That helps.

Would you point me to the right place for functions that I can use in CoPilot studio please, if you don't mind. I can't find the right source.

Was this reply helpful? Yes No
HenryJammes on at

Like (1)

Report
Sure, please refer to these:

Create expressions using Power Fx (preview) - Microsoft Copilot Studio | Microsoft Learn

Microsoft Power Fx overview - Power Platform | Microsoft Learn

Was this reply helpful? Yes No
David_MA 12,982 Super User 2025 Season 2 on at

Like (1)

Report

You can use the following expression:

formatDateTime(parseDateTime(triggerBody()['text'],'en-us','dd/MM/yyyy'),'yyyy-MM-dd')

Replace triggerBody()['text'] with the dynamic value that contains your date in the format dd/mm/yyyy.

This part of the expression tells Power Automate that you have a string value that you want to convert to an ISO8601 formatted date: parseDateTime(triggerBody()['text'],'en-us','dd/MM/yyyy').

Then the formatDateTime expression converts the ISO8601 date to your desired format.

Was this reply helpful? Yes No