web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Filter by user in powe...
Power Apps
Answered

Filter by user in powerapp and sharepoint list

(0) ShareShare
ReportReport
Posted on by 181

Hi there,

 

I have a list on a sharepoint teams site. I have created a powerapp to allow users to view the items in the list and to add new items to the list. I have a search bar with the following :

 

SortByColumns(Filter('My Table',TextSearchBox1.Text in Title),"Title",If(SortDescending1,Descending,Ascending))

 

This is currently working exactly how I need it to, however I want to add an extra filter that will allow users to see all items that were created by them. I have tried several things however they arent working or the search bar stops working.

 

I have a button that users can push and that would toggle the list to show either all items or items created by the user. This will be determined by a column with the name 'ItemCreator' and it is just a standard text box. I do have the default value set as:

 

User().FullName

 

On the button, I have the following under the 'OnSelect' section:

 

UpdateContext({FilterMyInteractions: !FilterMyInteractions})

 

Can I please have some help implementing this so that my search bar will still work?

Categories:
I have the same question (0)
  • Verified answer
    mdevaney Profile Picture
    29,991 Moderator on at

    @Amber_L 

    Hi there!  I've got some code you can try.  Give it a shot and let me know.

     

    My assumption is you only want to show the current user's records when FilterMyInteractions is True.

     

    SortByColumns(
     Filter('My Table',
     TextSearchBox1.Text in Title,
    If(FilterMyInteractions,ItemCreator=User().FullName,ItemCreator=ItemCreator) ), "Title", If(SortDescending1,Descending,Ascending) )

     

    ---
    Please click "Accept as Solution" if my response helped to solve your issue so that others may find it more quickly. If your thought the post was helpful please give it a "Thumbs Up."

  • Amber_L Profile Picture
    181 on at

    That works perfect! I tried that code but I was just placing it in the wrong spot.

    Thanks for your help!

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 379 Most Valuable Professional

#2
11manish Profile Picture

11manish 203 Super User 2026 Season 2

#3
MS.Ragavendar Profile Picture

MS.Ragavendar 128 Super User 2026 Season 2

Last 30 days Overall leaderboard