cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

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
Power Automate
Power Automate

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

 

 

Anonymous
Not applicable

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

Anonymous
Not applicable

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
PP Bootcamp Carousel

Global Power Platform Bootcamp

Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.

secondImage

Power Platform Community Conference On Demand

Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!

MPA Community Blog

Power Automate Community Blog

Check out the community blog page where you can find valuable learning material from community and product team members!

Top Kudoed Authors
Users online (3,542)