Unanswered

Word auto populate not populating date and time column correctly

Like (0) Share

Report

Posted on 18 Apr 2024 22:11:05 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?

I have the same question (0)

All responses (2)

Answers (0)

cable 2 on 18 Apr 2024 at 22:52:48

Like (0)

Report

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

Was this reply helpful? Yes No
Andrew_J 1,962 Moderator on 18 Apr 2024 at 22:26:52

Like (0)

Report

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

Was this reply helpful? Yes No