Showing results for 
Search instead for 
Did you mean: 
Helper I
Helper I

How to filter data in the list by who submits it


I new with the power apps. I'm trying to create a power apps that filters the data in my list base on who submit the record.

The scenario is this.

1. Kurt log in the app

2. Once login the app should display only the records submitted by him or created by him in the list


Hope you can help me, and show me how to do it by screenshots


Accepted Solutions

The should be put at the beginning or end of the code separately. Example:



If(TextInput1.Text in Table1_2.Username && TextInput2.Text in Table1_2.Password, Navigate('List of Report Bugs',ScreenTransition.Fade), Navigate('Password Invalid',ScreenTransition.None))


Kindly adjust your main login code to what was working for you as the variable has nothing to do with the login code


Maintain the Filter code. That is okay


If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

View solution in original post


assuming your data source is Sharepoint, There is a standard created by field in your list, and you can filter by it.


Issue is that User() filters are not delegatable, so if you have more than 500-2000 records, you will need to make other arrangements.


OnStart of app




In your gallery:


Filter(ColTimesheets, 'Created By'.DisplayName = Var_user)


Super User
Super User

Assuming your Excel Table name is Table3, put this formula on the Items property of the Gallery;


Filter (Table3,'Submitted By'=User.FullName)


Am assuming that the submitted by Column has the users FullName.


If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Hi jlindstorm,


I don't have 500 records in my data likewise can you show me how to create it



Updated my answer with an example.

IF you find your data goes over 500 records, you can go to the app settings and increase the delegation limit up to 2000 records

Impactful Individual
Impactful Individual

I like to give users an option to 'view all' or 'view mine' it can be a toggle, checkbox, whatever.


SortByColumns(Filter(Table3, 'Submitted By', User().DisplayName), Created, Descending),
SortByColumns(Table3, Created, Descending)

Hi eka24,


I've to use the formula but got some error " Filter (Table3,'Submitted By'=User.FullName)"




but when I've tried this one" Filter (Table1,'Submitted By'= User().FullName)" it shows the record but when I try to login with a different user in the power apps that i created it does show any records, maybe there is missing in the formula?


Sorry I left out () in the User (). FullName;


Filter (Table3,'Submitted By'=User().FullName)


If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Hi eka24,


How about the record of other user when I tried to log in using different user I still shows the record of Marvic not the record of Kurt. maybe I've missing something?





Impactful Individual
Impactful Individual

replace User() with Username

Helpful resources

UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Top Kudoed Authors
Users online (2,926)