Unanswered

Getting specific row data based on logged in user.

(0) Share

Report

Posted on by jakebroom

Hi all,

I am currently trying to figure out how to get specific row of data from a SharePoint list based on the currently logged in user.

The share point table looks like the below:

Name	Username	days left
name1	user1	12
name2	user2	15

The user name field in the SharePoint table is set as type "username".

So basically i am trying to get is so that if user1 is logged in then it only shows their days left in the form.

I have already tried setting the permissions on the table to allow the user to only see their data, however this doesn't work as the end user doesn't enter the data into the table.

Any help on this would be very much appreciated,

Thanks,

Jake

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Sort by

mdevaney 29,991 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
@jakebroom

You can detect the email of the currently logged in user with this code.

User().Email

If you create a new column called UserEmail in your SharePoint list you can perform a FILTER like this.

Filter(your_datasource_name, UserEmail = User().Email)

Or if an existing field (example: Name) is a Person type field you can use code like this.

Filter(your_datasource_name, Name.Mail = User().Email)

---
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."

Was this reply helpful? Yes No
brimstone 69 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @jakebroom

Edit: Just saw that mdevaney was faster...
__

You should be able to get your result with the Filter-Function.
This can look like this:

Filter( SharepointList, Username = user1 )

You just need to make sure that you have e.g. a variable set with the name of user1 so he can filter correctly.
For example on your OnVisible or OnStart:

Set( ThisUser, User().FullName )

Then you need to exchange the user1 in the first formula with ThisUser.

Please let me know if this solves your problem or if I misunderstood it.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @mdevaney ,

Is it possible that you also help me with my topic. Let me know what are the possibilities.

Link: https://powerusers.microsoft.com/t5/Building-Power-Apps/Sharepoint-gt-Powerapps-gt-Outlook/m-p/455865#M136092

Thanks in advance,
Sanket

Was this reply helpful? Yes No