cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

Forms and Flow having different Time zones

I built a simple flow using Forms to connect with an Excel table, I need the time stamp from the flow to be 100% accurate in terms of my timezone as I cross this data with data from a call software. I believe I am getting UTC 0:00 in Excel and I am UTC-5.

IS flow issue.PNG

This is what I get on Excel and is definitely not UTC-5 please help!

IS flow issue excel.PNG

2 ACCEPTED SOLUTIONS

Accepted Solutions
Highlighted
Super User II
Super User II

Re: Forms and Flow having different Time zones

You'll want to convert time within the Flow to adjust the time before adding it to the table. 

working-with-datetimes-formats👨🏻‍💻 If this reply answers your question or solves your issue, please ACCEPT AS SOLUTION ☑️. If you find this reply helpful, please consider giving it a LIKE 👍.

View solution in original post

Highlighted
Community Support
Community Support

Re: Forms and Flow having different Time zones

 

Hi @Nick_89 ,

 

In addition to using the Convert time zone action to convert time zones, you could also use the addHours() function to get the expected time.

Like:

79.PNG

Expression reference:

addHours(outputs('Compose'),-5,'MM/dd/yy HH:mm:ss')

Please take a try.

 

Best Regards,

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
Highlighted
Super User II
Super User II

Re: Forms and Flow having different Time zones

You'll want to convert time within the Flow to adjust the time before adding it to the table. 

working-with-datetimes-formats👨🏻‍💻 If this reply answers your question or solves your issue, please ACCEPT AS SOLUTION ☑️. If you find this reply helpful, please consider giving it a LIKE 👍.

View solution in original post

Highlighted
Community Support
Community Support

Re: Forms and Flow having different Time zones

 

Hi @Nick_89 ,

 

In addition to using the Convert time zone action to convert time zones, you could also use the addHours() function to get the expected time.

Like:

79.PNG

Expression reference:

addHours(outputs('Compose'),-5,'MM/dd/yy HH:mm:ss')

Please take a try.

 

Best Regards,

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

Tech Marathon

Maratón de Soluciones de Negocio Microsoft

Una semana de contenido con +100 sesiones educativas, consultorios, +10 workshops Premium, Hackaton, EXPO, Networking Hall y mucho más!

Top Solution Authors
Top Kudoed Authors
Users online (5,663)