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

Filter on SP list in PowerApps

Can someone help me getting the right string to this. Or on the right path

Iin Powerapps I have an SP overview list, what shows all entries made from all users, can I filter the view to only show the entry made from the current user in the app.

Accepted Solutions

Used seach function, working now. Thanks for the reply.



View solution in original post

Memorable Member
Memorable Member

On the first screen create a variable in the property onstart:




Then use this to filter your gallery EG:


Filter(Source,Author=VarUser)  I think Author is teh field that stores the user name.  It might be "created"


Hej leybrun19


Can I Filter by Author in BrowseGallery ? I can not select Author as an Label in Gallery, or can I do that ? 


Created is the time and date on when the new item was created on on the SP list.



Ok - Authour does not allow selection and it might not be teh right person.   


In some apps I have added a ownername column and owner email so, when adding new records I:



If I use Patch()   I have it set a owner column to the User().Fullname and Email column to User().Email


If I use an edit form I add these columns and set  field defaults to User().Fullname etc  then hide the fields


I then do what I described above so teh user only sees their own records.  Yu need to put it in the variable firts as if you use the User().Fullname etc in the filter yu get a delegation notice. With the variable you do not

Used seach function, working now. Thanks for the reply.



View solution in original post

Helpful resources

News & Announcements

Community Blog

Stay up tp date on the latest blogs and activities in the community News & Announcements.

Power Apps Community Call

Power Apps Community Call- January

Mark your calendars and join us for the next Power Apps Community Call on January 20th, 8a PST

PP Bootcamp Carousel

Global Power Platform Bootcamp

Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.


Power Platform Community Conference On Demand

Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!

Top Solution Authors
Top Kudoed Authors
Users online (13,128)