web

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

News and Announcements icon

Power Platform CommunityForums Power Apps DefaultSelectedItems p...

Power Apps

Answered

DefaultSelectedItems people picker that looks up a SharePoint column

(0) Share

Report

Report

Posted on by NicolleAbraham

93

Hi everyone,

I am trying to default multiple people to a people picker but am struggling. At the moment the code to default is as follows,

With(

{

wRecord: LookUp(

'Look-up Roles',

Title = "Project Manager Entity"

)

},

Switch(

cb_LegalEntity.Selected.Title,

"Entity 1",

wRecord.'Entity 1',

"Entity 2",

wRecord.'Entity 2',

"Entity 3",

wRecord.'Entity 3',

"Entity 4",

wRecord.'Entity 4',

"Entity 5",

wRecord.'Entity 5',

"Entity 6",

wRecord.'Entity 6',

"Entity 7",

wRecord.'Entity 7',

"Entity 8",

wRecord.'Entity 8',

"Entity 9",

wRecord.'Entity 9'

)

)

The column is dynamic which is why it is more complex. Does anyone have an idea on how to change it to all multiple people?

TIA

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

anandm08 1,936 Super User 2024 Season 2 on at

Like
a
(1)

Report
Copy link

Link copied!
hi @NicolleAbraham ,
To default multiple people in a People Picker in PowerApps, you need to modify your formula to handle collections of people instead of single person references.
With( { wRecord: LookUp( 'Look-up Roles', Title = "Project Manager Entity" ), defaultPeople: Switch( cb_LegalEntity.Selected.Title, "Entity 1", wRecord.'Entity 1', "Entity 2", wRecord.'Entity 2', "Entity 3", wRecord.'Entity 3', "Entity 4", wRecord.'Entity 4', "Entity 5", wRecord.'Entity 5', "Entity 6", wRecord.'Entity 6', "Entity 7", wRecord.'Entity 7', "Entity 8", wRecord.'Entity 8', "Entity 9", wRecord.'Entity 9' ) }, ForAll( Split(defaultPeople, ";"), { Claims: "i:0#.f|membership|" & Trim(Value), DisplayName: Trim(Value), Email: Trim(Value) } ) )

Was this reply helpful? Yes No

Join the conversation