Answered

Combobox dropdown needs to reflect all people from a sharepoint list

(0) Share

Report

Posted on by koontz

216

Hi all, I have a combobox dropdown that I am trying to populate only with people from a SharePoint list, filtered by a unique ID (#36 in the example below). There will be multiple rows, with a varying number of people in each row. There could be 1, 2, 3, or 4, people in a row, so the dropdown should reflect all of them in a given Unique ID.

I tried "Choices([@Suppliers_2].Supplier).DisplayName", which worked, but it gave me the entire list of everyone in the organization, which is not what I want.

I just want the list limited to everyone in the "Supplier" column for "RequestID" 36 (for example). Is this possible?

Categories:

Building Power Apps

I have the same question (0)

All responses (16)

Answers (1)

Sort by

Ami K 15,689 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@koontz - in the Items property of that ComboBox, use:

LookUp( Suppliers_2, RequestID = 36, Supplier )

Was this reply helpful? Yes No
koontz 216 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks @Amik, I appreciate the response. However, this only gives me the first one. I need all of them in the dropdown.

If I change it to be a Filter, then the dropdown is completely blank.

Was this reply helpful? Yes No
Ami K 15,689 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@koontz - the solution I provided will return all people in that multi-select people field for that Request ID. You should not need to use Filter here.

Was this reply helpful? Yes No
koontz 216 on at

Like
a
(0)

Report
Copy link

Link copied!

Unfortunately, it only returns the first person (the one circled in red).

Was this reply helpful? Yes No
cwebb365 3,294 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Amik is close, you just want to use Filter :).

Filter(Suppliers_2, RequestID = 36).Supplier

You can further break it out to .Supplier.DisplayName if you are just needing the text names and that's it. If you are patching back somewhere with People columns etc. Then you'll want .Supplier so you can display the DisplayName column in the ComboBox but utilize the Combo.Selected.ID etc. fields for the User to patch it.

Was this reply helpful? Yes No
cwebb365 3,294 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Well to further add you probably want distinct, so you'll want to incorporate a With Statement.

With({SupplierNames: Filter(Suppliers_2, RequestID = 36)}, Distinct(SupplierNames,Supplier))

This will get a list of Suppliers locally then Distinct them, since you use With it won't be non-delegable.

Was this reply helpful? Yes No
koontz 216 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks @cwebb365, I feel like I'm getting closer, but this provides an error:

Was this reply helpful? Yes No
cwebb365 3,294 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Well looks like you should be using 'Request Suppliers' instead of Suppliers_2 based on previous screen? Or maybe that's what was wrong there. Anyway, seems you have a control called RequestID? You should have type ahead there for that column as you type Filter(Suppliers_2, then pick the column name in the type ahead there for the data. Shouldn't be comparing control to number which tells me there is a control called RequestID somewhere. Might have to add As SupplierData after Suppliers_2 and use SupplierData.RequestID if you can't get the type ahead to find the column right.

Was this reply helpful? Yes No
koontz 216 on at

Like
a
(0)

Report
Copy link

Link copied!

Ok, thank you. If I change it to "Request Suppliers", it shows a bunch of tables, instead of the names I expect from the SharePoint list, and my dropdown is blank. How do I parse through the tables to just display names?

Was this reply helpful? Yes No
cwebb365 3,294 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
This is the part where if you just need Text display names and that's it, then add .DisplayName to the end of the Field in the Distinct Function. If that errors, then Add .Supplier to the end of the Filter, then Distinct(SupplierNames,DisplayName)

With({SupplierNames: Filter('Request Suppliers', RequestID = 36)},Distinct(SupplierNames,Supplier.DisplayName))

Was this reply helpful? Yes No