Use Microsoft Graph in SharePoint Development Framework (SPFx) – Let’s Learn a M365 topic vlog 9

In this video I explain how to use Microsoft Graph in SharePoint Development Framework (SPFx) to show Microsoft Teams information such as ID and Display name of user who is logged in.

Subscribe to my YouTube Channel https://www.youtube.com/channel/UC6vLzWN-3aFG8dgTgEOlx5g if this helped you , to appreciate my work and keep me motivated.

It uses NoJavaScript Framework. Source code is available here: https://github.com/sinhakislay/SPFxMi…

Video covers following:

1. Demo of the App

2. Prerequisites

3. Simple steps – Node.js console

4. Code overview

  • Simple Steps – Node.js console
  • Create a folder – md spfx-graphAPI
  • Get to the folder – cd spfx-graphAPI
  • Use Yeoman SharePoint Framework Generator
  • Answer question as below – yo @microsoft/sharepoint
  • What is your solution name?: spfx-graphAPI
  • Do you want to allow the tenant admin the choice of being able to deploy the solution to all sites immediately without running any feature deployment or adding apps in sites?: Yes
  • Which type of client-side component to create?: WebPart
  • What is your Web part name?: SP Graph API
  • Which framework would you like to use?: No JavaScript framework
  • Use Microsoft Graph type declarations – npm install @microsoft/microsoft-graph-types

#spfx #microsoftgraph #sharepointdevelopment #development #SharePoint

Explains how to use Microsoft Graph in SharePoint Development Framework

This extension illustrates the following concepts:

  • Call Microsoft Graph from SPFx App
  • Capture Microsoft Teams details
  • Display infomation

Connect with me on Twitter or Linked In and follow YouTube Channel or my blog 

https://www.linkedin.com/in/kislaysinha

https://www.youtube.com/channel/UC6vL…

Create a SPFx App using Microsoft Graph Tookit 2.0 – Let’s Learn a Microsoft 365 Topic

Subscribe to my YouTube Channel https://www.youtube.com/channel/UC6vLzWN-3aFG8dgTgEOlx5g if this helped you , to appreciate my work and keep me motivated.

In this video I explain how to create an SPFx application in SharePoint using Graph Took Kit 2.0

Source code is available at this location with detail steps: https://github.com/sinhakislay/SPfx-g…

Video consists of following:

1. Talk about prerequisites

2. Code overview

3. How to set up and use Microsoft Graph Toolkit 2.0

4. Demo of the Web Part and Microsoft

Summary

This uses SharePoint Development Framework and Microsoft Graph Toolkit 2.0 Language used is TypeScript This showcases how to develop an SPFx App and load Microsoft Graph Toolkit components in SPFx web part Details of the source code and how to run etc is also described in video here 

Minimal Path to Awesome

#SPFX #MicrosoftGraph #Graphtoolkit #SharePoint #Yeoman #nodejs #npm

Connect with me on Twitter or Linked In and follow YouTube Channel or my blog 

https://www.linkedin.com/in/kislaysinha

https://www.youtube.com/channel/UC6vL…

Last week in Microsoft 365 – 19 Nov – 25 Nov 2020 – VLog 7

Subscribe to my YouTube Channel https://www.youtube.com/channel/UC6vLzWN-3aFG8dgTgEOlx5g if this helped you , to appreciate my work and keep me motivated.

n this 7th video of the series I discuss following topics:

1. Adding OOTB/Default Modern SPFx webparts to classic pages – Ram Prasad https://www.youtube.com/watch?v=tA3SX…

2. Handle your errors in Power Automate – Matt Weston https://www.youtube.com/watch?v=CvSZE…

3. Open an HTML file from Power Apps and host it within your solution – Terho Antila https://terhoantila.com/post/63538443… https://twitter.com/terhoantila

4. Configure the List form https://docs.microsoft.com/en-gb/shar…

5. New Bookings experience and capabilities help streamline scheduling – Jessica Wilczek https://techcommunity.microsoft.com/t…

#SharePoint #ListForms #PowerApps #PowerAutomate #MicrosoftBookings

YouTube Playlist

Connect with me on Twitter or Linked In and follow YouTube Channel or my blog 

https://www.linkedin.com/in/kislaysinha

https://www.youtube.com/channel/UC6vL…

Last week in Microsoft 365 – 03 Dec – 09 Dec 2020 – VLog 9

Subscribe to my YouTube Channel https://www.youtube.com/channel/UC6vLzWN-3aFG8dgTgEOlx5g if this helped you , to appreciate my work and keep me motivated.

