cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper I
Helper I

How to add certian time to date with flow

Hi there,

I am trying to maky flow, where I after filling a form I will make an item in the list with dates which were given in form and I will add certain time to these dates. It is my work arounf to make events in SharePoint calendar which will have all vacations.

 

I have problem with time zones I guess, because right now my flow is almost correct, as long as in log I have corect Outputs, but unfortunately data are not correct in the list.

 

This is my Output:

 

output.png

 

And this is data in SharePoint list:

 

data-list.png

 

Here is my flow:

flow.pngflow1.png

 

 

I am not sure, where I have mistake... I checked SharePoint timezone and it is UTC+1...

 

Thank you for help.

Kirill

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support
Community Support

Re: How to add certian time to date with flow

Hi @Kirill-PRG ,

 

Do you mean you want to cut back 2 hours in the sharepoint list date which is created from the form?

 

If yes, you could refer to my steps below to cut back 2 hours:

1.png

 

The expression for the Od column should as below and please replace the Convert time zone with yours:

addHours(body('Convert_time_zone'),-2)

The expression for the Do column should as belowand please replace the Convert time zone with yours:

addMinutes(addHours(body('Convert_time_zone'),21),59)

 

Please let me know if your problem could be solved.

 

Best regards,

Alice       

 

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
Highlighted
Community Support
Community Support

Re: How to add certian time to date with flow

Hi @Kirill-PRG ,

 

Do you mean you want to cut back 2 hours in the sharepoint list date which is created from the form?

 

If yes, you could refer to my steps below to cut back 2 hours:

1.png

 

The expression for the Od column should as below and please replace the Convert time zone with yours:

addHours(body('Convert_time_zone'),-2)

The expression for the Do column should as belowand please replace the Convert time zone with yours:

addMinutes(addHours(body('Convert_time_zone'),21),59)

 

Please let me know if your problem could be solved.

 

Best regards,

Alice       

 

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Highlighted
Helper I
Helper I

Re: How to add certian time to date with flow

Hi @v-alzhan-msft ,

 

Thank you for your help. It works! Thank you to introducing me expressions in flow, never used them, but now I can see it is very useful 🙂

 

Have a nice day!

Helpful resources

Announcements
firstImage

Super User Program Update

Three Super User rank tiers have been launched!

firstImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

firstImage

New & Improved Power Automate Community Cookbook

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

thirdimage

Power Automate Community User Group Member Badge

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

Top Solution Authors
Top Kudoed Authors
Users online (7,759)