Showing results for 
Search instead for 
Did you mean: 
Regular Visitor

Getting specific row data based on logged in user.

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:


NameUsernamedays left


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,





Super User III
Super User III


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



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

Advocate I
Advocate I

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.

Hi @mdevaney ,


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




Thanks in advance,


Helpful resources

PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!


Are Your Ready?

Test your skills now with the Cloud Skill Challenge.


Demo Extravaganza is Back!

We are excited to announce that Demo Extravaganza for 2021 has started!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Top Solution Authors
Top Kudoed Authors
Users online (46,359)