In this video I talk / highlight five topics from Microsoft 365
1. Free Microsoft Certification Renewals: Christmas came early as Microsoft as how you can renew your Microsoft Certifications from next year Feb 2021, more details here: https://techcommunity.microsoft.com/t…
2. Microsoft Teams: List all Teams, Team Members and Team Channels – Patrick Gruenauer A simple PowerShell script from Patrick where he explains how to get all Teams, Onwers and users, more information here https://sid-500.com/2020/12/14/micros…
3. Import SharePoint to Dataverse for Teams with Power Automate – Shane Young: A great video from Shane Young where he explains in very detail how to copy data from SharePoint to Dataverse using Power Automate, this is a very practical scernario which I think we gonna use a lot in future, more information here: https://www.youtube.com/watch?v=mvWLm…
4. New ways to connect SharePoint to Microsoft Teams Great improvements from Microsoft around SharePoint connection in Microsoft Teams, more information here: https://techcommunity.microsoft.com/t…
In this blog I will talk about a simple PnP PowerShell script which adds Child Terms under each term following the same hierarchy in SharePoint Taxonomy / Metadata.
Note that the same script can be used in SharePoint Online, 2013, 2016 or 2019.
You can refer to below hierarchical structure:
Term Group (Region names) –> Term Set (Region) –> Countries –> Customer –>Mine
In this example I want to add a new term called “Mine missing” under each customer, so instead of doing it manually I will use a script to add Mine missing under each Customer for each country.
Connect-PnPOnline -url <<site url >>
#Here I have used term guid for Asia Pacific to point to a Term
$ParentTerm = Get-PnPTerm -Identity <<term guid>> -TermSet "Regions" -TermGroup "Region names" -IncludeChildTerms -Recursive
$countryterm = $ParentTerm.Terms
foreach($term in $countryterm)
$addterms = $term.Terms
foreach($addedterm in $addterms)
$ChildTerm = $addedterm.CreateTerm("Mine Missing", 1033, (New-Guid))
4.Cross platform PnP PowerShell preview version released by Erwin
5.App capabilities of Teams 6.Project Nucleus teaser
Transcript of the video:
Hello and Welcome everyone to very first Vlog of ”Last week in Microsoft 365”, since this is the first VLog ever I want to tell you what it is? In this series of videos I will be picking some of things I read or liked in Microsoft 365 area during last week and I will be telling you about in brief and if you like it you can find more about in the link pasted in YouTube video or in my blog post. So let’s gets started
1. First up is of course the champions of the community or I should say leaders of the community @vesajuvonen and @waldekm who finished 100th episode of their PnP weekly which was SP Dev Weekly when it started actually, If you would like to know the story of how it started you should listed or view the video (hint it points to one and only Chris Kent). They also discussed what is the purpose of these videos and it is very encouraging to know that they do this for the community to amplify their reach and also develop a bridge between community members and Microsoft. Do listen to this video highly recommended. Here is a link to it https://www.youtube.com/watch?v=Vs_8b…
2. Number second is that Scottish Summit has been announced and call for speakers expires on 31st Oct so if you have a nice cool topic please submit it, most amazing thing about this summit is that it will have 250 sessions and that too in different languages such as English, Spanish, German, French, Mandarin and my own Hindi. Plus they also have a program for new speaker like me so if you are going to speak for the first time they will help you out. So what is that you are waiting for either send a session or buy the tickets? Register here: https://sessionize.com/ss2021
3. Next up is the a Twitter announcement which I believe is important that there will be one admin center for SharePoint and OneDrive which of course make sense as both of them are so tied up so get ready for that one. Link: https://twitter.com/SharePoint/status…
4. Next up is announcement by father of PnP PowerShell @erwinvanhunen, that is preview version of cross platform PnP PowerShell has been released. In his blog post he explains why it took so long and what are the key changes coming up. So if you are using PnP PowerShell for your work or you rely it on running scripts this is an important information, please reach out to him on Twitter or read the blog. Blog: https://www.erwinmcm.com/cross-platfo…
5. Next one is something which widened my eyes when I looked into this on my Twitter feed, the picture. It shows all he App Capabilities of Teams which is fascinating as you can see it can do almost everything, right from embedded tabs, Bots, Messaging extensions, WebHooks and connectors as well so if you are planning to create an App for Teams do read this and understand what all can be achieved. All thanks to Bill Bliss (@bill_bliss ) for sharing this. Link to docs: https://docs.microsoft.com/en-us/micr… Tweet: https://twitter.com/bill_bliss/status…
6. Ok so the last one, and it is related to one of the big announcements which was mentioned in the Microsoft Ignite this year, that is Project Nucleus , as you are aware we got SharePoint Syntex out of Project Cortex and Nucleus was announced this year. A teaser of this was shown in SharePoint monthly community call – October 2020 at the end so if you would like to see just that part then find the link in YouTube video description or on my blog. So biggest thing you need to know that it allows web apps such as List to be available offline for browsing and editing capabilities. This teaser explains how it works and how they are doing it. It demonstrates a List with 100,000 items and also shows what happens in the backend and also how you can join Project Nucleus.
So let’s start with “yourclientid” and “yourclientsecret”, for these we need to login to Azure portal and do an “App Registration”. To call an Graph API you need an App to with correct access to resources.
There can be situations when your organizations decides to change name due to mergers, acquisitions or splits. In this case quite often users are migrated from one active directory to other. This will definetely have impact on SharePoint users, servers and configurations.
Generally active directory migrations are done in two steps
Migrate users and computers
Migrate servers and service accounts
This post will cover the first point, second one will be covered in second post.
Generally when users are migrated in active directory you would expect that Microsoft products will be handled automatically but strangely that is not the case with SharePoint due to the reason User Profile service works in SharePoint. Reason is that User Profile Service does not work with Secuirty Identifier (SID history).
Before you migrate the users another thing which needs to be taken care is that all the Web Applications needs to allow new domain to do that please refer to below TechNet article
If you are working in support you might get tickets to update a particular item as users are not able to update some columns as it’s locked due to some workflow or checks in forms´customization. The user in workflow is on leave or currently not available so as support you can do it from back via PowerShell.
It can be done via some simple PowerShell commands as below
$web = Get-SPWeb “Put site URL here”
$list = $web.Lists[“ListName”]
$item = $list.GetItemByID(46)
$item[“Status”] = “Approved”
So in above example first we create reference to the web we are going to work upon, then refer to list on which you are going to work upon.
Next step is to get a specific item by using ID and we are using GetItemByID function. As an example we have used item id 46, you need to replace this with your ID.
Next is to update a particular column value, here “Status” is a column name, which is being updated with new value “Approved”.
Last step “update” function is important else value will not be updated.