Forum Discussion

KatheSles's avatar
KatheSles
Copper Contributor
Oct 04, 2023

Give access to the files with a specific column choice

Hello everyone, 

 

Let me explain the problem first:

Imagine you have a channel on organization in Teams, you have two groups of people: A and B.

Group A has access to the whole channel, but group B only can see the files that are contributed to one specific column choice. Look at the attached screen1.

I created a new column (Project), so I need to give access to this folder in the channel to the group B, BUT so they can only see the files marked as "choice2" in this column. Is this possible to implement?

 

I truly think that teams does not have such options, but still worth trying.

Thanks in advance to everyone 🙂

  • LeonPavesic's avatar
    LeonPavesic
    Silver Contributor

    Hi KatheSles,

    there is no built-in way to restrict access to files in a Teams channel based on a column choice.

    However, there are a few workarounds that you can use:

    1. Use a separate channel for each column choice:

    This is the simplest option, but it can be a bit complicated if you have a lot of column choices. To do this, create a separate channel for each column choice, and then assign the appropriate permissions to each channel.

    2. Use a third-party tool:

    There are a number of third-party tools that can help you to restrict access to files in Teams channels based on column choices. Some popular options include:

    • AvePoint Collaboration Governance
    • Colligo
    • PointClick Solutions

    3. Use a SharePoint library:

    You can also use a SharePoint library to store your files, and then link to the SharePoint library from your Teams channel.
    Once you have linked to the SharePoint library, you can use SharePoint's permissions system to restrict access to the files based on column choices.

    This option is more complex than the others, but it offers the most flexibility and control.

    Please click Mark as Best Response & Like if my post helped you to solve your issue.
    This will help others to find the correct solution easily. It also closes the item.


    If the post was useful in other ways, please consider giving it Like.


    Kindest regards,


    Leon Pavesic
    (LinkedIn)

    • KatheSles's avatar
      KatheSles
      Copper Contributor
      Thanks a lot for your answer!

      Can you please give me some directions how to implement the third choice with SharePoint Library?

      • the only part that is important with the 3rd option is that you need to be aware that if it is a linked library it will not directly sync to onedrive on the pc.

Resources