cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Leinad
Level: Powered On

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.
1 ACCEPTED SOLUTION

Accepted Solutions
Leinad
Level: Powered On

Re: Filter on SP list in PowerApps

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

 

 

4 REPLIES 4
leyburn19
Level 10

Re: Filter on SP list in PowerApps

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

 

set(VarUser,user.Fullname)

 

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"

 

Leinad
Level: Powered On

Re: Filter on SP list in PowerApps

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.

 

 

leyburn19
Level 10

Re: Filter on SP list in PowerApps

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

Leinad
Level: Powered On

Re: Filter on SP list in PowerApps

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

 

 

Helpful resources

Announcements
firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

FirstImage

Power Platform World Tour

Coming to a city near you

thirdimage

PowerApps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

FourthImage

Join PowerApps User Group!!

Connect, share, and learn with your peers year-round

SecondImage

Power Platform Summit North America

Register by September 5 to save $200

Users Online
Currently online: 43 members 4,900 guests
Please welcome our newest community members: