Unanswered

AutoPopulate MultiSelect Person Column

(0) Share

Report

Posted on by mssa12345

111

I have List A and List B. List A is the main list with column called Team Lead ( multi selection allow person column) and I use List B to store the Team Lead based on Office.

In PowerApps , how can I populate Team lead by default when a certain office is selected.

List B

Team Lead Office Region

User A Office A East

User B Office A West

How can i get Team Lead Email ( both) to populate in my PowerApps when Office A is selected. Office in my PowerApps is dropdown.

Thank you for your help.

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

Sort by

anandm08 1,936 Super User 2024 Season 2 on at

Like (0)

Report
Copy link

Link copied!
hi @mssa12345 ,
you can do so like this:
Dropdown Control for Office:
Distinct(ListB, Office)
Button or OnChange Event to Populate Team Lead:
Set(varTeamLeadEmails, Concat(Filter(ListB, Office = DropdownOffice.Selected.Value), TeamLead.Email, ", "))
DefaultSelectedItems Property of the Team Lead Field in the Form:
Filter( Office365Users.SearchUser({searchTerm: varTeamLeadEmails}), DisplayName in Concat(Filter(ListB, Office = DropdownOffice.Selected.Value), TeamLead.DisplayName, ", ") )

Was this reply helpful? Yes No
mssa12345 111 on at

Like (0)

Report
Copy link

Link copied!

@anandm08 thank you for your help, I tried using the formulas you mentioned above.
When I select the office the Team Lead Datacard is Blank, and also see error in Default Property of Team Lead Datacard.
Formula for Default I have is
ThisItem. 'Team Lead'
Also I get the error below on DefaultSelectedItems
Please advise.
Thank you for your help

Was this reply helpful? Yes No