Forum Discussion
Understanding Limited Access
- Jun 27, 2021
If you have Excel 2019 or Excel in Microsoft 365, enter the following formula in B1:
=TEXTJOIN(", ",TRUE,IF(ISNUMBER(SEARCH({"Generic Mailbox","Distribution","Non-standard","NSSR"},A1)),{"Shared Mailbox","DL","Corporate Request","Non-Standard Service Request"},""))
This allows for more than one of the search terms in a cell.
Otherwise:
=IFERROR(INDEX({"Shared Mailbox","DL","Corporate Request","Non-Standard Service Request"},MATCH(TRUE,ISNUMBER(SEARCH({"Generic Mailbox","Distribution","Non-standard","NSSR"},A1)),0)),"")
Fill down from B1.
Hi Bhavpreet Bains,
As the article describes, "Limited Access" permission doesn't actually give the user the ability to see those items but is instead used under the covers to make things work (rendering the user experience, etc.) Hope that helps!
Stephen Rice
OneDrive Program Manager II
- Bhavpreet BainsAug 21, 2018Iron ContributorMakes sense. :)