Add hours to modified column

(0) Share

Report

Posted on by jinivthakkar

4,187

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

Categories:

General topics

I have the same question (0)

All responses (4)

Answers (1)

Sort by

tom_riha 10,187 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

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...)

Was this reply helpful? Yes No
jinivthakkar 4,187 on at

Like (0)

Report
Copy link

Link copied!

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 !

Was this reply helpful? Yes No
tom_riha 10,187 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!
Hello @jinivthakkar,
the expression should have the following format,
addHours(<ModifiedDate>,2) addHours(<ModifiedDate>,4) addHours(<ModifiedDate>,8)
<ModifiedDate> is the 'Modified' dynamic content.

Was this reply helpful? Yes No
Verified answer

jinivthakkar 4,187 on at

Like (0)

Report
Copy link

Link copied!

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

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

Was this reply helpful? Yes No