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!

Categories:

Using flows

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

v-bofeng-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!
Hi @Holly_CMS ,

Please try:

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

Best Regards,

Bof

Was this reply helpful? Yes No
Holly_CMS 523 on at

Like (0)

Report
Copy link

Link copied!

Thank you!

Was this reply helpful? Yes No