Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics 365 | Integration, Dataverse...
Unanswered

Custom dynamic filters on entity view

Posted on by 10

Hello

In my environment, there is a product table. A record can have 3 parameters ("Indoor/outdoor", "Water Toys/Sand Toys/Wooden Toys/Rubber Toys", "red/blue/green/yellow".

ID Product Indoor/outdoor Type Color
1 Waterblast Outdoor Water Toys blue
2 Waterblast Outdoor Water Toys yellow
3 Sandshell Outdoor Sand Toys green
4 Bucket Outdoor Rubber Toys yellow
5 Trainset Indoor Wooden Toys red
6 Trainset Indoor Wooden Toys blue
7 Trainset Indoor Wooden Toys green
8 Trainset Indoor Wooden Toys yellow
9 Bounce-Ball Indoor Rubber Toys blue
10 Bounce-Ball Indoor Rubber Toys red

something like this (I let my imagination run wild)

 

Now I want to filter this view based on the filtered records through three dropdowns The dropdowns will be filled in in a non-logical order. The first dropdown that gets filled in, let's say indoor/outdoor, shows all the possible values (indoor or outdoor). When outdoor gets picked. The next dropdown that will be filled in (in this example color) should only show the values (blue, yellow and green) because there are no red outdoor toys. Let's say yellow gets picked. When the type-dropdown gets opened, only water toys and rubber toys should be visible.

 

I was thinking of letting my view update everytime a value in a dropdown gets chosen. And was hoping of retrieving the distinct values of the corresponding attribute and putting them in the correct dropdown. This possible solution can only be achieved through a custom javascript function i guess.

 

Does someone have a prior experience with a scenario like this or with a custom javascript function which can retrieve the remaining values of a filtered view and putting them in a dropdown?

Thank you so much

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!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans