Looking for PowerObjects? Don’t worry, you’re in the right place! We’ve been part of HCL for several years, and we’ve now taken the final step in our acquisition journey: moving our website to the HCL domain. Nothing else is changing – we are still fanatically focused on Microsoft Business Applications!

PowerObjects Blog 

for Microsoft Business Applications

|

Using Advanced Find to View Appointments and Recurring Appointments in CRM 2011

Post Author: Joe D365 |

Microsoft Dynamics CRM 2011 has introduced the functionality to create recurring appointments within the application. One common business requirement that we have come across at PowerObjects is the ability to view Appointments and Recurring Appointments through Advanced Find or Views. Most business users want to see two views—one that displays Appointments and another that displays Recurring Appointments.

How do we separate those views in Microsoft Dynamics CRM 2011?

You may think that creating two views could by done by adding the filter criteria of Activity Type equals Appointment or Recurring Appointment. However, that won’t fetch the desired results.

This is how you view all Appointments in CRM 2011

When we run the Advanced Find on “Appointments,” Recurring Appointments also appears in the list. The results will display all Appointments and Recurring Appointments in a single view.

But when we run Advance Find on “Recurring Appointments,” it will only show the first one that was created.  This means that the Appointments created in the recurrence series do not get flagged as a recurring appointment.

In order to fulfill this requirement, we can leverage the picklist “Appointment Type” on the Appointment entity. This picklist holds the following values:

  1. Not Recurring
  2. Recurring Exception
  3. Recurring Future Exception
  4. Recurring Instance
  5. Recurring Master

The logical name of this picklist is instancetypecode and the option values are 0 to 4 in the above order.

We can use these values to to filter out Recurring Appointment, hence there is no need need to do a filter on the Recurring Appointment activity type.

For example, if you select Appointment Type as Recurring Instance in Advanced Find, the results will fetch all instances of a Recurring Appointment Instance and this can be saved as a View.

Fetch all insances of recurring appointments in CRM 2011

How to view all CRM 2011 recurring appointments

So there you go! That's how you can view either appointments or recurring appointments separately in Microsoft Dynamics CRM 2011.

Happy CRM'ing!

Joe CRM
By Joe D365
Joe D365 is a Microsoft Dynamics 365 superhero who runs on pure Dynamics adrenaline. As the face of PowerObjects, Joe D365’s mission is to reveal innovative ways to use Dynamics 365 and bring the application to more businesses and organizations around the world.

One comment on “Using Advanced Find to View Appointments and Recurring Appointments in CRM 2011”

  1. Thanks for this article. We have users who created recurring appointments in CRM 2011 or Outlook 2010. Later, when they checked their calendars they recognised they had multiple duplicate copies of these appointments in Outlook or CRM... Any ideas on why these user woluld get these multiple appointments?

    regards,
    Zsolt

PowerObjects Recommends