In this video I discuss / highlight five topics related to Microsoft 365 from last week

1. Considerations for optimized performance in Power Apps A great article you should definitely read if you are going to create enterprise level Power Apps to understand what things to consider with respect to data source and connectors https://powerapps.microsoft.com/de-de…

2. Power Platform Weekly Issue Newsletter: A great selection of articles and easy way to be updated on Power Platform topics. Go read it and also subscribe https://www.ppweekly.com/issues/power…

3. Speed up npm install – Sergei Sergeev Great discussion how to speed up npm install https://twitter.com/sergeev_srg/statu…

4. Power Apps Editable Excel like Table – Reza Dorrani As usual great video from Reza explaining how to create editable excel like or SharePoint Grid style table https://www.youtube.com/watch?v=8I0Pt…

5. Azure Logic APP API Call Save a file to BLOB Storage – Gregor Suttie A great small blog from Gregor where he uses Logic App API call to csv file and store it in Blob storage, Link: https://techdailychronicle.com/azure-logic-app-api-call-save-a-file-to-blob-storage/

#LogicApps #PowerApps#npm #PowerPlatform #SharePoint #Microsoft365 #Microsoft

YouTube Playlist

Connect with me on Twitter or Linked In and follow YouTube Channel or my blog 

https://www.linkedin.com/in/kislaysinha

https://www.youtube.com/channel/UC6vL…

Last week in Microsoft 365 – 03 Dec – 09 Dec 2020 – VLog 10

Subscribe to my YouTube Channel https://www.youtube.com/channel/UC6vLzWN-3aFG8dgTgEOlx5g if this helped you , to appreciate my work and keep me motivated.

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…

5. Announcing public preview of the Microsoft Teams Activity Feed API on Microsoft Graph, more information here: https://developer.microsoft.com/en-us… #Microsoft #MicrosoftGraph

#PowerAutomate #MicrosoftTeams #SharePoint #Dataverse #PowerShell #MicrosoftCertifications

YouTube Playlist

Connect with me on Twitter or Linked In and follow YouTube Channel or my blog 

https://www.linkedin.com/in/kislaysinha

https://synkventures.com

https://www.youtube.com/channel/UC6vL…

Upload data from Excel in SharePoint using C#

There are many ways to upload data from excel in SharePoint. We can divide them in two categories

  1. SharePoint on premise: There is a good article which describes what are the ways available without any programming you can refer to it here: https://sharepointmaven.com/3-ways-import-excel-sharepoint/ . There are challenges in these methods, the biggest is that it does not allow all Column Types such as Metadata , Choice etc. Out of three explained there Import from excel is best but it will not allow Metadata column to be created
  2. SharePoint Online: Recently in SharePoint Online native support has been provided by Microsoft on uploading data from excel to SharePoint, there are few limitations but it works pretty well, you can refer to this article which has great details https://sharepointmaven.com/how-to-import-an-excel-spreadsheet-to-a-sharepoint-custom-list/

My blog talks about how you can use C# to upload data from excel to SharePoint.

Step 1: Read data from excel in C#: To do this the code is very simple but you need to have excel installed on the machine you are running the code.

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using Microsoft.Office.Interop.Excel; 

//Instantiate excel app and if not installed give a message
Application excelApp = new Application();
            if (excelApp == null)
            {
                Console.WriteLine("Excel is not installed!!");
                return;
            }

//load the workbook from where data needs to be read           
 Workbook excelBook = excelApp.Workbooks.Open(@"path of excel file including file name");
            _Worksheet excelSheet = excelBook.Sheets[1];
            Range excelRange = excelSheet.UsedRange;

            //get the number of rows and columns
            int rows = excelRange.Rows.Count;
            int cols = excelRange.Columns.Count;


