Skip to main content

Notifications

Power Automate - General Discussion
Answered

Add hours to modified column

(0) ShareShare
ReportReport
Posted on by 4,177

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

 

  • Verified answer
    jinivthakkar Profile Picture
    jinivthakkar 4,177 on at
    Re: Add hours to modified column

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

     

    addHours(outputs('Get_item')?['body/Modified'],+1)
     
     
  • tom_riha Profile Picture
    tom_riha 9,930 on at
    Re: Add hours to modified column

    Hello @jinivthakkar,

    the expression should have the following format, 

    addHours(<ModifiedDate>,2)
    
    addHours(<ModifiedDate>,4)
    
    addHours(<ModifiedDate>,8)

     <ModifiedDate> is the 'Modified' dynamic content.

  • jinivthakkar Profile Picture
    jinivthakkar 4,177 on at
    Re: Add hours to modified column

    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 !

  • tom_riha Profile Picture
    tom_riha 9,930 on at
    Re: Add hours to modified column

    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,636

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,942

Leaderboard