Problem Statement:

Dynamics 365 CE lacks native support for dependent picklists, multi-select dependencies, and active/inactive option management. Organizations with complex business scenarios face challenges with scalability, maintainability, and performance when using JavaScript-based filtering for Option Sets. This limits flexibility, increases technical debt, and complicates configuration.

Proposed Idea:

This idea proposes a lookup-based framework using Dataverse tables and N:N relationships to enable configurable parent-child picklists, multi-level dependencies, and lifecycle management. The solution minimizes JavaScript, scales to hundreds of values, preserves historical data, and allows business users to manage picklists without deployments, improving usability, performance, and maintainability.