web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Date and time notation
Power Automate
Unanswered

Date and time notation

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

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. 

 

Categories:
I have the same question (0)
  • prabir Profile Picture
    Microsoft Employee on at

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

     

    Capture.PNG

     

    You can refer to the Logic App expressions documentation at https://aka.ms/logicexpressions for the list of supported functions.

    Date functions can be found at https://docs.microsoft.com/en-us/rest/api/logic/definition-language#date-functions

     

    You can refer to MSDN for custom format options. https://msdn.microsoft.com/library/8kb3ddd4%28v=vs.110%29.aspx

     

     

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

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

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    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?

     

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
David_MA Profile Picture

David_MA 124 Super User 2026 Season 1

#2
Ellis Karim Profile Picture

Ellis Karim 52 Super User 2026 Season 1

#3
Haque Profile Picture

Haque 50

Last 30 days Overall leaderboard