Unanswered

combo box item fills according the item i select in another combobox

(1) Share

Report

Posted on by JonathanMejia

Hi team

I have a list in sharepoint named Buyers that has two columns (User & ManagerBuyer)

One combobox gets filled with all the names in my users column and what i need to do is to have on the 2nd combobox the managerbuyer according to the user i select.

Please let me know if you need more info

Thanks in advance

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Verified answer

365-Assist 2,324 Moderator on at

Like (1)

Report

I think what you are after is a Cascading ComboBox. This video should hopefully help -> https://www.youtube.com/watch?v=Qzpjq008cBY

---------------------------------------------------
Please Accept as Solution if it solves your question. Or just give it a Thumbs Up if it is helpful as can help others.

Subscribe: https://www.youtube.com/channel/UCFpvUlpx84FuIPOdInGKMTw

Regards
Darren Lutchner - 365 Assist

Was this reply helpful? Yes No
v-qiaqi@microsoft.com on at

Like (0)

Report

Hi @JonathanMejia,

Could you please tell me that:

If both User & ManagerBuyer are Person columns allosing multi select?

How you set the Items property of the ComboBox corresponding to your User column?

The above decides how to set the DefaultSelectedItems property of DataCardValue6.

Was this reply helpful? Yes No
JonathanMejia on at

Like (0)

Report

Hi that option its off for both of my columns and also i forgot to mention the column type for both of my columns its PERSON

So far i tried this in the items properties for the managerbuyer combobox

LookUp(Buyers, User.DisplayName = DataCardValue5.Selected.Value).ManagerBuyer

i dont get any errors using that code and as you can see on this image this is the data that its detecting but if ran the app theres no data in the managerbuyer combobox

Was this reply helpful? Yes No
JonathanMejia on at

Like (0)

Report

This worked, thank you so much for your quick response

I did a few adjustments but in the most part it worked

Im sharing a screenshot in case someone else in the future might need it

Was this reply helpful? Yes No