cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
leslie_rivera
Helper I
Helper I

MS Flow pulling wrong Date/Time

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:

compose.png
 
 

The SharePoint list shows the following time: starttime.png

 

Flow is showing a different time: compose2.pngcompose2.png

 

 

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

1 ACCEPTED SOLUTION

Accepted Solutions
leslie_rivera
Helper I
Helper I

I found the solution using Convert time zone

leslie_rivera_0-1609364582176.png

 

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

View solution in original post

5 REPLIES 5
RezaDorrani
Dual Super User II
Dual Super User II

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

I thought thats what I was doing above. Do you have an example?

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
Helper I
Helper I

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

leslie_rivera
Helper I
Helper I

I found the solution using Convert time zone

leslie_rivera_0-1609364582176.png

 

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

View solution in original post

Helpful resources

Announcements
MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

secondImage

Are Your Ready?

Test your skills now with the Cloud Skill Challenge.

Top Solution Authors
Users online (32,503)