web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / AutoPopulate MultiSele...
Power Apps
Unanswered

AutoPopulate MultiSelect Person Column

(0) ShareShare
ReportReport
Posted on by 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:
I have the same question (0)
  • anandm08 Profile Picture
    1,936 Super User 2024 Season 2 on at

    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, ", ")
    )

     

  • mssa12345 Profile Picture
    111 on at

    @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

    failed.PNG

    Please advise. 

    Thank you for your help

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 525 Most Valuable Professional

#2
Haque Profile Picture

Haque 273

#3
Kalathiya Profile Picture

Kalathiya 232 Super User 2026 Season 1

Last 30 days Overall leaderboard