Share via

MS Form creating timestamp in Excel (via Power Automate) 1 hour behind.

Anonymous
2024-04-09T07:19:50+00:00

Good morning,

I'm sure this question has been asked 100 times.

I'm using Microsoft Forms as a way of signing into my office, for colleagues and students. Using Power Automate, it creates an entry in Excel.

Due to the clocks going back 1 hour last week, the time in entries, which takes the information from the "submission time" is 1 hour behind at the moment. The time format in Excel has the * next to it, so it should be current. What else can I do?

Here is a copy of the flow in Power Automate.

Microsoft 365 and Office | Microsoft Forms | Other

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2024-04-09T08:03:36+00:00

    Following on from the above entry, I found a workaround.

    0 comments
  2. Anonymous
    2024-04-09T08:12:23+00:00

    Hello Benn P,

    Thank you for letting us know that you've found a workaround for the timestamp issue caused by the daylight saving time change. It's great that you were able to resolve the problem yourself. I appreciate you sharing your experience, as it will help others facing similar issues.

    If you encounter any related issues or have additional questions in the future, feel free to reach out.

    Best Regards, Seun

    0 comments