Filter person combobox by group ID and update datacard values

(0) Share

Report

Posted on by SomeoneAwesome

174

Hi,

I have a form connected to a sharepoint list, one datacard is linked to a person column, i wish to filter the dropdown by a groupID.

My items for the combobox is

Filter(Office365Groups.ListGroupMembers("***MYGROUPID***").value, Not(displayName = "Joe Blow" || displayName = "Another Guy" || displayName = "Another Girl"))

and my defaultselecteditems for the combobox is

Office365Groups.ListGroupMembers("***MYGROUPID***").value

However i cannot get these values to patch to sharepoint, so i take it i need to modify my Update value of the datacard? however every piece of code i put in it is wrong?

I just wish to filter a dropdown via a group ID and patch values to sharepoint.

Could someone help?

Categories:

Building Power Apps

All responses (4)

Answers (1)

Sort by

v-xiaochen-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @SomeoneAwesome ,

Let's say the person column allows multiple selections.

I made a sample for you.

ForAll(DataCardValue3.SelectedItems,{Claims:"i:0#.f|membership|"&userPrincipalName,Email:userPrincipalName,Department:"",DisplayName:"",JobTitle:"",Picture:""})

Best Regards,

Wearsky
SomeoneAwesome 174 on at

Like
a
(0)

Report
Copy link

Link copied!

Sorry i get errors.

Also its a single person select group.

What is best practice to filter a person combobox dropdown? i just want to filter a bunch of names..
Verified answer

v-xiaochen-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @SomeoneAwesome ,

So you just want to select one person in the combo box ,right?

Please try this in update attribute

{Claims:"i:0#.f|membership|"&combobox.Selected.userPrincipalName,Email:combobox.Selected.userPrincipalName,Department:"",DisplayName:"",JobTitle:"",Picture:""}
SomeoneAwesome 174 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you. I just couldn't figure that one out.