cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Kirill-PRG
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
v-alzhan-msft
Community Support
Community Support

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
v-alzhan-msft
Community Support
Community Support

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

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
MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are Your Ready?

Test your skills now with the Cloud Skill Challenge.

Top Solution Authors
Users online (90,392)