Answered

MS Flow pulling wrong Date/Time

(1) Share

Report

Posted on by leslie_rivera

373

I have a MS flow set up to end an email when an item is created or modified in a SharePoint list. The column date and time format with Standard display format.

In the Flow I use a Compose action with the following expression:

The SharePoint list shows the following time:

Flow is showing a different time:

What am I missing? Any assistance in this would be greatly appreciated!!

Categories:

General topics

All responses (5)

Answers (1)

Sort by

RezaDorrani 12,145 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @leslie_rivera

flow only works with dates and times in UTC format. So when it reads the date from SharePoint it gets it in UTC.
you would need to use expressions.

check this flow expression video series -

https://aka.ms/learnexpressions

--------------------------------------------------------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

Thanks,
Reza Dorrani, MVP
YouTube
Twitter
leslie_rivera 373 on at

Like
a
(0)

Report
Copy link

Link copied!

I thought thats what I was doing above. Do you have an example?
RezaDorrani 12,145 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @leslie_rivera

Its in the link I provided.

Here is the exact point - https://youtu.be/k-yIhdseTQE?t=1336

--------------------------------------------------------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

Thanks,
Reza Dorrani, MVP
YouTube
Twitter
leslie_rivera 373 on at

Like
a
(0)

Report
Copy link

Link copied!

Sorry I need a little more hand holding than go watch this video.. thanks though.
Verified answer

leslie_rivera 373 on at

Like
a
(2)

Report
Copy link

Link copied!

I found the solution using Convert time zone

Base time = the column in my list "Start Time"
Sourcetime zone = UTC
Destination time zone = the time zone I am in which is MST
Format string = how I want the output to look like