Hi @CU06110921-0
I encountered similar questions back in October and wrote a blog post about it.
SharePoint STORES dates in UTC. I am referring to the use of the Date type column in SharePoint.
A "Z suffix" at the end of a date-time string indicates UTC, example: 2024-10-05T08:15:34Z.
Your first concat() expression contains the Z suffix indicating UTC.
concat(
formatDateTime(triggerBody()?['date'], 'yyyy-MM-dd'), 'T',
string(triggerBody()?['text_3']), ':',
string(triggerBody()?['text_4']), ':00Z'
)
In your second concat() expression there is no Z suffix. Without the ‘Z’ suffix, SharePoint would interpret the date-time based on the site’s configured time zone (for example in an OData filter query inside a Get Items action).
You could simplify both of your expressions to:
formatDateTime(triggerBody()?['date'], 'yyyy-MM-ddT00:00Z')
formatDateTime(triggerBody()?['date'], 'yyyy-MM-ddT00:00')
The SharePoint site itself DISPLAYS dates based on to the site’s Regional settings.
Power Automate READS dates from SharePoint in UTC.
Power Apps DISPLAYS the date and time based on the PC’s local time zone settings, which may cause different users to see different local times for the same date.
See: Why Are My SharePoint Dates Wrong in Power Apps and Power Automate? – Ellis Karim's Blog
Ellis
https://elliskarim.com/
