Views:

Scenario Overview 

In this scenario, we want our Sale Manager to be brought in automatically to important Opportunities. 

We will create a formula that adds our Sales Manager into the Team for any Opportunity that has an Est Revenue greater than 1 euro. 

This formula will also remove our Sales Manager from this Team access if the Est. Revenue goes below 1 million 1 euro. 

North52 Decision Suite Solution

The North52 Decision Suite solution works like this:

  • A formula of type 'Save - Perform Action' is created on the Opportunity entity
  • This Formula will be triggered whenever an Opportunity is created or the Est. Revenue field is updated
  • The formula will add the User John Grace to the Team Access for the Opportunity record if the Est Revenue is greater than 1 million euros
  • It will also remove user John Grace if the Est Revenue goes below 1 million euros

North52 Decision Suite Steps

  • Create a new formula of type 'Save - Perform Action'
  • Set the Mode to 'Server Side'
  • Set Event to 'Create & Update'
  • Set Source Entity as 'Opportunity '
  • Set Source Property to 'Est. Revenue'
  • Click into the Formula Editor canvas
  • Copy and paste the formula below into the Formula Editor
  • Click Save


Formula

if(Containsdata([opportunity.owningteam.name.?]),
  If ([opportunity.estimatedvalue] > 1000000,
    AddUsersToTeam([opportunity.owningteam.name.?],
          FindValueQuickId('systemuser','John Grace')),
    RemoveUsersFromTeam( [opportunity.owningteam.name.?],
           FindValueQuickId('systemuser','John Grace'))) ,
 
  'NoOp'
) 

Did you know?

Over 300 customers use North52!

Join over 300 organizations worldwide who trust North52 to drive their digital transformation into the future:

Serious Power without Code:  Easily build business rules, tests and data packages using our point-and-click editors. Even the most complex business rules are easily configured.

Build Fast:  We’ve built the North52 tools with our user’s productivity in mind – up to 10x faster than writing custom code.

Awesome Support:  We take pride in providing world class support to our customers and partners, ensuring you are successful with North52.

Future Proof:  We ensure your business rules and tests that you configure today, will continue to work with the ever changing Dynamics 365 platform.

Learn more about the North52 Decision Suite

Keywords: FindValue, FindValueQuickId, ContainsData, RemoveUsersFromTeam, AddUsersToTeam, Formula Manager