Answered

Customized people picker not showing value in Edit screen

(1) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hello,

I have modified a people picker field to drop down to a certain AD group in my team. Everything works well for updating the field value to SharePoint list. But, when I edit the same existing item, people picker field value resets to empty ( Note - value is still shown in SharePoint list).

I haven't modified any formulas in SharePoint integration properties. Can anyone please help me figure out the issue. below is the screenshot for the update properties of the field.

Categories:

Building Power Apps

All responses (4)

Answers (1)

Sort by

v-xida-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Anonymous ,

Could you please show more details about the formula you typed within the Items property of the DataCardValue4?

Do you set the Items property of the DataCardValue4 to AzureAD.GetGroupMembers('group id').value function?

Regarding the issue that you mentioned, I think this issue is related to the formula you typed within the DefaultSelectedItems property of the DataCardValue4. If the Items property of the DataCardValue4 is set to AzureAD.GetGroupMembers('group id').value function, please try the following workaround:

Set the DefaultSelectedItems property of the DataCardValue4 to following:

LookUp( AzureAD.GetGroupMembers("xxxxxxxx-2d32-xxxx-807c-73550848af7b").value, mail = ThisItem.PersonField.Email // PersonField represents the Person type column in your SP List )

Note: The 'xxxxxxxx-2d32-xxxx-807c-73550848af7b' represents the group id in my AAD, please replace it with your own group id.

Please try above solution, check if the issue is solved.

Regards,
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

changing DefaultSelectedItems property didn't resolve the issue. Here are the Items property and changed DefaultSelectedItems formulas.
Verified answer

v-xida-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Anonymous ,

Regarding the formula specified within the DefaultSelectedItems property of the ComboBox, I found that there is something wrong with it.

Within the result table the Office365Groups.ListGroupMembers(...).value formula returns, there is no column called "Mail", it only has 'mail' column (first letter should be lower case).

So you should modify your formula as below:

LookUp( Office365Groups.ListGroupMembers('xxxxxxx').value, mail = ThisItem.'Support Planner'.Email )

Please try above formula again, check if the issue is fixed.

Regards,
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Yup, it is working fine now. Thanks a lot