3. Self-service Microsoft Form for external guests to use Power App – John Liu Great blog from John Liu for a practical situation that is adding a a guest user of Power App to Tenant http://johnliu.net/blog/2020/11/self-…
4. 6 Power BI Reports for Microsoft Teams Call Quality Dashboard (CQD) – Tom Arbuthnot Nice description from Tom about Power BI reports from Teams Call Quality Dashboard https://tomtalks.blog/2020/02/6-power…
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))
SharePoint Roadmap Pitstop Oct 2020 – Mark Kashman
Extend SPFx solution testability – Marcin Wojciechowski
GA Microsoft To Do API in Microsoft Graph – Microsoft 365 Dev team
What’s new in Microsoft Teams? – Oct 2020
Hello and welcome all to series “Last week in Microsoft 365”, this is the fourth video in this series in and we have 5 topics to be highlighted this week which I liked.
1. First one is something which really inspired me when I saw this post from Matt-Collins about his 366 days video streak on YouTube and me being a new YouTuber it was great to see someone else success in this area so a big shout put to Matt-Collins of putting this through so do visit his YouTube page and check awesome videos. You can also follow him on Twitter, his videos is mostly about Dynamics 365 and Power Platform
2. Second topic is SharePoint Roadmap pitstop Oct 2020 from Mark Kashman, since the last week also was month end which means we have bunch of Roadmap Pitstops. In this you also have Podcast where Mark talks to Harsh about new file sharing experience in teams channels, chats and also some other bunch of updates
3. So the third one is which I saw on Twitter from Marcin where he has created a test sample projects for SP Developers which means how to create stubs to test out your app or web part like an example he has given to simulate Mock Order and Mock User provider, so have a look, I think this has good use case for testing.
4. The fourth one is General Availability of To Do API In Microsoft Graph API which is a great news as I believe lot of people might have been waiting for this, it’s a bunch of CRUD operations on Tasks list and linked resources
1.Building a Me-experience in Microsoft Teams by Waldek
2.How to use Microsoft Teams Templates as end user and Admin – Paolo Pialorsi
3.General Availability of Microsoft Graph Teams Membership API – Brian T Jackett
4.Improved News / Page Publishing Exprience –Marc D Anderson
5.Power Automate Desktop October 2020 update
Transcript of the video:
Hello and welcome all to series “Last week in Microsoft 365”, this is the second video in this series and we have 5 topics to be highlighted this week which I liked.
1. First one is the Building a Me-Experience in Microsoft Teams which I got to know from Waldek’s blog, as it says there is no “I” but Me in Microsoft Teams. Basically it explains how you can utilize SharePoint Framework to offer a Me-Experience where users can start their day seeing their personal information. The article explains each options in very detail. So how to do it
a. Embed a modern SharePoint page: this approach is great as it does not any coding and can be done by creating modern page with different web parts and embedding it as Teams tab
b. Build a multi tab personal teams app: this requires some coding effort but not so difficult as you can steps are quite self explanatory
2. Second topic is from Paolo Pialorsi where he explains how to use recently introduced Microsoft Teams templates as an end user and Admin. He walks you through all details of the how to create a template etc from Admin portal. He also explains how you can utilize Microsoft Graph explorer Link: https://www.youtube.com/watch?v=-YQxF…
3. So the third one is General Availability of Microsoft Graph Teams Membership API which I saw from a Tweet of Brian T Jackett, basically it is an announcement made regarding Microsoft Graph Team Membership APIs that is a newly added API which adds , removes users faster. As we can see the article was originally written by Abhishek Anand. Link: https://twitter.com/BrianTJackett/sta…
4. The fourth one is also regarding a roadmap announcement which I came to know more Marc D Andersson where we will have an improved expriences in which users needs to input mandatory fields before publishing a news or page. This is planned to be released in Oct 2020 Link: https://twitter.com/sympmarc/status/1…
5. The last one today is related to Power Automate Desktop October 2020 update. Recently Microsoft has released Power Automate Desktop and lot of improvements will be released soon so here is a summary of all those. If you want to try Power Automate Desktop please refer to link pasted in description Link: https://flow.microsoft.com/en-us/blog…
Learn how to use conditional formatting to customize SharePoint or Microsoft List forms. Bascially you can show or hide columns based on conditional values of other columns.
Check the video below to understand how it works, you can also read the transcript below
Hello and welcome all to this new series and also first video of the series where we will go through a Microsoft 365 topic. Today’s topic is related to Microsoft Lists and specifically how to show or hide columns based on conditional formatting.
Conditional formatting is a concept which has been introduce recently in Lists and has gained lot of popularity for formatting list column, views, coloring, text formatting etc. Microsoft recently has added lot of options around this but the I will be showing today how to hide or show columns in forms based on value of other columns.
For this example I have created a “Content scheduler” Microsoft list where I am storing when to publish content for my YouTube videos, I have added two items and my objective is to show column “Published Link” when status is “Ready to publish” OR “Published” because the link is not yet ready in other cases, very simple.
So let’s start with this. The same formula works in all 3 forms that is new , edit and view =if([$Status]==’Ready to publish’ ||[$Status]==’Published’,’true’, ‘false’)
You can see that I have here used OR parameter and similarly you can also use AND or NOT operator. It is important to put a logic which is applicable of handling all forms. It took sometime for me to get the OR operator right but finally it worked.
There are certain limitations such as below column types cannot be used in conditional formatting
Person columns with multiple selections
Multiple choice column
Time calculations in DateTime column
Managed Metadata columns
Before this feature was added in SharePoint online we had to rely on Power Apps or SPFx development which I think was an over kill for such a thing but now this is available OOB and this really adds value to Microsoft Lists.
So ya that’s it in this video if you have any questions or suggestions please reach out to me in Twitter, Linked in or in YouTube comments, please share the video and subscribe the channel if you like it.
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.