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

Community site session details

Session Id : f7TgmBumhJrtbI3XKtuDTr
Power Automate - Building Flows
Unanswered

Word auto populate not populating date and time column correctly

Like (0) ShareShare
ReportReport
Posted on 18 Apr 2024 22:11:05 by 2

I’ve set up a flow on my sharepoint list when every time a new item is created, it auto populates a document and attaches it to the list item. Part of the fields on the doc being populated are date and time fields.

 

Every time I run the flow, the time inputed into the word doc is always 12 hours behind the time from the list entry (e.g. 19/04/2024 9:00am displays as 18/04/2024 9:00pm).

 

The site regional settings are in line with my time zone (UTC +12:00 Auckland), and my personal onedrive settings also reflect this. 

 

Previously this was doing 7 hours ahead, but I changed the timezone for the site to NZ and it is now doing this. 

 

Is there anything I can do? 

  • cable Profile Picture
    2 on 18 Apr 2024 at 22:52:48
    Re: Word auto populate not populating date and time column correctly

    Okay so I’ve tried doing convert timezone actions for the list fields, the list itself, and the word doc, and they all produce the same result - when the doc is generated I can tell it’s in UTC because it has the z on the end of the date 

  • Andrew_J Profile Picture
    1,962 Moderator on 18 Apr 2024 at 22:26:52
    Re: Word auto populate not populating date and time column correctly

    @cable 

     

    Maybe add a convert time zone app at the start of you flow and see if this makes a difference. I am in the UK so it does not matter to much for us.

     

    Andrew

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

Announcing our 2025 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for…

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 497 Super User 2025 Season 2

#2
David_MA Profile Picture

David_MA 436 Super User 2025 Season 2

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 244 Super User 2025 Season 2

Loading complete