Forum Discussion
How to add members to a specific view
You can not share a view with different users than the list itself.
But there is a workaround:
Create two Lists.
One list should have all the columns you want everybody to see.
The other list has the "hidden" columns.
Now create a lookup column from the "hidden" list to the "public" list.
Configure all additional columns from the source list to be displayed in the "hidden" list.
You can do this In the "More options" section of the column settings of the lookup column.
This has the effect that you will have all the columns from the "hidden" and "public" lists in the hidden list, but just the columns from the "public" list in the "public" list.
But this does not work for certain field types like person- or taxonomy Fields as they are not projectable.
You could alternatively try to create a PowerApp or a custom spfx solution that just displays the columns a user should see...
Or create SitePages with list view webparts that just contain the views and change permissions on the pages.
But then the data itself will still be visible/editable if the user accesses the list in any other way.
- Thanks for your reply & help. Actually I want a specific group of users to see specific rows. E.g. I want to show the users only specific items where that person's name is updated in column 'Name'. I have created a view by adding a filter as 'Name=[Me] but now how can I assign this view to a specific users or a group so that those users se only their items?
harshadr
Well that depends....
You could simpley create a new sitepage and add the lists webpart to it. Then select your view to be displayed and hide the "See All" button
This has the advantage that you can also add instructions for your users to the page.
Then you can change permissions for that page and make it ony visible for certain users. Or simply hide it from the navigation using audience targeting.
Then don't tell your users about the list itself and hide it.
But if one of your users manages to find the list url then they can get arround that.
Or alternatively:
Create a flow that on list item update modifies the permissions for a given list item and makes sure that it is only visible for the users in your "Name" column.
In that case just these users will be able to see the items, regardless of the selected view.harshadr Unfortunately, currently there is No way to use target Audience in SharePoint Modern List views.
When you create a list view with [Me] filter, you don't need to share this specific list view with users. All users having access to list view can access this view from "Switch view options" from the top:
As necessary filter is already added to list view, they will only see the items where they have added to "Name" column. If any user is not added in "Name" column for any of the list rows, they will not see the respective list items in this view.
If you want to try suggestions by SvenSieverding, here is one article which will help you to follow the steps: Show/Hide See all link from SharePoint list/library web parts
Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.
