Answered

Not able to display the Manager information in a Canvas app

(0) Share

Report

Posted on by dhruvmathur

Hi all,

I am trying to build a form in a canvas app, that is connected to a SharePoint list. I have two fields in my SharePoint List, one is Employee and the other is Manager. I am trying to pick up the Manager from Office365 when an Employee is entered. I search the forums and found the following post by @Brice235i : https://powerusers.microsoft.com/t5/Building-Power-Apps/Auto-populate-person-look-up-as-the-manager-of-a-nominated/m-p/203833#M65466, but it does not seem to be working for me. I can see the displayname and mail of the manager, if I parse it into a text field, but it is just not showing in the combobox. Interestingly, when I use the same code when I customize the app for the same SharePoint list, it works beautifully. Any idea if there is some setting I am missing on the Manager field?

Categories:

Building Power Apps

All responses (4)

Answers (1)

Sort by

mdevaney 29,993 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!
@dhruvmathur

Put this code in the OnChange property of the Employee ComboBox.

Set(empManager,Office365Users.ManagerV2(ComboBox_Employee.Selected.mail));

Then use this code in the Default property of the Card for the Manager ComboBox.

{ '@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser", Claims: "i:0#.f|membership|" & Lower(empManager.mail), DisplayName: wmpManager.displayName, Email: empManager.mail }

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."
Verified answer

Brice235i 651 on at

Like
a
(1)

Report
Copy link

Link copied!
Hello, did you set the variable on App Start? Click the App icon and for the OnStart action set the following

Set(gvCurrentUser, Office365Users.MyProfileV2()); Set(gvCurrentManager, Office365Users.ManagerV2(gvCurrentUser.userPrincipalName))

Have you set the default form mode as new?
on the manager datacardvalue on DefaultSelectedItems (not default) add the following:

//Default formula for the data card value If(EditForm1.Mode = FormMode.New && Not( gvCurrentManager.userPrincipalName = ""), { DisplayName: gvCurrentManager.displayName, Claims: "i:0#.f|membership|" & gvCurrentManager.userPrincipalName, Department:gvCurrentManager.department, Email:gvCurrentManager.mail, JobTitle:gvCurrentManager.jobTitle }, Parent.Default )
dhruvmathur 61 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @Brice235i ,

My Default mode was set to Edit. I changed it to New and it worked!! Thank you very much for helping me fix this, had been struggling to figure out why it wasn't working.
Brice235i 651 on at

Like
a
(0)

Report
Copy link

Link copied!
Hello, you might want to try another technique too depending on circumstance. Instead of the if statement on form mode you could try something like the below. I found the form mode confusing, but it worked so I kept using that technique... however I think this is easier to understand and good for single screen or customised list app.
//Default formula for the data card value If(IsBlank(ThisItem.'Requested By'), { DisplayName: gvCurrentUser.displayName, Claims: "i:0#.f|membership|" & gvCurrentUser.userPrincipalName, Department:gvCurrentUser.department, Email:User().Email, JobTitle:gvCurrentUser.jobTitle }, Parent.Default )