Error in person column

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

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)

Sort by

Verified answer

v-chengfen-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
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... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

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

Cheers!
DWTKBrook

Was this reply helpful? Yes No