Flow to change date but keep time of a SharePoint list column

(0) Share

Report

Posted on by snrldn

Hello there 🙂

I could use some help with the following task:

We want to edit a Sharepoint list date/time column with a flow, but only change the date and keep the time that is already in the column. So for example if theres a "Due Date" column, with three Elements

. Due Date

Element 1 - March 6th 2024 05:00

Element 2 - March 6th 2024 05:30

Element 3 - March 6th 2024 06:00

We want to update the date to a specific new date but keep the time as it is. So for example, it would be like:

. Due Date

Element 1 - April 17th 2024 05:00

Element 2 - April 17th 2024 05:30

Element 3 - April 17th 2024 06:00

Is there a way to do that with any of the formatDateTime functions? I've been trying out all kinds of combinations but I either get an error message (wrong string/datetime format) or have to use a timestamp which would edit the preexisting times. AM I missing something? Any help would be appreciated!

Kind regards,

Sarah

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (0)

v-yueyun-msft on at

Like (0)

Report

Hi , @snrldn

Do you mean you want to format the Date in DateTime field.

This is the return from the Get items action:

This is my test flow:

formatDatetime( formatDatetime( items('Apply_to_each')?['StartDate'] , '2024-04-27THH:mm:ssZ') , 'MMMM dd\t\h yyyy HH:ss')

The result is as follows:

Best Regards,

Yueyun Zhang

Was this reply helpful? Yes No
snrldn 2 on at

Like (0)

Report

Thanks for the reply 🙂

However, my goal was to target only the date and not the time, because the times are different in each row, so I would need a flow for each row to do that. I was curious whether it was possible to target all dates in the table only, without changing the current time value. I'm afraid that it's not possible (as per my current knowledge).

Thanks again though for your answer, I appreciate it 🙂

Was this reply helpful? Yes No