Unanswered

Word auto populate not populating date and time column correctly

(0) Share

Report

Posted on by cable

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?

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (0)

Sort by

Andrew_J 1,962 Moderator on at

Like (0)

Report
Copy link

Link copied!

@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

Was this reply helpful? Yes No
cable 2 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No