Share
ReportHow to fliter data using Created By In sharepoint list?that means Only show my data.
Categories:
You’re offline. This is a read only version of the page.
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
#1
WarrenBelz
146,660
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
66,004
Most Valuable Professional
All responses (
Answers (