How do I setup a multi-select LookUp column

(0) Share

Report

Posted on 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 with Power Apps

I have the same question (0)

All responses (2)

Answers (0)

Suggested answer

SaiRT14 1,990 Super User 2025 Season 2 on at

Like (0)

Report
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

Was this reply helpful? Yes No
Shashank Bhide 942 Moderator on at

Like (0)

Report

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/

Was this reply helpful? Yes No