In this business scenario we want to save an Account record's last Category choice. To do this, we have created a custom field called Previous Category.

Whenever the field Category is changed we want the previous value to be stored in the custom field Previous Category.  We use the PriorValue function to achieve this.

Note: For this example we have created a custom field called Previous Category which has the same optionset values/numbers as the field Category

North52 Decision Suite

The North52 Decision Suite solution works like this:

  • A formula is created that will trigger whenever the Category field is updated on an Account record
  • When triggered, the formula will update the Previous Category field with the previous value of Category 

Setup Decision Table

  • Navigate to Settings > N52 Formula
  • Create a new formula, setting the following values in the Formula Guide:
    • Source Entity set to Account
    • Set Formula Type to Save - Perform Action
    • Select the Decision Table editor
  • Change the Name of the formula to Save an Accounts last Option Set choice
  • Expand the Source & Target
    • For Source Property select Category
  • Expand Deployment Settings
    • For Pipeline Stage select Pre-Operation (Synchronous) 
  • In the Decision Table editor 
    • Select cell A2
      • Go to the Source tab
      • Expand Source and find and select Previous Category
    • Select cell A4
      • Copy and paste the following function:
  • Click Save


  • An an Account record, change the Category field and save. You will see the Previous Category field change to the previous category value
    • Note it is advised to add the custom field Previous Category to the Account form for easy access

  • EntityMulti

Did you know?

North52 Decision Suite works with vanilla Common Data Service instances

The North52 Decision Suite works with Common Data Service instances which have not had any Microsoft 1st Party apps applied (Field Service, Customer Service, Sales Enterprise, etc). This means you can use our no-code advance business rules engine in your custom Model Driven and Canvas Power Apps! 

It is the same solution which has been powering Microsoft Dynamics 365 CR/CE for many years. You get a mature, robust solution with proven capabilities (over 500 functions) that allows you to build complex decision logic for use in your custom apps.

Learn more about the North52 Decision Suite or contact our team for more information