Skip to main content

Notifications

Microsoft Dynamics 365 | Integration, Dataverse...
Suggested answer

Filter records in Calendar Control V2 in Model-Driven

Posted on by 15

Hello, I have a custom table 'Assignments', here all assignments are related to one technician (1, 2, 3 and 4) and to one type ('placing', 'delivery', 'measuring' and 'after sales service'). 'Technician' and 'Type' are a look up field in the 'Assignments'-table to the custom tables 'Technicians' and 'Assignment Types'. I added the Calendar Control V2 to the View of the 'Assignments'table to show the assignments in a calendar view.

I want to filter the records in this calendar on two possible values: 'technicians' (all, techn 2, techn 2, techn 3 and techn 4) and 'assignment type' (all, 'placing', 'delivery', 'measuring' and 'after sales service').

The standard filter-icon in the top right corner of my model-driven can't be changed without an error while using this CalendarControl. Creating a different view for every occasion wouldn't work as I would need 25 or so views to cover all occasions.

I was looking towards the filter activity-type as used in the standard-table activity (see screenshot). Is there a way I can add this to my custom-table? 

 

Using this CalendarControlV2 the filter icon is still visible, but i would rather not use this as 15+ clicks need to be done te set up this filter. I have a PCF calendar installed as well in my environment, but this doesn't show the filter-icon in model driven.

 screencapture.png

  • Suggested answer
    LuHao Profile Picture
    LuHao 40,872 on at
    RE: Filter records in Calendar Control V2 in Model-Driven

    Hi partner,

    You mean, you want to have an option filter for a view with customizable options like in the Activity view?

    Unfortunately, it is impossible.

    I believe the most appropriate solution is Power Bi report, which has the functionality you want to switch reports between multiple different conditions of data.

    Alternatively, similar functionality can be achieved through SSRS.

    In summary, views are not suitable for presenting data sets with 25 different conditions, so please consider using reports.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

New! Quick response templatesâš¡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,228 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,056 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans