Error in person column

(0) Share

Report

Posted on by Community Power Pla...

I have a requirement to populate a person column with the manager of the person selected in another person column

In the requestor column I have the following properties

Items:

Choices([@AUGBE_TEST].Requestor)

DefaultSelectedItems:

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

And for the Line Manager field I'm trying to populate

Items:

Choices([@AUGBE_TEST].Line_x0020_Manager)

DefaultSelectedItems:

If(DataCardValue12.Value=false, {'@odata.type':"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",
 Claims:"i:0#.f|membership|" & Office365Users.ManagerV2(DataCardValue28.Selected.Email).mail,
 Department:"",
 DisplayName:Office365Users.ManagerV2(DataCardValue28.Selected.Email).displayName,
 Email:Office365Users.ManagerV2(DataCardValue28.Selected.Email).mail,
 JobTitle:"",
 Picture:""
 })

None of the properties' syntax are in error but when I publish the form I get the following error in the form in the person column;

I have no idea what's causing this or how to fix it. Has anyone else run into this issue before?

Any ideas on how to fix this?

Any help would be greatly appreciated.

DWTKBrook

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

v-chengfen-msft on at

Like (1)

Report
Hi @Anonymous ，
The parameter required by Office365Users.ManagerV2() is UerID
Please try:
If(DataCardValue12.Value=false, {'@odata.type':"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser", Claims:"i:0#.f|membership|" & Office365Users.ManagerV2(First(Office365Users.SearchUser({searchTerm:DataCardValue28.Selected.Email,top:1})).Id).mail, Department:"", DisplayName:Office365Users.ManagerV2(First(Office365Users.SearchUser({searchTerm:DataCardValue28.Selected.Email,top:1})).Id).displayName, Email:Office365Users.ManagerV2(First(Office365Users.SearchUser({searchTerm:DataCardValue28.Selected.Email,top:1})).Id).mail, JobTitle:"", Picture:"" })

Best Regards
Cheng Feng

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Thank you @v-chengfen-msft , that did the trick. I appreciate your help on this one.

Cheers!
DWTKBrook

Was this reply helpful? Yes No