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):
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:
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: