web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate Format Date Time Issue

Power Automate

Answered

Format Date Time Issue

(0) Share

Report

Report

Posted on by Community Power Pla... Microsoft Employee

My current Date and time in Source Data (Same Date and Time in both the rows ) : 2021-03-30T16:00:00

The actual output should be in SharePoint List as : 03/30/2021 04:00 PM

My expression :

if(empty(items('Apply_to_each')?['Date_Field']),null,formatdatetime((items('Apply_to_each')?utcNow()['Date_Field']),'MM/dd/yyyy hh:mm: tt'))

My Current Output is (It shows Random time):

Any help will be appreciated. Thanks in Advance.

Categories:

I have the same question (0)

All responses Img

All responses (3)

Answers Img

Answers (1)

Sort by

Sundeep_Malik 6,501 on at

Like (0)

Report
Copy link

Link copied!

@Anonymous
Check this out, if it helps.

https://powerusers.microsoft.com/t5/General-Power-Automate/How-to-get-tomorrow-s-date-at-a-specific-time-based-on-current/m-p/1778751#M103290

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

Like (0)

Report
Copy link

Link copied!
Hi @Anonymous

I suggest you to modify the formula to:
if(empty(items('Apply_to_each')?['Date_Field']),null,formatDateTime((items('Apply_to_each')?['Date_Field']),'MM/dd/yyyy hh:mm tt'))

Best Regards,
Levi

Was this reply helpful? Yes No
Verified answer

Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

It again throws up a random time. But I have sorted it out.

What I did was, I have converted the time from UTC-8 to my local time. and now it is working with my proposed formula (Which is in the question.)

Thanks for all of your help.

Was this reply helpful? Yes No

Join the conversation