Unanswered

Formatdatetime in powerautomate

(0) Share

Report

Posted on by dmclaughlin

347

I have a date/time in a sharepoint list. I have a power automate setup to send an email when new doc is created. I want the date/time in the email. I've used this statement

formatDateTime('Date_x0020_of_x0020_MEeting','MM/dd/yyyy hh:mm')

When I test the flow it gives me an error on the email saying the value provided for date time string 'Date_x0020_of_x0020_MEeting' was not valid. The datetime string must match ISO 8601 format.

IDEAS? I

Categories:

Power Automate Desktop

I have the same question (0)

All responses (3)

Answers (0)

Sort by

MichaelAnnis 5,727 Moderator on at

Like (3)

Report
Copy link

Link copied!

In Power Automate Desktop, we have "convert date to text" and you can convert it to a custom format "MM/dd/yyyy hh:mm" to a variable %Date_String%. Then you can use the variable %Date_String% in the email.

Was this reply helpful? Yes No
Yedukondalu 2 on at

Like (0)

Report
Copy link

Link copied!

Here i have two doubts,
1.How can i get only date from above value("MM/dd/yyyy hh:mm") with out any time value.
2.How can i change a date formate from MMddyyyy to MM/dd/yyyy.

Please anyone help me this... Thanks

Was this reply helpful? Yes No
MichaelAnnis 5,727 Moderator on at

Like (0)

Report
Copy link

Link copied!

You can take any text format to a date format using “convert text to datetime” and you can convert any date format (regardless of it is has time or not) to text.

so, if you have a text format MMddyyyy hh:mm and you want it to be in a text format MM/dd/yyyy, change it to date and then to your next text format.

ex.

Set (text) variable as 05/22/2023 12:45 as %Today_Text%
Convert Text %Today_Text% to Datetime as %Today_Date%

Convert Datetime %Today_Date% to Text in custom form MMddyyyy as %Formatted_Date%

Was this reply helpful? Yes No