Want to get people name in label

(0) Share

Report

Posted on by sachinsoni441

119

Hello,

I have one sharepoint list which have two people and people group column, which store Manager and corresponding requesters. Details are given below:

I want to display corresponding requester's Manager name in PowerApps label.

Example: if Sachin is login then i want to show Virendra as a manager in powerapp label. Please help.

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

KickingApps 628 on at

Like (1)

Report
I have created a collection resembling your SharePoint list. I have also created a variable setting the user to 'Betty' as the signed in user. I then use a lookup in the 'mgr' label to lookup the signed in users managers name.
See below. Hope this helps.
Collect( colSample, {id: 1, mgr: "Me", Emp: "George"}, {id: 1, mgr: "Me", Emp: "Ralph"}, {id: 2, mgr: "Me", Emp: "Betty"}, {id: 2, mgr: "You", Emp: "Gertrude"}, {id: 2, mgr: "You", Emp: "Matilda"} ); Set(thisUser, "Betty")

Mgr label
text = LookUp(
colSample, thisUser = Emp, mgr)

Was this reply helpful? Yes No
v-xida-msft on at

Like (1)

Report
Hi @sachinsoni441,

Do you enable "Allow Multiple Selections" option for the Requester column (Person type column) in your SP list?

I assume that you have enabled "Allow Multiple Selections" option for the Requester column, but do not enabled "Allow Multiple Selections" option for the Manager column.

I have made a test on my side, please take a try with the following workaround:

If one Requestor match only one Manager within your SP list, please take a try with the following workaround:

Set the Text property of the Label control to following:

"Manager: " & LookUp('20190114_case5', User().Email in Requester.Email).Manager.DisplayName

O your side, you should type:

"Manager: " & LookUp('YourEmpAndApproverSPList', User().Email in Requester.Email).Manager.DisplayName

If one Requester could match multiple Managers in your SP list, please take a try with the following workaround:

Set the Text property of the Label control to following:

"Manager: " & Concat(Filter('20190114_case5', User().Email in Requester.Email), Manager.DisplayName & "; ")

On your side, you should type:

"Manager: " & Concat(Filter('YourEmpAndApproverSPList', User().Email in Requester.Email), Manager.DisplayName & "; ")

More details about Filter function and LookUp function, please check the following article:

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-filter-lookup

Best regards,

Kris

Was this reply helpful? Yes No
sachinsoni441 119 on at

Like (0)

Report

Hello Kris,

Many Thank for help,

Now Manager's name displaying in label, but i get one warning message. i dont know why powerapp showing this warning message.

Was this reply helpful? Yes No
Verified answer

v-xida-msft on at

Like (1)

Report
Hi @sachinsoni441,

Based on the screenshot that you mentioned, I think you have faced a Delegation issue within your app.

The User().Email formula could not be delegated within your 'EmpAndApprover' SP list. In order to get rid of this Delegation issue within your app, please take a try with the following workaround:

Set the OnVisible property or OnStart property of the first screen of your app to following:

Set(CurrentUserEmail, User().Email)

Set the Text property of the Label control to following:

"Manager: " & LookUp('YourEmpAndApproverSPList', CurrentUserEmail in Requester.Email).Manager.DisplayName

save your app, then re-load it again, check if the Delegation issue is gone.

More details about Delegation in PowerApps, please check the following article:

Delegation

Best regards,

Kris

Was this reply helpful? Yes No
sachinsoni441 119 on at

Like (0)

Report

Working Perfectly.
Many Many Thanks Kris

Was this reply helpful? Yes No