Answered

Combo box of Person columns based on selection in dropdown control

(0) Share

Report

Posted on by petewalburn

185

In my PowerApps app I have a drop down control for country. I have a Sharepoint list (List 1) that has a Country choice field and an Approver Person field.

When I select a country in the country drop down control, I need an Approver combo box to be populated with an approver and backup approver that come from another Sharepoint list (lookup list).

The default of the Approver combo box should be the Approver from the Sharepoint List 1. When the app is saved the value of the Approver in List 1 should be whatever is selected in the Approver combo box.

I think I probably need to create a collection with the Approver and Backup Approver from the lookup list for the selected country, and have this collection as the Items for the Approver combo box.

Any help much appreciated,

Pete

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (2)

Sort by

Verified answer

NandiniBhagya20 4,667 Super User 2024 Season 1 on at

Like
a
(2)

Report
Copy link

Link copied!

Hi @petewalburn ,
You can use something like below on defaultselecteditems property of Approver Combobox added to your form -
With({_record: LookUp(List1, Country.Value=CountryDropdownControlName.Selected.Value, ApproverColumnName)},
{DisplayName: _record.DisplayName,
Claims: "i:0#.f|membership|"&Lower(_record.Email),
Department: "",
Email: _record.Email,
JobTitle:"",
Picture:"",
}
)

Was this reply helpful? Yes No
petewalburn 185 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks so much. That did put select Approver Name in the Approver combo box. Fantastic!

Pete

Was this reply helpful? Yes No
petewalburn 185 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,

Is there a way that I can have the Approver Combo Box only have the Approver and the Backup Approver available in the list. Currently I set the Items property to:

Office365Users.SearchUserV2({searchTerm:Self.SearchText,top:10}).value

This gives all of the users in the company. I need to limit it to just the ones for the selected Country.

Pete

Was this reply helpful? Yes No
Verified answer

IvanC 10 on at

Like
a
(1)

Report
Copy link

Link copied!

This solution helped me a lot, just a note... the comma here " Picture:"", " pops an error. So it should be:

With({_record: LookUp(List1, Country.Value=CountryDropdownControlName.Selected.Value, ApproverColumnName)},
{DisplayName: _record.DisplayName,
Claims: "i:0#.f|membership|"&Lower(_record.Email),
Department: "",
Email: _record.Email,
JobTitle:"",
Picture:""
}
)

Was this reply helpful? Yes No