Date Time from SP not coming over correctly

(0) Share

Report

Posted on by Holly_CMS

523

Hi,

I am really finding the date/time zone expressions in Power Automate quite challenging.

In SP, we have a field that is a date/time that users enter a future date in.

In Automate, it is in the UTC time zone. We are in the Arizona time zone that we need to use the Pacific time zone. But the Automate isn't allowing it in the expression. I don't like the format when using the value.

So I am stuck in the format so far...

formatDateTime(triggerOutputs()?['body/Datetoprocessrequest_x003a_'], 'MM/dd/yyyy')

SP Date and Time field Output Output

The left is the value in the SP DateTime field and the right is the outcome from Automate.

Thanks!

All responses (2)

Answers (1)

Holly_CMS 523 on at

Like (0)

Report

Re: Date Time from SP not coming over correctly

Thank you!
Verified answer

v-bofeng-msft on at

Like (1)

Report
Re: Date Time from SP not coming over correctly

Hi @Holly_CMS ,

Please try:

formatDateTime(addHours(triggerOutputs()?['body/Datetoprocessrequest_x003a_'],-7), 'MM/dd/yyyy')

Best Regards,

Bof