cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
jinivthakkar
Super User
Super User

Add hours to modified column

Hi All,

 

I have a SharePoint list in which different travel request are submitted and if request is not approved in two hours I need to send reminder email but I just can't get the formula to add hours right.

 

I am getting this value from modified column - 2020-11-17T12:53:23Z and I just need to add two hours and need formula for the same.

 

I have three level of approvals, if request approved at level 1 then check if level approved at level 2 in the next 4 hours else send reminder email, if request not approved in next 8 hours need to send another reminder email and so.

 

Hence I need to add 2,4,8 hours to modified column of SharePoint list

 

Please help

 

1 ACCEPTED SOLUTION

Accepted Solutions
jinivthakkar
Super User
Super User

I did get item, then initalize variable and then in set variable I added this expression :

 

addHours(outputs('Get_item')?['body/Modified'],+1)
 
 

View solution in original post

4 REPLIES 4
tom_riha
Super User
Super User

Hello @jinivthakkar ,

there's addHours() expression in Power Automate, you'll use the modified date as the first parameter and the 2nd parameter is how many hours you'd like to add (2 or 4 or 8...)

image.png



[ If I have answered your question, please Accept the post as a solution. ]
[ If you like my response, please give it a Thumbs Up. ]

[ I also blog about Power Automate solutions even for non-IT people. ]

Hi Tom, 

 

I am aware of the addHours() function and I also tried using it but it keeps giving me error - Invalid expression

 

So I need help in building the expression which addes 2,4 etc hours to modified column.

 

Thanks !

Hello @jinivthakkar,

the expression should have the following format, 

addHours(<ModifiedDate>,2)

addHours(<ModifiedDate>,4)

addHours(<ModifiedDate>,8)

 <ModifiedDate> is the 'Modified' dynamic content.



[ If I have answered your question, please Accept the post as a solution. ]
[ If you like my response, please give it a Thumbs Up. ]

[ I also blog about Power Automate solutions even for non-IT people. ]
jinivthakkar
Super User
Super User

I did get item, then initalize variable and then in set variable I added this expression :

 

addHours(outputs('Get_item')?['body/Modified'],+1)
 
 

Helpful resources

Announcements
2022 Release Wave 1 760x460.png

2022 Release Wave 1 Plan

Power Platform release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Users online (1,325)