Skip to main content

Notifications

Community site session details

Community site session details

Session Id : 8q2+fwQl6q1GsCrVJtpZju
Power Apps - Building Power Apps
Answered

Combo box for SharePoint List lookup

Like (0) ShareShare
ReportReport
Posted on 29 Dec 2021 19:56:19 by 52

This seems like something simple, but I can't figure it out.

 

I'm creating a gallery. The Data source for the gallery is a SharePoint. I have created a combo box that I want to link to a lookup column in the list.

 

When I set the Data source of the combo box to the list, the lookup column I want is not available in the fields list (Milestone):

jsangerman_0-1640807672174.png

When I try to set it in advanced properties, it finds it and doesn't give any errors, but also doesn't show any data in the box:

jsangerman_1-1640807721739.png

So what am I doing wrong?

  • RandyHayes Profile Picture
    76,287 Super User 2024 Season 1 on 29 Dec 2021 at 22:35:11
    Re: Combo box for SharePoint List lookup

    @jsangerman 

    It's not a problem...sometimes it tough to remember all the moving parts that need to go into place.

    Glad to point you down the right road!

  • jsangerman Profile Picture
    52 on 29 Dec 2021 at 21:51:46
    Re: Combo box for SharePoint List lookup

    I feel pretty silly. DefaultSelectedItems was blank. When I fixed that, all is right.

     

    Thanks again, Randy. You're really helping me get started in this space.

  • RandyHayes Profile Picture
    76,287 Super User 2024 Season 1 on 29 Dec 2021 at 20:40:28
    Re: Combo box for SharePoint List lookup

    @jsangerman 

    So then, need to know the following properties:

    - The Default Property of the DataCard

    - The Update Property of the DataCard

    - The DefaultSelectedItems property of the Combobox

  • jsangerman Profile Picture
    52 on 29 Dec 2021 at 20:37:54
    Re: Combo box for SharePoint List lookup

    jsangerman_0-1640810267331.png

     

  • jsangerman Profile Picture
    52 on 29 Dec 2021 at 20:35:23
    Re: Combo box for SharePoint List lookup

    That's something.

     

    Now I have the values available in the combo box for selection, but it doesn't seem linked to the underlying column. Neither is the box populated when the form opens nor does it save values to the list when selected.

  • Verified answer
    RandyHayes Profile Picture
    76,287 Super User 2024 Season 1 on 29 Dec 2021 at 20:17:36
    Re: Combo box for SharePoint List lookup

    @jsangerman 

    Your Combobox Items should be either Choices('DRE Milestone Tracker'.Milestone) or it should be your list that your lookup column is pointing to.

     

    I hope this is helpful for you.

  • jsangerman Profile Picture
    52 on 29 Dec 2021 at 19:57:46
    Re: Combo box for SharePoint List lookup

    In the second screenshot, I know DisplayFields and SearchFields shows something different. I would expect that to change to ["Values"] when a valid Items source is specified, but it's not.

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

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

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 - Building Power Apps

#1
MS.Ragavendar Profile Picture

MS.Ragavendar 27

#2
mmbr1606 Profile Picture

mmbr1606 14 Super User 2025 Season 1

#3
EE-04041031-0 Profile Picture

EE-04041031-0 11

Overall leaderboard
Loading started