How to fliter data using Created By In sharepoint list?that means Only show my data.
Hi,
I am filtering a sharepoint list based on a column.
This is my filter query : Filter(IPHarvest,IPTitle=DataCardValue28.Text)
but I need list items with specific columns only and how to store this filtered items and display in a table.
Could anyone help me in this.
Hi,
If you want to Filter by the Created By field, you must note that in PowerApps it is called 'Author' and it is a lookup field.
To get the current user you can use the User() function.
Thus, your formula could look something like this:
Filter(List_Name, Author.Email = User().Email)
However, be careful that the filter will not be delegable because of the lookup filed, so if your list has more than 500 items, not all items will be filtered.
Hope this helps
WarrenBelz
198
Most Valuable Professional
MS.Ragavendar
108
stampcoin
80