cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Skilled Sharer
Skilled Sharer

Auto-populate person look-up as the manager of a nominated person (not current user)

Hi, I have a PowerApp based on a SharePoint custom list. It contains a person look-up card whereby the form submitter nominates a particular person (Employee).   When this person is entered I would like a separate manager card (person look-up) to automatically populate as this person's manager. 

 

The person is not the current user.  The manager is based on whoever is selected.

The only posts I can find on this topic assume the user is the current user which is not the case for this form.

does anyone know the syntax required in the manager field default setting?  I am connected to Office365Users service...  just can't work out the syntax. Something like: Office365Users.ManagerV2(Employee datacardvalue :User().DisplayName})???

Thanks.

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Skilled Sharer
Skilled Sharer

Re: Auto-populate person look-up as the manager of a nominated person (not current user)

Hi, I managed to work this out...

NameDatacard  is the person look-up field from who the ancilliary fields are derived.

 

Screen

On Visible

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

NameDatacard

OnChange -

Set(gvCurrentManager, Office365Users.ManagerV2(NameDataCardValue.Selected.Email));Set(varManager,gvCurrentManager)

 

ManagerDatacard

DefaultSelectedItems

{DisplayName: gvCurrentManager.displayName,
Claims: "i:0#.f|membership|" & gvCurrentManager.userPrincipalName}

 

Department

Default

First(Office365Users.SearchUser({searchTerm:NameDataCardValue.SearchText})).Department

 

 

View solution in original post

3 REPLIES 3
Highlighted
Skilled Sharer
Skilled Sharer

Re: Auto-populate person look-up as the manager of a nominated person (not current user)

Hi, I managed to work this out...

NameDatacard  is the person look-up field from who the ancilliary fields are derived.

 

Screen

On Visible

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

NameDatacard

OnChange -

Set(gvCurrentManager, Office365Users.ManagerV2(NameDataCardValue.Selected.Email));Set(varManager,gvCurrentManager)

 

ManagerDatacard

DefaultSelectedItems

{DisplayName: gvCurrentManager.displayName,
Claims: "i:0#.f|membership|" & gvCurrentManager.userPrincipalName}

 

Department

Default

First(Office365Users.SearchUser({searchTerm:NameDataCardValue.SearchText})).Department

 

 

View solution in original post

Highlighted
Advocate III
Advocate III

Re: Auto-populate person look-up as the manager of a nominated person (not current user)

Thanks for posting this information, I was trying to do the same and found it very helpful 😃

Frequent Visitor

Re: Auto-populate person look-up as the manager of a nominated person (not current user)

If I'm the current user, I'm not able to get my Manager's Managerfield in person/group field. Could anyone help?

Helpful resources

Announcements
secondImage

New Return to Workplace

Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.

August 2020 CYST Challenge

Check out the winners of the recent 'Can You Solve These?' community challenge!

Experience what’s next for Power Apps

Join us for an in-depth look at the new Power Apps features and capabilities at the free Microsoft Business Applications Launch Event.

Check this Out

Helpful information

Featuring samples like Return to the Workplace and Emergency Response Applications

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (3,645)