Track the Last Activity Date for Leads in Dynamics 365 Sales
Sales teams rely on activities such as emails and phone calls to track their interactions with Leads. Adding a Last Activity Date to a Lead gives salespeople an easy way to see when the most recent CRM activity was completed. This requires minimal configuration and can provide useful information for sales teams that consistently track their work through CRM activities.
Security Requirements
Although the resulting field is intended for salespeople, setting it up requires either the System Administrator or System Customizer security role. As with other CRM customizations, test your changes in a sandbox environment before rolling them out to your sales team.
Understanding CRM Activities
Dynamics 365 includes several types of activities, including:
Each activity type has its own table in the CRM database, but they're also grouped together as Activities. These activities share several common fields. They typically include:
- Subject
- Description
- Regarding
- Due date
- Start time
- End time
- Status
Activity statuses can include Open, Completed, Scheduled, or Canceled. The Regarding field is commonly used to connect an activity to a particular CRM record, such as a Lead.
What Happens When You Complete an Activity?
Activities are typically created from the record they're related to. For example, when you create a phone call from a Lead, Dynamics 365 can automatically populate the Lead in the call's Regarding information. You can add a subject and use the description to record important details from your conversation. When the call is finished, select Mark Complete. The activity closes in the Lead's Timeline, and Dynamics 365 automatically records an Actual End date based on when it was completed. That Actual End date gives us the information needed to determine the Lead's most recent completed activity.
Create the Last Activity Date Field
To create the Last Activity Date, go to make.powerapps.com and open the appropriate environment. Open the Lead table and navigate to its columns. Create a new column and configure it as:
- A date-only field
- A rollup field
Rollup fields can perform operations such as Sum, Maximum, or Minimum using information from related child records. For this scenario:
- The Lead is the parent record.
- Activities are the related child records.
- Actual End provides the completion date.
- The rollup will identify the latest Actual End date.
Configure the Rollup
After creating the field, open the rollup configuration. Select Activities as the related table. Next, add a condition so that only completed activities are included. Completed activities are important because they'll have the Actual End value we need. Finally, configure the aggregation to calculate the MAX of Actual End. Using MAX tells Dynamics 365 to find the latest Actual End date among the qualifying activities. Save and close the rollup designer when you're finished.
Add the Field to the Lead Form
Next, open the Lead form and add your new Last Activity Date field. Save and publish the form. You can then open a test Lead containing multiple activities to make sure the field returns the date of its most recently completed activity.
Recalculate the Last Activity Date
Rollup fields run on a scheduled basis and aren't calculated continuously in real time. By default, they're scheduled to calculate overnight. You don't need to wait for the scheduled calculation when testing your new field. From the Lead form, use the calculator button to force the rollup field to recalculate. If your Lead's most recent completed activity occurred today, the field should return today's date.
Use the Last Activity Date in Lead Views
Adding the field to the Lead is only the beginning. To make the information especially useful for your sales team, consider creating a view of open Leads sorted by Last Activity Date. This can help sellers organize Leads according to their recent activity and identify records that may need attention. Instead of opening each Lead and reviewing its Timeline individually, salespeople can use the view to quickly understand which Leads have received recent activity and which may require additional follow-up.
Understand the Limitations of Rollup Fields
Rollup fields provide a relatively simple way to calculate the Last Activity Date, but there are several limitations to consider:
- Rollup fields aren't real-time and are normally calculated on a schedule.
- You can't exclude specific activity types through the rollup conditions.
- More complex conditions may not be possible in the rollup designer.
- The calculation is limited to the related Activities rather than allowing dates from other tables to be incorporated.
These limitations may not matter if all you need is a straightforward date representing the most recent completed CRM activity.
Consider Power Automate for More Advanced Requirements
If your sales process requires more control, Power Automate may be a better approach. Consider Power Automate when you need:
- The Last Activity Date updated in real time
- More advanced filtering conditions
- Greater control over which activity types affect the date
- Information from other tables included in the logic
The rollup approach offers a relatively simple configuration for organizations that don't require those additional capabilities.
Give Salespeople Better Visibility into Lead Activity
A Last Activity Date can give salespeople a simple but valuable way to understand their recent interactions with Leads. By creating a date-only rollup field, filtering it to completed Activities, and calculating the maximum Actual End date, Dynamics 365 can identify the latest completed sales activity associated with each Lead. Adding that field to a Lead view makes the information even more useful, allowing salespeople to organize their Leads around recent activity and better prioritize their follow-up work.
