SharePoint View Filter By User | SharePoint List View Filter By Current User Email

Do you want to filter the SharePoint List view by current user? Well, in this SharePoint Online tutorial, we will discuss everything about SharePoint View Filter By User, like how to work with SharePoint list view filter by the current user and many more:

  • How to create a SharePoint list View that only shows items created by the current user
  • How to filter the SharePoint list column with the username of the current user

SharePoint View Filter By User

  • The phrase “SharePoint view filter by user” refers to setting up a view in Microsoft SharePoint to display items based on the user viewing the list or library.
  • This is frequently used to ensure users only see the information that belongs to them, improving privacy and security and simplifying and customizing the view.

SharePoint List View Filter By Current User

  • It is similar to “filter by user,” but it specifically shows information based on the user currently logged in and viewing the SharePoint Online list/library. The page content changes to show only what is relevant to the current, logged-in user.
  • You can use the [Me] filter to filter a SharePoint view by user.
  • When the specified column (usually “Created By” or “Modified By“) is equal to [Me], the filter automatically displays items in the list or library that were created or last updated by the current user.
How to filter sharepoint list view by user

This is all about SharePoint List View Filter By Current User.

See also  SharePoint list view threshold [Everything you need to know]

Create a SharePoint View that only shows items created by the current user

Here, we will see how to create a SharePoint View that only shows items created by the current user. Or how we can filter the SharePoint list view based on the current logged-in user.

There are two ways to filter the SharePoint list view based on the user. Such as:

  • SharePoint View Filter By User [Using Filter By option]
  • SharePoint View Filter By User [Using Edit current view]

Approach -1: [Using Filter By option]

  • The below screenshot represents a SharePoint list [Products]. There is a column called Created By.
  • I want to create and filter a view based on the current user.
SharePoint View Filter By User
  • To do this, Expand Created By -> Filter by.
sharepoint list view filter by current user email
  • Select @Me and click on Apply.
sharepoint list view filter by current user
  • Then, the SharePoint list will appear with all the filtered records of the current user, as shown below.
sharepoint list view filter by user
  • Now, again, expand the View option from the command bar.
  • Click on Save view as.
sharepoint online list view filter by current user
  • Provide a new name to the view and click on Save.
sharepoint view filter by current user
  • Finally, the SharePoint list view has been created based on the current user.
sharepoint Online list view filter by user

This is one way to filter the SharePoint list view based on the current logged-in user.

Approach -2:

Here, we will discuss another approach to filter the SharePoint list view based on user.

  • In the SharePoint list, create a new view.
  • Select the created new view from the View option.
  • Again, expand the View option and click on the Edit current view.
How to filter sharepoint list view by current user
  • In the Edit view page, go to the Filter section and add a condition [Show the items when column:] like:
Created By is equal to [Me] And Modified By is equal to [Me]
  • Click on OK.
See also  Create a managed metadata navigation from Term Store in SharePoint Online

Refer to the image below.

filter sharepoint list view by current user
  • The filtered records created by the current user will be displayed in the SharePoint list.
How to filter sharepoint list view by user

This is another approach to filter the SharePoint list view based on the current logged-in user.

Filter the SharePoint list column with the username of the current user

Here, we will filter the SharePoint list column with the current user’s username and assigned user name.

  • In the below SharePoint list [Scheduled Events], you can see there are two-person columns, i.e.
  1. Event Manager
  2. Created By
  • I want to filter the SharePoint list view based on the current user and the assigned event manager.
How to filter SharePoint list column with username of the current user
  • Go to the List View option -> Select the view where you want to filter the user.
  • Again, go to the View option -> Click on the Edit current view.
Filter SharePoint list column with username of the current user
  • In the Edit view page, go to the Filter section and add a condition [Show the items when column:] like:
Created By is equal to [Me] And Event Manager is equal to Bijay Kumar Sahoo
  • Click on OK.

Refer to the image below.

sharepoint list show only items assigned to user
  • The filtered records created by the current and assigned users will be displayed in the SharePoint list.
Filter SharePoint list column with the username of current user

This is how to filter the SharePoint list column with the current user’s username and assigned user name.

Conclusion

This SharePoint Online tutorial covers all aspects of SharePoint View Filter By User, including how to use the current user’s view filter in SharePoint lists and more:

  • Create a SharePoint View that only shows items created by the current user
  • Filter the SharePoint list column with the username of the current user
See also  SharePoint PnP PowerShell examples (Best 25)

You may also like:

>