Skip to main content

Notifications

Community site session details

Community site session details

Session Id : a+RNdIuvZwyUTPZTSF8VQI
Power Apps - Microsoft Dataverse
Suggested answer

How do I setup a multi-select LookUp column

Like (0) ShareShare
ReportReport
Posted on 31 Oct 2024 18:39:48 by 13
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:
  • Shashank Bhide Profile Picture
    936 Super User 2025 Season 1 on 01 Nov 2024 at 05:57:55
    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.
     
  • Suggested answer
    SaiRT14 Profile Picture
    1,966 Super User 2025 Season 1 on 31 Oct 2024 at 21:51:35
    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

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

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Power Apps - Microsoft Dataverse

#1
stampcoin Profile Picture

stampcoin 15

#2
ankit_singhal Profile Picture

ankit_singhal 11 Super User 2025 Season 1

#3
mmbr1606 Profile Picture

mmbr1606 9 Super User 2025 Season 1

Overall leaderboard

Featured topics

Loading started