Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Restrict items shown by column value and logged in user

Posted on 2017-10-12
9
Medium Priority
?
34 Views
Last Modified: 2017-10-16
Created a new workflow and list for on boarding new hires. Would like to restrict user's abilities to view items based on the Direct Manager column. So that manager A can only see new hires with manager A assigned, and manager B can only see those assigned to manager B. How can I do this in SharePoint Office 365?

New Employee List - SP
0
Comment
Question by:canuckconsulting
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 4
9 Comments
 
LVL 32

Expert Comment

by:Jamie McAllister MVP
It used to be possible to create a view filter on a people column where the argument was equals [Me]. If that filter were on the Direct Manager column you should be good. However, it obscures the information it's not full security.
0
 
LVL 1

Accepted Solution

by:
Keyboard Cowboy earned 2000 total points
You can do this easily using speasyforms. A free package you can add to the site without farm admin privileges.  Google it.
0
 

Author Comment

by:canuckconsulting
@Jamie McAllister: That filter option did not seem to function properly. I was able to remove completed on boardies from getting displayed on the list though.
 
@Keyboard Cowboy: I am attempting to use the SPEasyForms. Got it installed and saved the changes for visibility rules, but the columns are still visible. Any thoughts on what may be preventing the application of new rules made?
Edit: Additionally, my 2013 workflow and ability to create 2013 workflows has gone away since installing SPEasyForms.
0
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
LVL 1

Expert Comment

by:Keyboard Cowboy
Hmm - that's strange -  I don't know what happened with 2013 Workflows.  We use them here as well as easyforms without a problem.  on easyforms - you must first move a column to a 'container' - in order to use selective displays.
Just create a container of type Column and just have one column.
Then drag/drop your field from defaultform into the container.  Then your rules should work.
I didn't writ easyforms but I use it on dozens of sites - all 2013 however.
0
 

Author Comment

by:canuckconsulting
It worked! Workflow is still unable to be edited, but it still works and was complete prior to the disappearance. Thank you for the replies!
0
 
LVL 1

Expert Comment

by:Keyboard Cowboy
I'm puzzled why it affected your workflows at all.  I've been using it for years and never seen it interfere with workflows of any kind.
0
 

Author Comment

by:canuckconsulting
Turned out to be a custom permission set I created. Removed the permissions and everything works again.
0
 
LVL 1

Expert Comment

by:Keyboard Cowboy
terrific - I love speasyforms... but be careful - do not edit any of the forms in SPD.  If you mess with original forms - it can easily break speasyforms.  If you re-create (for example) editform.aspx back to the original, easyforms won't recognize the newly created form and the only way out is to re-create the list!
1
 

Author Closing Comment

by:canuckconsulting
SPEasyForms resolved this issue. Some precautions to mention would be to remove custom created permission sets from assignment to groups, and beware editing the forms through SPEasyForms. Thank you for the responses!
0

Featured Post

Veeam Task Manager for Hyper-V

Task Manager for Hyper-V provides critical information that allows you to monitor Hyper-V performance by displaying real-time views of CPU and memory at the individual VM-level, so you can quickly identify which VMs are using host resources.

Join & Write a Comment

Cancel future meetings from user mailboxes in Office 365 using Remove-CalendarEvents
Microsoft Office 365 is a subscriptions based service which includes services like Exchange Online and Skype for business Online. These services integrate with Microsoft's online version of Active Directory called Azure Active Directory.
This Experts Exchange video Micro Tutorial shows how to tell Microsoft Office that a word is NOT spelled correctly. Microsoft Office has a built-in, main dictionary that is shared by Office apps, including Excel, Outlook, PowerPoint, and Word. When …
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…

636 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