Answered

Get User Based on Choice on 2 other Columns

(0) Share

Report

Posted on by mssa12345

111

I am trying to build an app, where in my form I have a column Office ( choice: 12 different choice) and another column Team (choice: 6 different choice).

If I select lets say Office A and Team Sales, I want the other column Team Lead( person or group ) to be autopopulated based on office and team.

I have another list where the teams leads are mapped as below:

Office Team Team Lead

A Sales john, doe

A IT Test, Joe

B HR Test, Again and so on.

How can i get Team lead autopopulated based on Office and Team Selection in PowerApps ?

Thank you for your help.

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

ANB 7,250 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Hi @mssa12345 , You want to show the Team Lead on which type of control? If it is just a label control then this should work:

Set(gblvar,LookUp(OtherLIST, Office = dropdown.Selected.Value And Team = dropdown2.Selected.Value).TeamLead);

The label text property could be
gblvar.DisplatName
You need to use your control names.
------------------------------------------------------------------------------------------------------------------------------

I hope this helps.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs up.

Thanks,
ANB

Was this reply helpful? Yes No
mssa12345 111 on at

Like (0)

Report
Copy link

Link copied!
@ANB thank you for the response. The team lead is a Person control type
I have the code below on the onChange property of the Team datacard, but its showing error ( Error on equal sign)
Set(gblvar,LookUp('Designed List', Office = DataCardValue52.Selected.Value And Team= DataCardValue10.Selected.Value).'Team Lead');

Was this reply helpful? Yes No
ANB 7,250 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @mssa12345 , DataCardValue52 and DataCardValue10 which i believe it is combo box/dropdown. So can you please share the screenshot of these 2 controls as below:

I want to know what is showing in Primary Text for both controls.

------------------------------------------------------------------------------------------------------------------------------

I hope this helps.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs up.

Thanks,
ANB

Was this reply helpful? Yes No
mssa12345 111 on at

Like (0)

Report
Copy link

Link copied!

@ANB yes they both are combobox/dropdown. I have attached the screenshot.

Was this reply helpful? Yes No
Verified answer

ANB 7,250 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
HI @mssa12345 , Sorry I missed this, Office and Team both are Choices datatype columns correct? If yes, then code should be
Set(gblvar,LookUp('Designed List', Office.Value = DataCardValue52.Selected.Value And Team.Value = DataCardValue10.Selected.Value).'Team Lead');

------------------------------------------------------------------------------------------------------------------------------

I hope this helps.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs up.

Thanks,
ANB

Was this reply helpful? Yes No