Others

Fix Microsoft Forms Submission Timestamps in Power Automate Emails

Huma Ashraf ChHuma Ashraf Ch Nov 14, 2026 868 views

Question details

The user needs Microsoft Forms submission times in Power Automate email notifications to display in the correct local time zone.

Fix Microsoft Forms Submission Timestamps in Power Automate Emails
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.
Before you start

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.

Solution 1Recommended

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.

1
Open the flow

In Power Automate, select My flows, open the flow that sends the Forms notification, and select Edit.

2
Locate the submission time

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.

3
Add the conversion action

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.

4
Choose the local time zone

Set Destination time zone to the recipients' required time zone, such as Pacific Standard Time, and choose an appropriate Format string.

5
Update and test the email

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.

Convert the submission time before sending the email
Use the submission timestamp: Do not substitute utcNow() for the submission time: it represents the time the expression runs, which may differ from when the form was submitted. A named destination time zone accounts for applicable daylight saving rules.
Free Microsoft Office alternative

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.

Review exported form responses in WPS SpreadsheetsOpen and edit Microsoft Excel XLSX filesUse a familiar interface for documents, spreadsheets, and presentationsWork with a free, lightweight office suite
microsoft office alternative - wps office

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.