Show sharepoint list elements based on field

%3CLINGO-SUB%20id%3D%22lingo-sub-2414529%22%20slang%3D%22en-US%22%3EShow%20sharepoint%20list%20elements%20based%20on%20field%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2414529%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20all%2C%3C%2FP%3E%3CP%3EI%20have%20a%20question%20and%20i%20would%20like%20to%20know%20if%20its%20possible.%3C%2FP%3E%3CP%3EI%20have%20a%20sharepoint%20list%20with%20elements%20i%20create.%26nbsp%3B%20These%20elements%20have%20persons%20type%20of%20field%20name%20%22Assigned%20to%22%20field%20where%20i%20put%20the%20person%20that%20is%20responsible%20of%20the%20information%20of%20that%20specific%20list%20element.%26nbsp%3B%20I%20want%20to%20give%20access%20to%20those%20responsible%20persons%20to%20access%20the%20list%2C%20but%20only%20to%20those%20elements%20that%20have%20their%20name%20in%20the%20Assigned%20to%20field.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIve%20seen%20the%20option%20of%20permission%20level%20based%20on%20the%20creator%2C%20but%20in%20this%20case%20they%20wont%20create%20the%20item%2C%20i%20will.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20ways%20i%20can%20do%20what%20i%20desire%3F%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2414529%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2414978%22%20slang%3D%22en-US%22%3ERe%3A%20Show%20sharepoint%20list%20elements%20based%20on%20field%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2414978%22%20slang%3D%22en-US%22%3E%3CP%3EHello%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1070723%22%20target%3D%22_blank%22%3E%40Jsanjur%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhat%20if...%26nbsp%3B%3C%2FP%3E%3CUL%3E%3CLI%3ECreate%20a%20%3CSTRONG%3Epersonal%3C%2FSTRONG%3E%20view%20with%20the%20same%20columns%20(This%20will%20allow%20you%20to%20see%20everything)%26nbsp%3B%3C%2FLI%3E%3CLI%3EAdd%20a%20filter%20to%20your%20default%20view%3A%3CBR%20%2F%3E%3CUL%3E%3CLI%3ESelect%20%22Show%20items%20only%20when%20the%20following%20is%20true%3A%22%20then%20use%20this%3A%20%3CSTRONG%3EAssigned%20To%3C%2FSTRONG%3E%20equals%26nbsp%3B%3CSTRONG%3E%5BMe%5D%26nbsp%3B%3C%2FSTRONG%3E(This%20will%20allow%20users%20to%20see%20just%20their%20tasks)%3C%2FLI%3E%3C%2FUL%3E%3C%2FLI%3E%3CLI%3ECreate%20a%20new%20permission%20level%20(site%20level)%20based%20on%20what%20they%20have%20right%20now%20and%20UNCHECK%20%22%3CSPAN%3EManage%20Personal%20Views%20%26nbsp%3B-%26nbsp%3B%20Create%2C%20change%2C%20and%20delete%20personal%20views%20of%20lists.%3C%2FSPAN%3E%22%20(This%20will%20prevent%20users%20to%20create%20personal%20views%20and%20see%20all%20the%20list%20items)%3C%2FLI%3E%3CLI%3EGo%20to%20your%20list%20%26gt%3B%20list%20settings%20%26gt%3B%20Permissions%20for%20this%20list%20%26gt%3B%20Stop%20inheriting%20permissions%20and%20then%2C%20change%20the%20current%20permissions%20and%20use%20the%20%22custom%22%20you%20created%20in%20the%20previous%20step.%26nbsp%3B%3C%2FLI%3E%3C%2FUL%3E%3CP%3EKeep%20in%20mind%20that%20this%20solution%20only%20works%20as-is.%20If%20you%20need%20to%20have%20more%20VIEWS%2C%20you%20should%20find%20a%20way%20(maybe%20the%20same%20steps)%20to%20%22block%22%20them.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hi all,

I have a question and i would like to know if its possible.

I have a sharepoint list with elements i create.  These elements have persons type of field name "Assigned to" field where i put the person that is responsible of the information of that specific list element.  I want to give access to those responsible persons to access the list, but only to those elements that have their name in the Assigned to field.

 

Ive seen the option of permission level based on the creator, but in this case they wont create the item, i will.

 

Any ways i can do what i desire?

Thanks

1 Reply

Hello @Jsanjur

 

What if... 

  • Create a personal view with the same columns (This will allow you to see everything) 
  • Add a filter to your default view:
    • Select "Show items only when the following is true:" then use this: Assigned To equals [Me] (This will allow users to see just their tasks)
  • Create a new permission level (site level) based on what they have right now and UNCHECK "Manage Personal Views  -  Create, change, and delete personal views of lists." (This will prevent users to create personal views and see all the list items)
  • Go to your list > list settings > Permissions for this list > Stop inheriting permissions and then, change the current permissions and use the "custom" you created in the previous step. 

Keep in mind that this solution only works as-is. If you need to have more VIEWS, you should find a way (maybe the same steps) to "block" them.