Answered

Reference column in SharePoint list based on name in the same list in a label

(0) Share

Report

Posted on by qhenry

I have a sharepoint list that displays two items: Name and number of points associated with a name. In my app, I have the list shown on the bottom half, and I would like to show the name of the person using the app and the number of points associated with that person.

The list looks like the following:

_____________________

Name Points

Person1 23

Person2 12

Person3 32

Person4 34

_____________________

Say, Person1 is using the app, I would like the screen to display the following:

_____________________

Person1 - 23 Points

_____________________

How would one go about doing something like this? Thanks in advance!

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (2)

Verified answer

mdevaney 29,991 Moderator on at

Like (2)

Report
Copy link

Link copied!
@qhenry
You can find the current user's name with this code

User().FullName

And you can also LookUp their points in a Sharepoint List (assuming their name in SP is exactly the same).

LookUp(your_datasource_name,Name=User().FullName,Points)

So what you can do is take those functions and combine them in the Text property of a label

Concatenate( User().FullName, " ", Text(LookUp(your_datasource_name,Name=User().FullName,Points),"0"), " Points" )

The result will be:

Person1 - 23 Points

Keep in mind a person's name is not necessarily unique (e.g. there could be two people with the name John Smith). For that I reason I would suggest using email instead. You get a user's email by:

User().Email

---
Please click "Accept as Solution" if my response helped to solve your issue so that others may find it more quickly. If your thought the post was helpful please give it a "Thumbs Up."

Was this reply helpful? Yes No
Pstork1 69,026 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Add a label to the screen and set its Text property to a Lookup() of the list datasource where the DisplayName in the User column matches the User().fullname. Or you could also use the Email address like this since display names sometimes get changed

LookUp('Expense Reports','Created By'.Email=User().Email)

Was this reply helpful? Yes No
Verified answer

RezaDorrani 12,145 on at

Like (0)

Report
Copy link

Link copied!

Hi @qhenry

First on AppStart -

Set(varUserEmail, User().Email) - this will create a variable which you can use throughout the app and avoid delegation warnings when comparing for current user (delegation enables you to work with large data sets) (https://www.youtube.com/watch?v=tPxE_-DcWkg)

To show the user name
Create label and set Text property to - User().FullName

and to get the points
Create label and set Text property to -
LookUp(datasource,'Name'.Email=varUserEmail).Points

Regards,
Reza Dorrani

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

Was this reply helpful? Yes No