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
Resolver I
Resolver I

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 😃

Highlighted
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
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

secondImage

Return to Workplace

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

secondImage

Super Users Coming in August

We are excited for the next Super User season.

secondImage

Community User Group Member Badges

FIll out a quick form to claim your community user group member badge today!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (8,959)