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?