Showing results for 
Search instead for 
Did you mean: 
Level: Powered On

Date and time notation

Hello, i have created an powerapp, with a flow. The flow will be triggerd when a new item is created in a sharepoint list. 


Im from the Netherlands and our notations is different from USA notation.

With Begintijd(Starttime) and Eindtijd(Endtime) Those values will be written to a sharepoint list. 

When i select the date of today and 15:00 (3pm) the right notation and time is written to sharepoint. 

But when the flow become active and the email will be send, the flow use USA notation and there is a time differents from an hour.


Can somebody help me to set the right date notation and the right time. 


Power Automate Staff prabir
Power Automate Staff

Re: Date and time notation

By using compose action and formatDateTime function you should be able to change the format of date and time.




You can refer to the Logic App expressions documentation at for the list of supported functions.

Date functions can be found at


You can refer to MSDN for custom format options.



Level: Powered On

Re: Date and time notation

Thank yo very much i just fixed the date format, but i have no clue of fixen the time difference 

Level: Powered On

Re: Date and time notation

I found out how addhour does work. But if i understand correctly each time, the time change from summer time to winter time and from winter time to summer time i have to change my flow? Is there no other sollution?



Helpful resources


New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!


Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!


Incoming: New and improved badges!

We've given our badges an overhaul and also added some brand new ones!


Microsoft Learn

Learn how to build the business apps that you need.


Power Platform World Tour

Find out where you can attend!


Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Top Kudoed Authors (Last 30 Days)
Users online (4,263)