Skip to main content
Community site session details

Community site session details

Session Id :
Power Automate - Building Flows
Unanswered

Word auto populate not populating date and time column correctly

(0) ShareShare
ReportReport
Posted on 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 at
    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 Super User 2025 Season 1 on at
    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

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!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 497 Super User 2025 Season 1

#2
David_MA Profile Picture

David_MA 436 Super User 2025 Season 1

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 244 Super User 2025 Season 1