web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Help with DateTime For...
Power Automate
Unanswered

Help with DateTime Format when field is null and other field dates wrong

(0) ShareShare
ReportReport
Posted on by 48

Hi Everyone!

 

I am having issues with the Date/Time Format in my PAF's emails.

 

I did the variable route and have my Created Field as expression: 

formatDateTime(utcNow(), 'MM/dd/yyyy hh:mm tt') and that works because there is always something in that field but I have another field that might be null and it errors the workflow.  That one is the ugly standard of: 2023-05-19T12:05:00Z

 

Also, is there a way to have that expression show the local time because it is showing as hours ahead.  

 

Also I have other date fields that are just date and formatted right in the form but show up as this in email: 2023-05-11.  

Hope I explained right and any help is appreciated.


Screen Shot 2023-05-04 at 10.24.19 AM.png 

 

 

Categories:
I have the same question (0)

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the March Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Haque Profile Picture

Haque 607

#2
Valantis Profile Picture

Valantis 456

#3
11manish Profile Picture

11manish 352

Last 30 days Overall leaderboard