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