Restrict items shown by column value and logged in user

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
canuckconsultingAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Jamie McAllister MVPSharePoint ConsultantCommented:
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
Keyboard CowboyCommented:
You can do this easily using speasyforms. A free package you can add to the site without farm admin privileges.  Google it.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
canuckconsultingAuthor Commented:
@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
Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

Keyboard CowboyCommented:
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
canuckconsultingAuthor Commented:
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
Keyboard CowboyCommented:
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
canuckconsultingAuthor Commented:
Turned out to be a custom permission set I created. Removed the permissions and everything works again.
0
Keyboard CowboyCommented:
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
canuckconsultingAuthor Commented:
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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SharePoint

From novice to tech pro — start learning today.