cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Nick_M
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. 

 

3 REPLIES 3
Highlighted
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.

 

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

 

 

Nick_M
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 

Nick_M
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

Announcements
thirdimage

Power Automate Community User Group Member Badge

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

firstImage

Incoming: New and improved badges!

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

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Top Kudoed Authors (Last 30 Days)
Users online (5,042)