web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / business rule canvas &...
Power Apps
Answered

business rule canvas & active directory: escalation pattern based on age of record

(0) ShareShare
ReportReport
Posted on by 110

Hi, would it be possible to have a business rule for the following scenario?

 

A record has 4 columns: 1. Name of Issue, 2. AssignedTo (email), 3. Status & 4. DateRecorded (assume it is filled by ETL)

 

Is it possible to do the following:

 

If DateRecorded is 7 days Outstanding Status, change AssignedTo to the Manager of the AssignedTo person as per active directory? & 7 days Outstanding later assign it to the Manager of the Manager..?

 

Thanks.

I have the same question (0)
  • Ram Prakash Duraisamy Profile Picture
    5,846 Super User 2026 Season 1 on at

    Hello @fess,

     

    As per OOB Behavior, this type of behavior is not possible in Business Rule. You can write JavaScript to achieve this behavior easily.

     

    Please find my YouTube Channel for Basic JS (https://www.youtube.com/watch?v=x8kYNCkikgs&t=14s)

     

    Please mark as Answer if it is helpful and provide Kudos


    Subscribe : https://www.youtube.com/channel/UCnGNN3hdlKBOr6PXotskNLA
    Blog : https://microsoftcrmtechie.blogspot.com

  • Verified answer
    Drew Poggemann Profile Picture
    9,287 Most Valuable Professional on at

    Hi @fess ,


    I would personally do this through a Power Automate flow so you don't need to be on the user interface to accomplish and behind the scenes it would make these changes.  You could have the flow run daily to review the records in question and change the AssignedTo to the Manager.

     

    As @rampprakash mentioned, not available in OOB business rules.

     

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the April Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
Vish WR Profile Picture

Vish WR 638

#2
Haque Profile Picture

Haque 317

#3
WarrenBelz Profile Picture

WarrenBelz 315 Most Valuable Professional

Last 30 days Overall leaderboard