SharePoint Excellence

Microsoft has launched a new update on 11 March 2022 that is helpful for Teams Administrators of a Tenant. With this update Teams Administrators will get a list of all Teams for a user is a member of in the Teams admin center. Earlier there was no way from Teams Admin center and forced to use PowerShell Script for this. Get-Team -User vivek.jagga @ sharepointexcellence.com To view the list of Teams for a user is a member of in Teams Admin Center, execute the below steps  Go to Teams Admin Center Click to Users --> Manage Users Select a user for that you wish to retrieve the list of Teams for which the user is member. This will open the User Detail page Now click to the Teams tab. System will show to view all the teams that the user is a part of For more details, go through Microsoft roadmap feature ID 87969 and Message Center  MC332869

Introduction SharePoint administrators always want to know which user is accessing any site or site collection extensively and which user has access to the site but not using it. The other site details required are related to traffic, access, edit, etc. The user's behavior changes as per the nature of the site and their working department like project team site, department site, and managerial workspace. Fortunately, Microsoft 365 has given multiple methods to generate or view various reports related to SharePoint usage. We will check all the methods one by one and see how they provide the required results. Several options are available at different parts in SharePoint Site or Admin Center where the Administrator can check status or create reports. Method-1. Check Site Usage in Site Contents Page. The Site contents page shows the analytics data like their unique visitors, total site visits, average time spent by the user, etc. The report can be generated for multiple days like 7, 3...

Microsoft is focusing on collaboration and MS Teams is most popular now a days. We can update settings / profile from MS Teams and other Office 365 documents. Sometimes we may faced issue related to cache, it means that we are updating something and its not working on our local machine only. Same situation was with me, user had changed his name and its available correctly for other team member but on his local machine its old one even in all Office 365 clients (MS Word, Excel, etc.). Manually tried to clean up some files but its not working. So drafted a PS script that worked.  Sharing that PS snippet with you all so that you can also save your time. PowerShell script at GitHub  Clean MS Teams Cache $VerbosePreference = "Continue" # Force Close any Teams Process Get-Process -Name "Teams" | Stop-Process -Force # Get Microsoft Teams Paths $TeamsRemovePath = @() $TeamsRemovePath += Join-Path -Path ([Environment]::GetFolderPath('ApplicationData')) -ChildPath (...

Overview While deployment of apps / add-ins or SPFx solutions to SharePoint Online App Catalog, this solution will be available to all of collections in your tenant as it is centrally deployed. This may lead to a lot of confusion when you are working with a lot of solutions in your Tenant, as all of solutions is available to all site collections as it is deployed centrally in Tenant app catalog. To overcome this problem, Microsoft has introduces Site Collection App Catalog.With the introduction of site collection app catalogs, tenant administrators can enable app catalog on the specific sites. Once enabled, site collection administrators can deploy SharePoint add-ins and SPFx solutions that will be available only in that particular site collection. The following schema illustrates using site collection app catalogs Use below script to Enable / disable site collection app catalog To Enable Site Collection App Catalog $siteUrl = "https://yourdomain-admin.sharepoint...

OneDrive is a part of Office 365. This cloud service from Microsoft allows you to access data anywhere, anytime. One Drive for Business has numerous advantages for businesses as it makes it easy to access documents, speeds up the sharing of data, and facilitates collaboration within different departments of the organization. OneDrive for Business has helped many business organizations to grow many folds by ensuring better document management and collaboration. Migrate Windows File Server data to Office 365 Here is the brief procedure to migrate Windows file system data to Office 365 – Sign in to Office 365 account Click the App Launcher icon at the top left-hand side Click the Office 365 icon Click Upload and Open Browse the desired files and click Open Files get uploaded After the successful upload, the file will automatically open There are two other methods too which you can use to upload data – SharePoint Migration tool It is a free tool which y...

Overview When we are working with Office 365 in our organization, some time there is requirement to connect on premise AD to get feed and update it. In this article, I’m explaining a case; export data from AD only for specific (custom) attribute and update it in SharePoint user profile. Requirement We are working on Office 365 and in user profile we have created some additional custom attribute. By default, Office 365 supports sync only default properties with AD. To sync additional custom properties, we have to write custom sync engine. Microsoft has released API to sync additional attributes. Solution Microsoft has released Bulk update custom user profile properties for SharePoint Online APIs to direct sync custom attributes from JSON feed file. To achieve solution, below are the steps Create and upload JSON feed file Feed output of step 1, to Microsoft Bulk User Import API Check the status of an import job Create and upload a JSON feed file It’s the im...

Users who are are using Office Mix to create and share interactive online videos based on PowerPoint presentations, got an email last week that Microsoft is retiring the service on May 1, 2018. If you are one of the affected users, please continue with this article. Microsoft will bring the best features of Office Mix directly into PowerPoint, Microsoft Stream, and Microsoft Forms for Office 365 subscribers on Windows PCs without any additional add-in. As the service becomes obsolete, this also means that Microsoft will delete every Office Mix content from their server. In order to avoid losing your data saved into Office Mix workspace, you need to migrate them to Microsoft Stream, or download it into your OneDrive workspace. Everything you need to know about the migration, and the future of these features, are collected into this MS help article: https://support.office.com/en-us/article/Migrate-your-content-from-Office-Mix-c1c04f84-a7bb-4602-9645-258017155258?ui=en-US&rs=en-U...