cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
mvdb
Advocate I
Advocate I

Filter records in Calendar Control V2 in Model-Driven

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.

 

 

 

 

mvdb_0-1618921157618.png

 

2 REPLIES 2
dpoggemann
Super User
Super User

Hi @mvdb,

 

I just setup the exact scenario in my instance and I receive an error every time I go into the filter when having the calendar control v2 active.  The error I receive is the following (even without adding any additional criteria):

Screen Shot 2021-04-20 at 5.42.42 PM.png

 

This is a bug and you should open a case with Microsoft but I was able to work around this issue.

 

If I put in "read only grid" and enter all of the filter criteria then when I put into calendar mode with the V2 control it worked successfully to show in the calendar grid with my records that were filtered.

 

Hope this helps!  Please accept if answers your question or Like if helped in some way.

 

Thanks,


Drew

 

EricRegnier
Super User
Super User

Hi @mvdb,

Not sure if you resolved this yet, but my recommendation would to be to stick with out-of-the-box views to achieve this.  I know creating 25+ views is a pain, but still probably less effort than to go the custom route even if you need to create one when a new tech onboards. If those views are for the techs, any chance you can filter on current user (or current team) instead of having a view per technician? If those views are for the supervisors/managers, then include the Technician as part of the column and they can filter on it. When you configure the calendar control, bind the description to a custom description field. Automatically set that custom description field (via Power Automate or classic workflow) based on some logic and include the technician name to it so they can see the assigned tech...

Hope this all makes sense!

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Users online (1,632)