Solved

Controlling access to a list

Posted on 2016-09-21
14
62 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
Comment Utility
0
 
LVL 8

Author Comment

by:Koen
Comment Utility
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 14

Expert Comment

by:SneekCo
Comment Utility
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
 
LVL 12

Accepted Solution

by:
Ramkisan Jagtap earned 500 total points
Comment Utility
0
 
LVL 8

Author Comment

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

Expert Comment

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

Author Comment

by:Koen
Comment Utility
@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
Free Gift Card with Acronis Backup Purchase!

Backup any data in any location: local and remote systems, physical and virtual servers, private and public clouds, Macs and PCs, tablets and mobile devices, & more! For limited time only, buy any Acronis backup products and get a FREE Amazon/Best Buy gift card worth up to $200!

 
LVL 14

Expert Comment

by:SneekCo
Comment Utility
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
Comment Utility
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
Comment Utility
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
Comment Utility
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
Comment Utility
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 14

Expert Comment

by:SneekCo
Comment Utility
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
Comment Utility
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

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Suggested Solutions

There is one common problem that all we SharePoint developers share: custom solution deployment. This topic can't be covered fully in this short article, so all I want to do in this one is to review it from a development-to-operations perspectiv…
We had a requirement to extract data from a SharePoint 2010 Customer List into a CSV file and then place the CSV file into a directory on the network so that the file could be consumed by an AS400 system. I will share in Part 1 how to Extract the Da…
Here's a very brief overview of the methods PRTG Network Monitor (https://www.paessler.com/prtg) offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…
When you create an app prototype with Adobe XD, you can insert system screens -- sharing or Control Center, for example -- with just a few clicks. This video shows you how. You can take the full course on Experts Exchange at http://bit.ly/XDcourse.

772 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now