Answered

Combo box for SharePoint List lookup

(0) Share

Report

Posted on by jsangerman

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):

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:

So what am I doing wrong?

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (1)

jsangerman 52 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Verified answer

RandyHayes 76,297 Super User 2024 Season 1 on at

Like (0)

Report

@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.

Was this reply helpful? Yes No
jsangerman 52 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
jsangerman 52 on at

Like (0)

Report

Was this reply helpful? Yes No
RandyHayes 76,297 Super User 2024 Season 1 on at

Like (0)

Report

@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

Was this reply helpful? Yes No
jsangerman 52 on at

Like (1)

Report

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.

Was this reply helpful? Yes No
RandyHayes 76,297 Super User 2024 Season 1 on at

Like (0)

Report

@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!

Was this reply helpful? Yes No