DefaultSelectedItems of People Combobox: auto select from collection based on conditional

(0) Share

Report

Posted on by WorkingRicardo

878

For my Sharepoint list form, I have a People column. I want this to be autopopulated depending if

Label8.Text = "ES"

The combobox is populated by the collection of 6 people named "Responsables". So, if it "ES", I need it to auto select 3 people, if not, the remaining 3. I'm guessing I'll have to write into the code their specific emails.

Right now the DefaultSelectedItems property is set to:

Filter(
 Responsables;
 UserPrincipalName in ThisItem.'Sharepoint People Column'.Email
)

This is the only way I managed to make it save to Sharepoint and actually retain information when editing.

Responsables is a collection made with many lines like this:

Collect(Responsables; { DisplayName: "NAME"; UserPrincipalName: "NAME@company.com"; Mail: "NAME@company.com"})

Categories:

Building Power Apps

All responses (3)

Answers (0)

Sort by

v-bofeng-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @WorkingRicardo ,

The Responsables collection should be:

Collect( Responsables; { '@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser"; Department: ""; Claims: "i:0#.f|membership|" & "UserA@xxx.com"; DisplayName:"UserA"; Email: "UserA@xxx.com"; JobTitle: ""; Picture: "" } )

Best Regards,

Bof
WorkingRicardo 878 on at

Like
a
(0)

Report
Copy link

Link copied!
hello @v-bofeng-msft ty for your reply. Ohh is there a problem with the collection long term the way I have it set up? I ChatGPT-ed this a bit and came up with a solution for the DefaultSelectedItems:

If( Label8.Text = "ES"; Filter( Responsables; UserPrincipalName in ["person1@example.com"; "person2@example.com"; "person3@example.com"] ); Filter( Responsables; UserPrincipalName in ["person4@example.com"; "person5@example.com"; "person6@example.com"] ) )

This way is working. But do let me know if you foresee some issues coming up!
v-bofeng-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @WorkingRicardo ,

If you create the responsables collection by this formula:

Collect( Responsables; { '@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser"; Department: ""; Claims: "i:0#.f|membership|" & "UserA@xxx.com"; DisplayName:"UserA"; Email: "UserA@xxx.com"; JobTitle: ""; Picture: "" } )

Please set the combo box's DefaultSelectedItems property to

If( Label8.Text = "ES"; Filter( Responsables; Email in ["person1@example.com"; "person2@example.com"; "person3@example.com"] ); Filter( Responsables; Email in ["person4@example.com"; "person5@example.com"; "person6@example.com"] ) )

Best Regards,

Bof