Power Platform Community Forum Thread Details

Hi, I have been playing with this for some time and I Don't know what is the source of the issue to solve it.

I have SharePoint list which has a start date and time field

I have a flow which reads these fields when an item modified or created and via API populates the value on another database.

I need to format the date to be able to put it on the database

this is the formula I use to format time

formatDateTime(triggerBody()?['Date'],'hhmm')

the problem is the output of this formula is 1 hour more than what I put in the list

for example I put 3:00pm and the formatDateTimeShows 4:00pm

and during daylight sayving it adds 2 hours

for example I put 3:00pm and the formatDateTimeShows 5:00pm

this is the setting I have in my site

Any Idea how to fix this

Categories:

Format Date and Time changes time