Forum Discussion
How to add members to a specific view
HI,
I have created a MS list. I found how to share the list with team members but thats not enough. There is an option wherein we can create a specific type of view for specific set of users. I have created 2 separate views where few columns of the list will be visible to one set of user & few to other type of users.
Now how I can decide which of those users who can see view 1 & which are the users who will be able to see view 2?
I could find how to share list with other users but how to share a list with other users by linking a specific view to them?
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.
