web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Power automate convert...
Power Automate
Answered

Power automate convert time - what am I doing wrong please?

(0) ShareShare
ReportReport
Posted on by 11

Hi all,

I have done some searching and found the following thread - https://powerusers.microsoft.com/t5/General-Power-Automate/MS-Flow-pulling-wrong-Date-Time/td-p/781231 - which I initially thought would solve my problem, but it hasn't.

Power Automate seems to pull UTC. I would like it to pull my local time zone, so set up this flow (between "Get Response details" (from a form) and "Add a row into a table" (excel), but it doesn't seem to do anything - the time that appears in the table still appears to be UTC. I am obviously doing something wrong.

This is the flow:

Hendrix_0-1631247307879.png


There's no issue with the time format - it simply shows the time 12 hours earlier (eg 4:07 rather than 16:07).

Do I have the Convert time zone flow in the right place in the workflow - don't want to fiddle around with it too much and break something else, 'cos I am a genuine newbie.

Any help appreciated.

Phil

Categories:
  • Hendrix Profile Picture
    11 on at

    Edit. I also tried moving the "Convert tiem zone" to after the "Add row into table", but nothing changed.

    I'm am completely stuck.

  • Verified answer
    Hendrix Profile Picture
    11 on at

    In the hope that this will help someone else in future, I hadn't fed the output of "Convert Time" into "Add a Row into a table" - time was still Submission Time, rather than Converted Time. All is good once that was fixed.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Leaderboard > Power Automate

#1
Mohsin Ali Profile Picture

Mohsin Ali 289

#2
11manish Profile Picture

11manish 282 Super User 2026 Season 2

#3
Henil Profile Picture

Henil 119

Last 30 days Overall leaderboard