What format do Microsoft Lists require date/time column values to be in when adding them from Power Automate?

Question

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:

Datetime

Standard date and time format strings

Custom date and time format strings

How to customize or format Date and Time values in a flow

Answer 1

SharePoint always stores the date & time values in UTC format and displays the date & time values in lists based on regional settings of site.

You can pass values to date & time column in 2022-09-29T06:30:00Z (formatDateTime(utcNow(),'yyyy-MM-ddThh:mm:ss')) format as well as you can direct pass utcNow() as value from Power automate flow.

For more information, check this: Incorrect time showing in SharePoint List send by Flow