I want to add the current date/time to a date/time column.
What format do Microsoft Lists require date/time column values to be in when adding them from Power Automate?
I am using the Convert time zone
action to convert utcNow()
to AEST (UTC +10 hours).
This format string works fine if the column is date only (no time):
yyyy-MM-dd
However, I don't know what format string to use when the column is date AND time.
I can see that the For a selected file
action in a flow returns values like these for date/time columns:
2022-09-29T06:30:00Z
In this example, the time is displayed in the SharePoint list as:
29/09/2022 16:30 [ representing the date/time in AEST (UTC +10 hours) ]
I've tried to find the answer reading articles like these but had no luck:
Standard date and time format strings
2022-09-29T06:30:00Z
format as well as you can direct passutcNow()
. Displayed date and time in SharePoint can be different based on regional settings. Check this and this for more information.update item
with the following values and they both added the correct value:formatDateTime(utcNow(),'yyyy-MM-ddThh:mm:ss')
or justutcNow()
. You can add this as an answer if you like and I can accept it.