Forum Discussion

DanielaH's avatar
DanielaH
Brass Contributor
Apr 15, 2019
Solved

Dynamic item-level permissions?

Hello, 

 

I am in need of a solution for a scenario like this:

  • Employee submits a list item
  • Employee also specifies their Line Manager and Supervisor (their names / email addresses are captured in separate columns of the list item).

Requirement: Only the employee (submitter) and the specified Line Manager and Supervisor should be able to see this specific list item. 

 

I have seen several older posts where this was considered impossible but with the changing landscape in O365 I wondered if anyone has found a clever way to do this?

 

Thanks so much in advance!! <3 

  • DanielaH - Just an Idea I have never tried this, you can use Flows to set permissions.

     

    https://noellawlor.wordpress.com/2018/01/18/setting-sharepoint-item-list-permissions-with-flow/

14 Replies

  • DanielaH 

    The only 2 dynamic filter values available are ME and TODAY. If you have a people picker field for manager, you can create your default view with view filters:

    CREATED BY equals ME 

    or 

    MANAGER equals ME 

    *add square brackets (sorry I don't see these on my phone's keyboard!)

    And lock down view settings / list permissions, etc. so that users cannot create views. 

  • Sai Gutta's avatar
    Sai Gutta
    Iron Contributor

    DanielaH - Just an Idea I have never tried this, you can use Flows to set permissions.

     

    https://noellawlor.wordpress.com/2018/01/18/setting-sharepoint-item-list-permissions-with-flow/

    • DanielaH's avatar
      DanielaH
      Brass Contributor

      Sai Gutta Thank you!

      The article links to a great instructional video explaining exactly how to fulfil my requirement :D

      • One thing you must consider here is that since you are breaking permissions per item, you could potentially hit the limit in the number of unique permissions allowed in a list (5000)

Resources