//loop through them and print
            for (int i = 1; i <= rows; i++)
            { 
               for (int j = 1; j <= cols; j++)
               {

                //write the console
                if (excelRange.Cells[i, j] != null && excelRange.Cells[i, j].Value2 != null)
                {
                    Console.Write(excelRange.Cells[i, j].Value2.ToString() + "\t");

               }
}



Step 2: Add data to SharePoint list: Note that there are different column types supported by SharePoint but my main focus area is to how to insert data in column type Choice, Number, Metadata, Multi line text

 string siteUrl = "site url where data needs to be uploaded"
//create a context 
 ClientContext clientContext = new ClientContext(siteUrl);
//get the list in which data needs to be inserted
 Microsoft.SharePoint.Client.List list = clientContext.Web.Lists.GetByTitle("name of the list");
 //preparing list item which will be added                                                                                                
ListItemCreationInformation itemInfo = new ListItemCreationInformation();
ListItem listItemCreation = list.AddItem(itemInfo);

//this is needed for taxonomy / metadata field
 var taxonomySession = TaxonomySession.GetTaxonomySession(clientContext);
 var termStore = taxonomySession.GetDefaultSiteCollectionTermStore();

Once above is done we have to combine both so rest of the insert data code will be under 2nd for loop in read excel data part. Here we will assume that 1st column is a number, 2nd column a multi line text, 3rd a Taxonomy / Managed Metadata column, fourth a number column and fifth a choice column, please check the complete code below

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using Microsoft.Office.Interop.Excel;
using Microsoft.SharePoint;
using Microsoft.SharePoint.Client;
using Microsoft.SharePoint.Client.Taxonomy;
using System.Net.NetworkInformation;
using System.IO;
using System.Net;

namespace UploadDatatoSPfromExcel
{
    class Program
    {



        static void Main(string[] args)
        {

string siteUrl = "site url where data needs to be uploaded"
//create a context 
 ClientContext clientContext = new ClientContext(siteUrl);
//get the list in which data needs to be inserted
 Microsoft.SharePoint.Client.List list = clientContext.Web.Lists.GetByTitle("name of the list");
 //preparing list item which will be added                                                                                                
ListItemCreationInformation itemInfo = new ListItemCreationInformation();
ListItem listItemCreation = list.AddItem(itemInfo);

//this is needed for taxonomy / metadata field
 var taxonomySession = TaxonomySession.GetTaxonomySession(clientContext);
 var termStore = taxonomySession.GetDefaultSiteCollectionTermStore();
//Instantiate excel app and if not installed give a message
Application excelApp = new Application();
            if (excelApp == null)
            {
                Console.WriteLine("Excel is not installed!!");
                return;
            }

//load the workbook from where data needs to be read           
 Workbook excelBook = excelApp.Workbooks.Open(@"path of excel file including file name");
            _Worksheet excelSheet = excelBook.Sheets[1];
            Range excelRange = excelSheet.UsedRange;

            //get the number of rows and columns
            int rows = excelRange.Rows.Count;
            int cols = excelRange.Columns.Count;


//loop through them and print
            for (int i = 1; i <= rows; i++)
            { 

//we have to define field / column name for each column in which data will //be inserted, note that each name should be internal name of SharePoint //column

string fieldNameNumber = "FieldNumber";
string fieldNameMultiLineText = "FieldMultilineText";
string fieldNameTaxonomy = "FieldTaxonmy";
string fieldNameNumber = "FieldNumber";
string fieldNameChoice = "FieldChoice"



               for (int j = 1; j <= cols; j++)
               {

                //write the console
                if (excelRange.Cells[i, j] != null && excelRange.Cells[i, j].Value2 != null)
                {
                    Console.Write(excelRange.Cells[i, j].Value2.ToString() + "\t");

//I am skipping first row as it contains column name
if (j == 1 && i!=1)
                    {

//setting number column                  
      listItemCreation [fieldNameNumber ] = excelRange.Cells[i, j].Value2.ToString();

                    }

if (j == 2 && i!=1)
                    {

//setting multi line text column                  
      listItemCreation [fieldNameMultiLineText] = excelRange.Cells[i, j].Value2.ToString();

                    }

if (j == 3 && i!=1)
                    {

//setting fieldNameTaxonomy  column                  
      string fieldTaxonomyValue = excelRange.Cells[i, j].Value2.ToString();
//create variable to store GUID value of metadata      
Guid CustomertermIdGuid = Guid.Empty;
//Important to set correct term set name here
var allTerms = termStore.GetTermSetsByName("<<name of term set>>", 1033);
var termSet = allTerms.GetByName("<<name of term set>>");
                        
var terms = termSet.GetAllTerms();
                        clientContext.Load(terms, includes => includes.Include(k => k.Id, k => k.Name, k => k.Parent, k => k.Parent.Id, k => k.Parent.Name, k => k.IsRoot, k => k.LocalCustomProperties));
                        clientContext.ExecuteQuery();
                        foreach (var term in terms)
                        {
                            if (term.Name == Customer)
                            {
                                CustomertermIdGuid = term.Id;
                            }


                        }


                        fieldTaxonomyValue = Customer + '|' + CustomertermIdGuid.ToString();
                        

                    }

if (j == 4 && i!=1)
                    {

//setting number column                  
      listItemCreation [fieldNameNumber] = excelRange.Cells[i, j].Value2.ToString();

                    }

if (j == 5 && i!=1)
                    {

//setting chpice column                  
      listItemCreation [fieldNameChoice] = excelRange.Cells[i, j].Value2.ToString();

//since this is the last column we should insert value in SharePoint as well

            listItemCreation.Update();
            clientContext.Load(listItemCreation);
            clientContext.ExecuteQuery();

                    }

               }
}









        } 
   } 

}

Important point to note is how I have set the Managed Metadata column, first we we need to get all terms from term set and then find correct GUID else it will not work.

Code is not structured very well but you can refer main parts to write your own code.

Subscribe to my YouTube Channel https://www.youtube.com/channel/UC6vLzWN-3aFG8dgTgEOlx5g

Connect with me on Twitter or Linked In and follow YouTube Channel or my blog https://twitter.com/SinhaKislay

https://www.linkedin.com/in/kislaysinha

/https://synkventures.com

/https://www.youtube.com/channel/UC6vL…

Last week in Microsoft 365 – 29 Oct – 04 Nov 2020 – VLog 4

Subscribe to my YouTube Channel https://www.youtube.com/channel/UC6vLzWN-3aFG8dgTgEOlx5g?sub_confirmation=1

In this VLog I have covered following topics

  • Matt-Collins 366 days video streak
  • 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

Links: https://www.linkedin.com/posts/mattco…

https://www.youtube.com/c/MattCollins…

https://twitter.com/D365Geek

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

Link: https://techcommunity.microsoft.com/t…

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.

Links: https://twitter.com/mgwojciech/status…

https://github.com/mgwojciech/unit-te…

https://mgwdevcom.wordpress.com/2020/…

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

Links: https://developer.microsoft.com/en-us…

5. The last one today is an article “What’s new in Microsoft Teams?”, this is a collection of bunch of things announced in Microsoft Teams so let’s have a look into some of these.

Links: https://techcommunity.microsoft.com/t…

Episode 1 Link: https://www.youtube.com/watch?v=4Mteq…

Episode 2 Link: https://www.youtube.com/watch?v=811h7jrqYlg&t=127s&ab_channel=SYNKVentures-Let%27stalkMicrosoft365

Episode 3 Link: https://www.youtube.com/watch?v=SQXjobuVCqY&t

Connect with me on Twitter or Linked In and follow YouTube Channel or my blog 

https://twitter.com/SinhaKislay

https://www.linkedin.com/in/kislaysinha

/https://synkventures.com

/https://www.youtube.com/channel/UC6vL…

Last week in Microsoft 365 – 15 Oct – 21 Oct 2020 – VLog 2

In this VLog I have covered following topics

  • 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

c. Combine multiple web parts in single tab: This is same as before but you need to use React to combine multiple React components Link: https://blog.mastykarz.nl/build-me-ex…

https://docs.microsoft.com/en-us/shar…

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…

https://twitter.com/PaoloPia/status/1…

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…

https://developer.microsoft.com/en-us…

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…

https://www.microsoft.com/en-us/micro…

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…

https://docs.microsoft.com/en-us/powe…

Episode 1 Link: https://www.youtube.com/watch?v=4Mteq…

Connect with me on Twitter or Linked In and follow YouTube Channel or my blog https://twitter.com/SinhaKislay

https://www.linkedin.com/in/kislaysinha

/https://synkventures.com

/https://www.youtube.com/channel/UC6vL…

Let’s Learn a Microsoft 365 Topic – Vlog 1 – Microsoft Lists – show or hide columns based on conditional formatting

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

Transcript

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.

If you want to learn how to create a list please go through my another blog, refer here: https://synkventures.com/2020/07/29/m…

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
  • Currency columns
  • Location columns
  • Calculated columns
  • 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.

Connect with me on Twitter or Linked In and follow YouTube Channel or my blog https://twitter.com/SinhaKislay

https://www.linkedin.com/in/kislaysinha/

https://synkventures.com/

https://www.youtube.com/channel/UC6vL…

References:

https://docs.microsoft.com/en-us/sharepoint/dev/declarative-customization/list-form-conditional-show-hide

Last week in Microsoft 365 – 07 Oct – 14 Oct 2020 – VLog 1

Topics covered in this Vlog

1.Vesa and Waldek’s 100th Episode of PnP Weekly

2.Scottish summit – call for speakers

3.One Admin Center for SharePoint and OneDrive

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

https://scottishsummit.com/

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.

Video URL: https://youtu.be/-dVZM-UROb0?t=2666