Answered

SharePoint Date Column shows time when used as a document property in word.

(0) Share

Report

Posted on by AlyssaTsang

Hi All,

I have a SharePoint list that feeds a calculated date column into a Word template. All dates should just be dates with no time included.

So it's set up something like this:

SHAREPOINT LIST

SharePoint List: Date Column 1

Date and Time column, Date only is selected

Sharepoint List: Date Column 2

=IF(WEEKDAY([DateColumn1])=6,[DateColumn1]+3,[DateColumn1]+1)

(Basically, if a date is selected, return the following date, if Friday is selected, return the following Monday)

POWER FLOW

Power flow: Date Column 2 is fed into a custom Document type (Doc Bookings). Doc Bookings Column 2 is set as Date and time, Date only.

WORD

Doc Bookings Column 2 is inserted into the placeholder document via document properties. When the flow triggers it creates a copy of the document with the document properties filled in.

Throughout this workflow only the date shows up. When the word document is generated, it suddently populates a time.

I'm stumped as to where it's getting this time and how to get rid of it?

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

EddieE 4,641 Moderator on at

Like (0)

Report
Copy link

Link copied!

@AlyssaTsang

You could try formatting your date column 2 inside your Flow, eg

Instead of just referencing your field in your flow, use the Expression builder to add this code

formatDateTime( yourDateColumn2NameHere , 'dd/MM/yyyy')

Was this reply helpful? Yes No
AlyssaTsang on at

Like (0)

Report
Copy link

Link copied!

I tried it out but no luck, the time is still popping up with the date. I appreciate the solution, I thought for sure it was going to work. It does eliminate the flow as the cause, I'm thinking it's something to do with my word template or the document type settings.

Was this reply helpful? Yes No
Verified answer

AlyssaTsang on at

Like (1)

Report
Copy link

Link copied!

Strangely, the issue seems to have fixed itself? I had given up on solving the issue for a bit and kept testing and now the time is no longer showing?

Was this reply helpful? Yes No