How to restrict access for a sharepoint list

%3CLINGO-SUB%20id%3D%22lingo-sub-1075255%22%20slang%3D%22en-US%22%3EHow%20to%20restrict%20access%20for%20a%20sharepoint%20list%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1075255%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%26nbsp%3B%3C%2FP%3E%3CP%3EI%20just%20created%20an%20SP%20list%20and%20would%20like%20visitors%20to%20only%20be%20able%20to%20add%20a%20query%20to%20the%20list.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20200px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F162643i074E9D92449605C1%2Fimage-size%2Fsmall%3Fv%3D1.0%26amp%3Bpx%3D200%22%20alt%3D%22Sp%20.png%22%20title%3D%22Sp%20.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EIs%20it%20possible%20to%20do%20that%20%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAnd%20is%20it%20possible%20to%20give%20these%20columns%20the%20orange%20color%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20200px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F162644i637A5431A66DD841%2Fimage-size%2Fsmall%3Fv%3D1.0%26amp%3Bpx%3D200%22%20alt%3D%22orange1.png%22%20title%3D%22orange1.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1075255%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-1076118%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20restrict%20access%20for%20a%20sharepoint%20list%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1076118%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F494326%22%20target%3D%22_blank%22%3E%40anthonyleduc%3C%2FA%3E%20%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThere%20are%20a%20couple%20of%20ways%20to%20set%20the%20permissions%20that%20you%20require%20%3A-%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E1.%20Change%20the%20advance%20settings%20in%20the%20list%20as%20below%3A-%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20633px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F162695i831485FC967D0C3A%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22list1.PNG%22%20title%3D%22list1.PNG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EThis%20will%20give%20the%20user%20the%20ability%20to%20Read%20what%20they%20have%20submitted.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E2.%20Use%20Power%20Automate%20to%20set%20the%20permissions%20once%20a%20new%20item%20has%20been%20created%20or%20move%20the%20item%20to%20another%20list.%20This%20is%20the%20more%20complicated%20option%20but%20allows%20more%20control.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHope%20that%20helps.%26nbsp%3B%3C%2FP%3E%3CP%3E%3CBR%20%2F%3EAndy%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

Hi, 

I just created an SP list and would like visitors to only be able to add a query to the list.

 

Sp .png

Is it possible to do that ?

 

And is it possible to give these columns the orange color?

 

orange1.png

 

Thank you

1 Reply

Hi @anthonyleduc ,

 

There are a couple of ways to set the permissions that you require :-

 

1. Change the advance settings in the list as below:-

list1.PNG

This will give the user the ability to Read what they have submitted. 

 

2. Use Power Automate to set the permissions once a new item has been created or move the item to another list. This is the more complicated option but allows more control.

 

Hope that helps. 


Andy