Forum Discussion
Block certain files for certain groups
Looking for a way to block uploads of specific files in Teams, but only for certain groups or users within the enterprise. Can anyone help?
If you have Microsoft 365 or Office 2021, enter the following formula in a cell. It will spill to three cells automatically.
=FILTER(A2:A7, B2:B7>=LARGE(B2:B7, 3))The following will work in any version. Enter the following formula in F2 and confirm with Ctrl+Shift+Enter, then fill down to F4.
=INDEX($A$2:$A$7,MATCH(1,($B$2:$B$7=LARGE($B$2:$B$7,ROW()-1))*(COUNTIF($F$1:$F1,$A$2:$A$7)= 0),0))See the attached sample workbook.
1 Reply
ClaraJ99 It's not really possible.
This question is really about SharePoint and OneDrive, that's where all of Teams files live, and where a control would need to be applied. There is no simple block for particular file types however, you can prevent them syncing in OneDrive but not block browser uploads.
If you had E5 I guess you could use MCAS File rules to delete files of certain types.
Why do you want to?
