Fix Microsoft Forms Submission Timestamps in Power Automate Emails
Question details
The user needs Microsoft Forms submission times in Power Automate email notifications to display in the correct local time zone.

- Product
- Microsoft Forms and Power Automate
- Device & OS
- not provided
- Scenario
- A flow sends an email notification containing a form submission time.
- Observed behavior
- The time in the email is several hours ahead of or behind local time because the timestamp is in UTC.
Open the affected flow in Power Automate and identify the submission-time value used in its email action. Confirm that the value is in UTC and determine the local time zone in which recipients should see it.
Convert the submission time before sending the email
Use Power Automate's Convert time zone action to display the Forms submission timestamp in the desired local time zone.
In Power Automate, select My flows, open the flow that sends the Forms notification, and select Edit.
Find the Forms submission-time dynamic content used by the email action. If needed, add the Microsoft Forms Get response details action and select the form and response ID.
Before the email action, select Add an action, search for Convert time zone, and select it. Set Base time to the Forms submission-time value and Source time zone to UTC.
Set Destination time zone to the recipients' required time zone, such as Pacific Standard Time, and choose an appropriate Format string.
In the email action's body, replace the original timestamp with the converted time output from Convert time zone. Select Save, submit a test response, and check the time in the resulting email.

Work with Forms exports in WPS Office
WPS Office is a free, lightweight alternative for working with Office files. Its familiar interface and format compatibility make it easy to move existing documents and spreadsheets into WPS. It does not change Microsoft Forms timestamps or Power Automate flows.

Frequently Asked Questions
Why is the submission time in my email several hours off?
The timestamp may be in UTC while you expect local time. In the flow, add Convert time zone before the email action and convert the submission-time value from UTC to the required destination time zone.
Which timestamp should I use as the base time?
Use the Forms submission-time dynamic content, not utcNow(). The latter returns the time the expression runs and may not match the actual submission time.
Will the conversion handle daylight saving time?
Select the appropriate named destination time zone in Convert time zone rather than applying a fixed hourly offset. The conversion uses the applicable time-zone rules for the timestamp.
How do I put the converted time into the email?
Open the email action in the flow editor, remove the original submission-time value from the message, and insert the converted time output from the Convert time zone action using dynamic content.




