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 BPA Solution

The North52 BPA 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's Data Packager helps move configuration data between instances

North52 Data Packager is an add-on for North52 Business Process Activities which enables you to easily move data from one instance to another.  Users simply select the records they would like to package up and North52 Data Packager adds the data to a data package sheet, ready for export. Moving the records to another instance requires the package solution to be imported and ‘unpacked’ on the target instance.

North52 Data Packager is ideal for:

  • Moving Dynamics configuration records
  • Copying Dynamics Portal records
  • Distributing demonstration data

Learn more about the North52 Data Packager