Autopopulate Multiselect Person Column PowerApps

[mssa12345]

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 allow multiple selections)  to be autopopulated based on office and team. 

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

Office    Team     Team Lead ( allow multiple selections)

A            Sales     User A , User B 

A             IT          User C, User D

B             HR         User E and so on.

I am able to get it populate when i set it to only allow one selection but not when multiple selection is turned on. 

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

Thank you for your help.

[uwenagel]

I would suggest to hold the possibilities for the TeamLead in a separate list (tblTeamLeads) the following way:

Office	Team	TeamLead
A	Sales	User A
A	Sales	User B
A	IT	User C
A	IT	User D
B	HR	User E
...

Then you could set the Items property of your third dropdown as follows:

DropDown3.Items : ShowColumns(Filter(tblTeamLeads,Office = DropDown1.Selected.Text && Team = DropDown2.Selected.Text),"TeamLead")

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.

[mssa12345]

@uwenagel  thank you for the response, I am using the Items property on 3rd dropdown which is Person or Group Column type, nothing is getting populated. I did make the table as you suggested.

ShowColumns(Filter('teamLeadTable', Office.Value= DataCardValue11.Selected.Value && Team.Value = DataCardValue10.Selected.Value ),"TeamLead")

 Can you please tell me where I am doing it wrong ?

Thank you.

[uwenagel]

Why do you use Office.Value and Team.Value instaed of just Office and Team? My code is different!

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.

[mssa12345]

@uwenagel the Office and Team data card are choice dropdown column, that's why I was using the value. Should I not use it , when I don't use it it shows error. When I use value error is gone but 3rd dropdown ( Person or Group Column type) is blank.

Thank you for sticking here to get it resolved. 

Thank you

[uwenagel]

But Office and Team are also the columns names in your table? There you should not use '.Value'

ShowColumns(Filter('teamLeadTable', Office = DataCardValue11.Selected.Value && Team = DataCardValue10.Selected.Value ),"TeamLead")

To further check what is going on you could temporarily add a label and put DataCardValue11.Selected.Value as its Text property. This way you could see that the filter gets a reasonable value. 

[mssa12345]

@uwenagel I can get the email or displayName on a text label, but the dropdown which is person or group type ( allow multiple selections) is still blank.

[uwenagel]

Did you create the lookup table as I suggested? I named the columns 'Office' and 'Team'.

How are DataCardValue10 and DataCardValue11 defined? What are their Items properties?

[mssa12345]

@uwenagel ,  yes i created the table ( separate list in SharePoint) and the items property for 

DataCardValue10: Choices([@'Sales-Tracking'].Office)

DataCardValue11: Choices([@'Sales-Tracking'].Team)

Thank you for all your help.

[uwenagel]

From your latest message I conclude that DataCardValue11 refers to the 'Team' column and DataCardValue10 to 'Office' and your table is called 'Sales-Tracking'. Then the formula should be:

ShowColumns(Filter('Sales-Office', Team = DataCardValue11.Selected.Value && Office = DataCardValue10.Selected.Value ),"TeamLead")

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.