Populating a SharePoint "People" field with a ComboBox in PowerApps that is populated with an AD group and making a default selection

(0) Share

Report

Posted on by MRKennedy

I am using a SharePoint list datasource, that has a "People/Group" field. In my PowerApps, I would like to:

1) Populate the Combo box items with people from an AD group

2) Save to the SharePoint list once a person is selected (COMPLETED)

3) Set the Default item to the current user if it's a new item OR for an existing item select the appropriate user (NOT COMPLETED)

I am going to add all of the steps just in case someone would like to perform the same actions, but I just need assistance with item 3.

1) Populate the Combo box items with people from an AD group (COMPLETED)

In the Combo box "Items" Property add the following code "Sort(Office365Groups.ListGroupMembers("<ADD AD GROUP GUID>").value, displayName)"

2) Save to the SharePoint list one a person is selected (COMPLETED)

Add the following code to the Data Cards "Update" property. Note: the check for ISBLANK allow for the field to be required. If it's not a required field, the IF statement is not needed.

If(IsBlank(DataCardValue5.Selected),
DataCardValue5.Selected,

{Claims:"i:0#.f|membership|" & DataCardValue5.Selected.mail,Department:"",DisplayName:DataCardValue5.Selected.displayName,Email:DataCardValue5.Selected.mail,JobTitle:"",Picture:""})

3) Set the Default item to the current user if it's a new item OR for an existing item select the appropriate user (NOT COMPLETED)

When the page loads, I am unable to set the default selected item to either the currently logged in user, or the Person that comes from the SharePoint list. I would like to do something like this is the "Default" property of the Combo box:

IF(DisplayMode = DisplayMode.Edit, ThisItem.Person, User())

It seems I would need to lookup the ComboBox items by the display name or email since the objects in the Combobox list are not that same a the User() or SharePoint Item.. However, I have been unable to effectly use the Lookup or Find functions to match the names.

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Ami K 15,679 Super User 2024 Season 1 on at

Like (0)

Report
@MRKennedy - on the Default property of the DataCardValue, try:

If( 'Your Form'.Mode = FormMode.New, { DisplayName: User().FullName, Claims: "i:0#.f|membership|" & User().Email }, Parent.Default)

Was this reply helpful? Yes No
MRKennedy 32 on at

Like (0)

Report

Thank you for the quick reply. For some reason, it won't select any of the items once I populate the combo box items with the AD group using: "Office365Groups.ListGroupMembers("<ADD AD GROUP GUID>").value" . I can't get it to use the SharePoint item value or the current user. It always shows as blank. And I confirmed the item in the list has a person. I just can't resolve the list item. In standard programming you would just override the compare function but I am not sure how PowerApps is resolving the names in the list.

Was this reply helpful? Yes No
Verified answer

Ami K 15,679 Super User 2024 Season 1 on at

Like (0)

Report

@MRKennedy - I was writing a long response and then decided it was best to move it to a blog post.

See if you can reuse/rework the method outlined below:

https://powerusers.microsoft.com/t5/Power-Apps-Community-Blog/Replace-People-Picker-in-a-Form-with-Office365Groups/ba-p/2380287

Was this reply helpful? Yes No
MRKennedy 32 on at

Like (2)

Report

Worked Perfectly, thank you. For anyone else trying the same thing. You simply need to add this to the datacard (not the datacardvalue).
// The if statement tells me if it's a new record, because it's a required field so it will have a value if it's an existing record
If(!IsBlank(ThisItem."INSERT PROPERTYNAME".DisplayName),
First(
// Sets the default item to the value in the SharePoint list
Filter(
Office365Groups.ListGroupMembers("ENTER GUID").value,
displayName = ThisItem.ENTER PROPERTY NAME.DisplayName
)
),
First(
// Defaults to the logged in user
Filter(
Office365Groups.ListGroupMembers("ENTER GUID").value,
displayName = Office365Users.MyProfileV2().displayName
)
)
)

Was this reply helpful? Yes No
JohnB12 3 on at

Like (0)

Report

Thanks Mr Kennedy!!

Was this reply helpful? Yes No