How to Configure MultiSelect Lookup in Dynamics 365

Lookup fields are one of the most powerful features in Dynamics 365 CRM because they establish relationships between records. However, standard lookup fields only allow users to select a single related record.

Many business scenarios require selecting multiple related records, such as assigning multiple contacts to a project, linking multiple products to an opportunity, or associating several skills with an employee profile.

This is where MultiSelect Lookup solutions become valuable.

What is a MultiSelect Lookup?

A MultiSelect Lookup enables users to select multiple records from another table and store those relationships efficiently.

Unlike standard lookup fields that support only one record selection, a MultiSelect Lookup allows:

Multiple related records
Better user experience
Reduced data duplication
Flexible relationship management

Business Scenarios

Project Management

Associate multiple team members with a project.

Sales Management

Link multiple products to opportunities.

Customer Service

Associate multiple contacts with support cases.

Human Resources

Assign multiple skills or certifications to employees.

Standard Dynamics 365 Limitation

Out of the box, Dynamics 365 lookup fields support only:

One-to-Many relationships
Single record selection

Microsoft does not currently provide a native MultiSelect Lookup control similar to MultiSelect Option Sets.

Therefore, organizations typically implement custom approaches.

Common Approaches

Approach 1: Many-to-Many Relationship

The recommended solution is creating a Many-to-Many relationship.

Benefits:

Native Dataverse support
Scalable architecture
Better reporting
Security support

Example:

Project ↔ Employee

One project can have many employees and one employee can belong to many projects.

Approach 2: Custom PCF Control

Power Apps Component Framework (PCF) controls provide a modern MultiSelect Lookup experience.

Benefits:

Enhanced UI
Search functionality
Better user experience
Responsive design

Approach 3: Custom Canvas App Control

Organizations can embed a Canvas App inside a Model-Driven App.

Benefits:

Flexible UI
Advanced filtering
Custom business rules

Implementation Example

Scenario:

A Project record requires multiple Consultants.

Step 1

Create a Many-to-Many relationship:

Project ↔ Consultant

Step 2

Add a subgrid to the Project form.

Step 3

Allow users to add multiple Consultant records.

Step 4

Display selected records within the form.

Result:

Users can associate multiple consultants with a single project.

Best Practices

Use Many-to-Many relationships whenever possible.
Avoid storing IDs in text fields.
Use PCF controls for enhanced usability.
Apply security roles correctly.
Test performance with large datasets.
Follow Dataverse relationship standards.

Benefits

Better Data Relationships

Maintain accurate record associations.

Improved User Experience

Allow efficient record selection.

Scalability

Support growing business requirements.

Easier Reporting

Leverage native Dataverse relationships.

Reduced Customization Complexity

Use supported architecture patterns.

Conclusion

Although Dynamics 365 does not provide a native MultiSelect Lookup field, organizations can achieve the same functionality using Many-to-Many relationships, PCF controls, and Power Apps customizations. These approaches provide flexible relationship management while maintaining scalability, performance, and data integrity.