How do I setup a multi-select LookUp column

Like (0) Share

Report

Posted on 31 Oct 2024 18:39:48 by Zholland

I need to create a Multi-Select Lookup column in a Dataverse Table.

I have a Labels table and a CustomUsers table with a Many to Many Relationship setup. I need a column in the Labels table to select users from the CustomUsers table. This only seems to allow a single user to be selected. How can I Select multiple users?

Categories:

Microsoft Dataverse

All responses (2)

Answers (0)

Shashank Bhide 936 Super User 2025 Season 1 on 01 Nov 2024 at 05:57:55

Like (0)

Report

How do I setup a multi-select LookUp column

there are limited OOB options in Dataverse for multi-select inputs, one is multi select optionset, the other one is using subgrids, other than that you can implement a PCF control as shown below.

https://pcf.gallery/multiselect-lookup-pcf/
Suggested answer

SaiRT14 1,966 Super User 2025 Season 1 on 31 Oct 2024 at 21:51:35

Like (0)

Report
How do I setup a multi-select LookUp column

try the following:

Step 1: Create a Many-to-Many Relationship

Step 2: Use a Subgrid or Multi-Select Lookup Control

Edit the Labels form and add a subgrid for the CustomUsers relationship. This subgrid will allow you to add multiple users to each label record directly within the form.

Configure the subgrid to display the CustomUsers records, allowing you to select multiple users for a Label.

Step 3: Saving Selected Values

ForAll(
ComboBoxCustomUsers.SelectedItems,
Patch(
Labels_CustomUsers,
Defaults(Labels_CustomUsers),
{
LabelId: LabelRecordID,
CustomUserId: CustomUser.ID
}
)
)

let me know how it goes! thanks