cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
GailBan
Regular Visitor

Displaying Dates in flow emails

I have created a Microsoft form for PTO requests using date pickers.  How do I change the way the date is displayed in the approval emails in my flow?  I want it to display MM/DD/YYYY or Month DD, YYYY.  It is currently displaying as YYYY-MM-DD.

1 ACCEPTED SOLUTION

Accepted Solutions

 

Hi @GailBan ,

 

Yep, I am using Date Picker for testing, and this method is available.

173.PNG

Please check details:

78900.gif

 

Best Regards,

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

7 REPLIES 7
ScottShearer
Super User
Super User

@GailBan 

Take a look at the formatDateTime() expression.

 

 

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Scott
v-bacao-msft
Community Support
Community Support

 

Hi @GailBan ,

 

You could use formatDateTime() function.

Image reference:

159.PNG

 

Best Regards,

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Thank you so much for the reply.  However, it is not working.  When I try to enter that function it gives me an error massage.  I was able to use that function to change the timestamp for the request but these are the dates that employees choose on a date picker in forms.  Here is the start of the flow

 

Flow.pngFlow 1.png

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

This is how the approval email reads vs how I want it to read.This is how the approval email reads vs how I want it to read.

 

If I figure out how to put the function in I am also confused about when to put the format request in?  Will I have to ask it to be converted everytime I send an email with the begining date and emding date of the request?  

 

Thanks so much for your help, 

Gail

@GailBan 

You need to insert the formatDateTime expression anywhere you want to reference a date which is being reformatted. 

Here is a link to a blog post that briefly discusses using formatDateTime().

 

 

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Scott

Hi Scott, 

 

It is still not working.  I still get the error message saying that The expression is invalid.  Also this function has only worked for the timestamp, not for the form's date picker information. 

 

Hi @GailBan ,

 

Yep, I am using Date Picker for testing, and this method is available.

173.PNG

Please check details:

78900.gif

 

Best Regards,

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Thank you so much.  This worked!!! It is so amazing.  Smiley Very HappySmiley Very HappyHeart

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

New Ideas Forum MPA.jpg

A new place to submit your Ideas for Power Automate

Announcing a new way to share your feedback with the Power Automate Team.

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

MPA Licensing.jpg

Ask your licensing questions at the Power Automate AMA!

Join Priya Kodukula and the licensing team, super users and MVPs to find answers to your questions on Power Automate licensing.

Users online (1,551)