Solved

Controlling access to a list

Posted on 2016-09-21
14
78 Views
Last Modified: 2016-10-01
I have a list on sharepoint online, which holds info about users.
I would like the users to only have (read/write) access to their own (only 1) item in the list.

I tried this manually and it seems to work, but I'd need a way of setting it automatically (once for all items) when I upload them (initial load)

thanks
0
Comment
Question by:Koen
  • 7
  • 3
  • 2
  • +2
14 Comments
 
LVL 8

Expert Comment

by:Leo
ID: 41809917
0
 
LVL 8

Author Comment

by:Koen
ID: 41810188
no, not really, it explains how to create and set rights using the sharepoint interface...(i know how to do that).
I'm looking for a way to either apply specific rights on specific list items (using a field from the item) in bulk on a big list (sharepoint script/code/workflow/...)
or alternatively
creating the list items in an automated way (e.g. vba - I can do that), and set the rights for each of these items automatically at the same time (through coding)
0
 
LVL 17

Expert Comment

by:Walter Curtis
ID: 41810632
Under list settings --> advanced settings you can determine what type of access users have to the items. That may meet your needs...

Hope that helps...
0
Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

 
LVL 12

Accepted Solution

by:
Ramkisan Jagtap earned 500 total points
ID: 41810642
0
 
LVL 8

Author Comment

by:Koen
ID: 41810660
I will test sharepoint designer tomorrow... will let you know how that goes.
0
 
LVL 5

Expert Comment

by:Isaac
ID: 41811360
Follow "SneekCo" suggestion and look for this image
EditMyItem
0
 
LVL 8

Author Comment

by:Koen
ID: 41812381
@Isaac and SneekCo

Hi, the settings looked promising...(and easy mainly)
Except, the creator of the items is the user who did the bulk upload, not the user who the line item is about...
So that does not help (unless if there is an easy trick to change the creator)

Checking the designer approach now...
0
 
LVL 17

Expert Comment

by:Walter Curtis
ID: 41812458
Thanks for the feedback. The designer approach works well, I have used it often. For you bulk upload you may want to use a workflow that sets the permissions, but also use the settings because the workflow is not %100 as the settings are. Although the chance or a workflow failing are slim, it could happen so I try to avoid points of failure and risks as much as possible.

Another , maybe more important questions may be, what are you trying to do? Using unique or granular permissions is not a great thing to do. If this is sensitive data, this is not a good thing at all, so give that some consideration also.

Good luck...

@Issac - thanks for the feedback.
1
 
LVL 8

Author Comment

by:Koen
ID: 41813648
it is a subscribe list (to some news info concerning specific location),people can adapt the location and whether they want Y/N receive info on that location.
We want them to update it themselves, but of course not change other peoples entries.

I cannot get the designer workflow to work...(but I have not a lot of experience with SP designer workflows, so it's probably me). Could someone elaborate on how to configure the workflow.
0
 
LVL 12

Expert Comment

by:Ramkisan Jagtap
ID: 41815861
please check the following article to create the workflow:

http://spcycle.blogspot.fi/2012/01/how-to-create-workflow-to-change-item.html
0
 
LVL 8

Author Comment

by:Koen
ID: 41817415
Thanks allready for the follow up...

I built the workflow, but i cannot publish it (error)...

I've stripped it down to a simple
replace rights on the current item giving me 'full control' (no variabels yet), still the same error

"Errors were found when compiling the workflow. The workflow files were saved but cannot be run."

I'm stumped... :-(
0
 
LVL 8

Author Comment

by:Koen
ID: 41817732
OK... some further investigation results in some intresting finds and (of course) new questions...

I have tried it on our SP 2013 farm and there I am able to publish the workflow. I can launch it on the individual items and it works...
Now I need to be able to run it on all items (automatically) and on SP online...

Keep you posted
0
 
LVL 17

Expert Comment

by:Walter Curtis
ID: 41817796
Looks like you are making progress. If this question has morphed from being about access to being about workflows, maybe close this questions and open a new question about workflows. In that way you will bring in more workflow expertise.

Good luck...
0
 
LVL 8

Author Closing Comment

by:Koen
ID: 41825017
Although the problem is only half solved, the answer from ramkisan pointing towards the SP desinger brought me closer to solving my issue
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Note:  There are two main ways to deploy InfoPath forms:  Server-side and directly through the SharePoint site.  Deploying a server-side InfoPath form means the form is approved by the Administrator, thus allowing greater functionality in the form. …
These days socially coordinated efforts have turned into a critical requirement for enterprises.
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…

831 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question