web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps AutoPopulate MultiSele...

Power Apps

Unanswered

AutoPopulate MultiSelect Person Column

(0) Share

Report

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 Img

All responses (2)

Answers Img

Answers (0)

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

Join the conversation