Blog

Microsoft 365 Lists – a powerful App, SharePoint lists not needed any more

Microsoft Build 2020 came up with lot of exciting announcements but the most interesting one was Lists as individual app in Microsoft 365.

Lists has been around for many years as part of SharePoint platform , I remember explaining my end users Lists is something like an excel rows or table in database in SharePoint 2010 days and to be frank not a lot has been changed, we have not seen huge improvements except some more templates being introduced. We got conditional formatting recently in SharePoint online, of course you can do more these days due to introduction of Power Platform (Power Apps and Automate).

This is reason I term this annoucement as interesting one as it takes the Lists to another level and put it on same level as other standalone apps.

So let’s look what all we get in Microsoft 365 Lists

  • It can be accessed as a standalone app from waffle of Micorosft 365
  • Various default predefined templates such as issue tracker, asset tracking, blank , contacts, inventory, events, onboarding etc are available
  • Lists has its own home page
  • Available as mobile app
  • Can be added to Microsoft Teams as an App or tab
  • Can have conversation around Lists in Microsoft Teams or can have conversation around each item in a Microsoft Lists
  • Lists will have views calendar, grid, custom, cards etc
  • Conditional formatting is available in Lists
  • Rules: You can set rules to show hide columns based on differen rules, it’s like light weight customizing forms, for definition read below statement
    • Building rules is as easy as writing a sentence. Once you decide on the outcome, click-fill if/then steps to design your rules. Choose people, status, and value changes to send notifications or programmatically update values elsewhere in the list. Finally, use rules to set reminders to keep everyone informed.
  • Lists can be shared with users so you can manage permissions and you can be owner of lists
  • You can boomark Lists using the favorites feature
  • Can create a new list from existing excel data
  • Able to preview a list before it is created
  • You can chose an icon and a color for you lists to make distinctions between different lists
  • Lists can be saved as draft till you are ready to share with others
  • You can comment on individual list items and also mention someone
  • You can design your own card views
  • Data availability and accessibility via Graph API

As you can read it has lots of features and covers a lot of scenarios which were not possible before in SharePoint lists so let’s have a look into them

  • Rule based email sending capabilities, earlier we used to write workflow or event receivers or Flows
  • Grid or card views , earlier we used to customize using JSLink, Jquery, JS etc
  • Earlier a whole site has to be created even though only a list was needed
  • In past following requests had come to be from business users which are avaialble by default now
    • Save as draft before it is ready to be released
    • Different icons to visualize it better
    • Simple form customziations can be done by Rules earlier we had to inject JS in edit, new or view forms

We can clearly infer that Microsoft 365 Lists are smart, powerful and easily replace SharePoint lists so we don’t need them anymore. With ability to add this in Teams we can see it is more flexible and very well integrated in Microsoft 365.

We can also infer that a need of Teams sites in SharePoint is even less now and if you are using Microsoft Teams along with Lists probably you don’t need SharePoint team sites.

As as ending note I am really forward to this new app which will be extremely useful and I would like to move most of SharePoint list to new Microsoft 365 Lists.

Connect with me on Twitter or Linked In if you need more information.

References

https://techcommunity.microsoft.com/t5/microsoft-365-blog/announcing-microsoft-lists-your-smart-information-tracking-app/ba-p/1372233 https://resources.techcommunity.microsoft.com/microsoft-lists/

Private Channel in Microsoft Teams #teams #channel

I attended SharePoint Saturday Event in Stockholm, you can read more here http://www.spsevents.org/ and http://www.spssthlm.org/

One of the things in which a lot of people were interested and I also get to know was about Private Channels in Microsoft Teams. Currently we are able to create Channels but they are not private and can be accessed by all Team members.

Apparently this is the most sough after feature in Teams in User Voice. Latest information I got from two guys from Microsoft in a session about Teams was Private Channel will be available in end-October and might be available in Nov to Tenants

Interestingly the Private Channel will have it’s own SharePoint site collection and not as a folder in existing SharePoint site as it happens now. It will only have four Apps available to be used in beginning for rest of Apps you have to go to main Team.

As explained to me is that idea is to get the Private Channel usage going and then later more Apps will be made available.

Some people were concerned with new Site Collection being created for each Private Channel but this seems to be logical as we do not want permission broken folder in our library as it will be a nightmare for future and having a site collection of it’s own makes it scalable.

Keep an eye here when it is available and also on User Voice page https://support.office.com/en-us/article/create-a-private-channel-in-teams-60ef929a-4d68-418b-bf4f-5784db184ec9

Ask me on Twitter or Linked In if you need more information

Power Apps Simple Functionalities – Let’s Learn a Microsoft 365 Topic Vlog 7

If you like my video or the blog please subscribe to my YouTune channel to get me going https://www.youtube.com/channel/UC6vLzWN-3aFG8dgTgEOlx5g

In this video we learn some simple Power Apps functionalities:

1. Get current user Manager : Scenario can be that you to display or send an email to current user manager, in this video I have added a Label in Canvas App and used following formula. To make this work your Canvas App should have Office365users as data source which you can learn in Video how to add. The Manager function takes either email or principal id, in this we have passed email by yet another function “User().Email”

Office365Users.Manager(User().Email).Mail

2. Get current date week number : In lot of countries Week number is important, so there might be a requirement to display current date week number or selected date week number, to achieve this I had added another label in Canvas App and used following function

RoundDown(
     (RoundUp (
          Now() - Date(
               Year(Now() - Weekday(Now() - 1) + 4),
               1,
               3
          ),
          0
     ) + Weekday(
          Date(
               Year(Now() - Weekday(Now() - 1) + 4),
               1,
               3
          )
     ) + 5) / 7,
     0
)

3. Set Drop Down choices in Power Apps with SharePoint List Choice column: When we add a drop down in Power App Canvas App we can hard code drop down choices but what if we want to have same choices we already have on SharePoint list column, to achieve this we can use “Choices” function but before that we should add SharePoint List as data source for the Canvas App which you can check in the video, once that is done, add a Drop Down and use below function. Here “PowerAppDataStore” is the list name and “City” is column name whose choice values will be displayed

Choices(PowerAppDataStore.City)

4. Patch function – Drop down values in SharePoint : Since we added a drop down in above example we want to save data back to SharePoint on click of a button so how to do that, you can of course write a Power Automate but instead of that we can use “Patch” function which can save data back in SharePoint, in this example I have already a List “PowerAppDataStore” which has two columns “Title” and “City” which was already mapped to the drop down, so to use a button we can add it to Canvas App and then “OnSelect” property write below function, you can find more details in the video below

Here Patch takes 3 parameters, first is the source, second is record which is an item with defaults and 3rd values for each column which will be updated.

Patch(PowerAppDataStore,Defaults(PowerAppDataStore),{Title: "click here", City:Dropdown1.Selected})

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…

How to use Microsoft Graph Toolkit with React – Let’s Learn a Microsoft 365 Topic – Vlog 5

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

In this video I create a simple App using React framework and Microsoft Graph Tookit, video covers following

  • What is Microsoft Graph Tookit?
  • A collection of resusable components which can be used out of box which fetches data and authenticates using Microsoft Graph
  • It can cut down development time as out of box web components can be used easily with least effort
  • It works in all browsers hence once you build it, it can run anywhere
  • Prerequisites :
  • Microsoft 365 Developer account
  • Visual Studio code or any other IDE
  • Node.js installed
  • Git installation
  • Azure Directory App to be used with Microsoft Graph Toolkit
  • Create a simple React App to load Calendar information and use Sign in component details are explained in the video

Here are some reference links

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

https://code.visualstudio.com/ https://nodejs.org/en/ https://git-scm.com/downloads

Source code reference: https://docs.microsoft.com/en-gb/grap…

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 – 05 Nov – 11 Nov 2020 – VLog 5

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

In this VLog I have covered following topics

  • Use Microsoft Graph Toolkit with React
  • Patch SharePoint Choices columns in Power Apps  – Matthew Devaney
  • Me Experience in Microsoft Teams using Graph ToolKit and SPFx – Rabia Williams
  • Announcing general availability of Microsoft Teams Resource-specific consent and read channel messages – Microsoft 365 Dev team
  • How to record 1:1 Teams and PSTN calls with OBS Studio for free – Luca Vitali

Transcript of the video:

Hello and welcome all to series “Last week in Microsoft 365”, this is the fifth video in this series in and we have 5 topics to be highlighted this week which I liked.

1. Use Microsoft Graph Toolkit with React : The shared documentation explains how to create Apps using React and Microsoft Graph Tool kit. I have also done a YouTube video on this which you can refer here: https://www.youtube.com/watch?v=2qVL8mWux-4&t

Links: https://docs.microsoft.com/en-gb/grap…

2. Patch SharePoint Choices columns in Power Apps – Matthew Devaney : In this Matthew explains how to use Patch functionality, recently Reza Dorrani also did a video on this topic in which he also referred to Matthew’s blog, refer the video here https://www.youtube.com/watch?v=VzrarcM9W5k&feature=youtu.be

Links: https://twitter.com/mattbdevaney/stat… https://matthewdevaney.com/power-apps…

3. Me Experience in Microsoft Teams using Graph ToolKit and SPFx – Rabia Williams : In this Rabia explains how you can create Microsoft Teams Me experience which is quite unique explains all kind of possibilities we have using Microsofy Graph Toolkit

Links: https://rabiawilliams.com/teams/me-ex…

4. Announcing general availability of Microsoft Teams Resource-specific consent and read channel messages – Microsoft 365 Dev team

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

5. How to record 1:1 Teams and PSTN calls with OBS Studio for free – Luca Vitali

This is a great article bu Luca to explain how to use OBS Studio to record 1:1 Teams and PSTN calls.

Links: https://lucavitali.wordpress.com/2020…

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

Episode 4 Link: https://www.youtube.com/watch?v=4jnEvy9a-hk

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…

Add Choice column in SharePoint list or library using PnP PowerShell

If you have not used PnP PowerShell you should use it, it is much easier to do tasks in PnP PowerShell.

Example: If you want to add a Choice column in SharePoint list or library.

Just few lines of code will do this and you don’t need to be on SharePoint server to do this.

But you need to install SharePoint PnP PowerShell

https://docs.microsoft.com/en-us/powershell/sharepoint/sharepoint-pnp/sharepoint-pnp-cmdlets?view=sharepoint-ps#installation

$encpassword = convertto-securestring -String "<<password>>" -AsPlainText -Force
 $cred = new-object -typename System.Management.Automation.PSCredential -argumentlist "<<domain\username", $encpassword
 Connect-PnPOnline <<site url>> -Credentials $cred
 Add-PnPField -List "<<list name>>" -DisplayName "<<Display name of column" -InternalName "<<internal name of column, make sure no space in name" -Type Choice -Group "<<groupname>>" -AddToDefaultView -Choices <<choice values such as - " 8"," 9"," 10">>

Reference: https://docs.microsoft.com/en-us/powershell/module/sharepoint-pnp/add-pnpfield?view=sharepoint-ps

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…

Microsoft Teams Toolkit for Visual Studio- First look – Let’s learn a M365 Topic Vlog 3

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

In this vlog following topic is covered

Microsoft Teams Tool kit for Visual Studio- First look

  • Prerequisites
  • Installation
  • How to work with it?
  • How to approve in Microsoft Teams Admin?
  • How to update?

Transcript of the video

Hello and welcome to the series ‘Let’s Learn a Microsoft 365 topic’, today’s topic is “Microsoft Teams Toolkit for Visual Studio – First look”.

In this video I will explain what are the prerequisites for developing Apps for Teams, how the installation process looks like , how to work with it and how to approve submitted Apps in Teams Admin and finally How to update it? So let’s get started.

First thing is prerequisites:

1. Enable Developer Preview: You can do this in Teams Desktop client or Web client by clicking your profile picture and selecting About then Developer preview.

2. ASP.NET Web Development module has been added in Visual Studio, this you need to make sure hen you install Visual Stdio else you can add it from Visual Studio installed

3. Enable Custom Apps in Teams Admin in Org-Wide settings, login to Teams Admin and select “Teams Apps” from left menu, click on Manage apps and from right side click “Org-wide app settngs”, then allow Custom Apps. Installation: You can go to URL https://marketplace.visualstudio.com/… for download and install.

Installation is pretty simple you just download and install, make sure your Visual Studio is upto date, You cannot Visual Studio 2017 so you need atleast Visual Studio 2019, I am using an Enterprise version but I am very sure that it will work with Community Edition as well Next step is how to work with:

So after installation Open Visual Studio 2019 and select Teams App and you will see that Scaffolding is already built.

For starters best is to select Personal Tab and let the project be created, once done I will update “development.json” file to point to m blog site “https://synkventures.com” as I want to load this site in my personal tab. You might have noticed that we have the Teams ToolKit page which makes it really simple to upload an App to Teams catalog where Admins can approve or reject the submitted Apps. In this video you will also find the steps to approve or reject Apps submitted and also how to update an App.

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 – 22 Oct – 28 Oct 2022 – VLog 3

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

In this VLog I have covered following topics

  • Teams reached 115 million daily activer users (DAU) – Jeff Teper
  • Microsoft 365 Boot camp session about Microsoft Graph– Cameron Dwyer
  • General Availability of Microsoft Forms for personal use
  • Build advanced queries in Microsoft Graph with $count, $filter, $search, and $orderby – Beth Pan
  • Importing third-party platform messages to Microsoft Teams is now available in beta – Fabian Williams

Hello and welcome all to series “Last week in Microsoft 365”, this is the third video in this series in and we have 5 topics to be highlighted this week which I liked.

1. First one is a great news I saw on Twitter and Linked In from Jeff Teper that Microsoft Teams reached 115 million daily active users, it was at 75 million in April 2020. It is also clocking 30 billion collaboration minutes in a day. Surely COVID has helped this massive surge but Teams is one of the best things happened to us end users and also to Microsoft, it has taken the collaboration to next level. So Congrats to Microsoft for this feat and also to Jeff Teper and his team. I feel proud that I am one of the user and also have somehow helped in this growth journey.

Links: https://twitter.com/jeffteper/status/… https://www.microsoft.com/en-us/micro…

2. Second topic is from Cameron Dwyer about a Microsoft 365 Boot camp session about Microsoft Graph, this session is highly recommended if you want to understand power of Microsoft Graph, it covers the steps to create an App, how authentication works and how to set it up in great detail, as I said don’t miss this if you want to learn about Microsoft Graph.

Links: https://twitter.com/CameronDwyer/stat… https://camerondwyer.com/2020/10/27/g… https://www.youtube.com/watch?v=v8siJ…

3. So the third one is General Availability of Microsoft Forms for personal use, I think this is a great addition as I have always found Microsoft Forms easy to use and create quiz etc. This can be replace some of other tools which are available in market. So now you can invite friends family to use this as well

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

4. The fourth one is I saw an announcement from Beth Pan regarding “Build advanced queries in Microsoft Graph with $count, $filter, $search, and $orderby” , the blog post seems to be from September but I saw that just few days back, but it explains how easy is to query using count, filter etc. Links: https://twitter.com/beth_panx/status/… https://developer.microsoft.com/en-us…

5. The last one today is an another announcement I saw from Fabian Williams about “Importing third-party platform messages to Microsoft Teams is now available in beta” , this means that you can now import third party messages into Teams if you are migrating to Teams. Links: https://twitter.com/fabianwilliams/st… https://developer.microsoft.com/en-us… https://docs.microsoft.com/en-us/micr…

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

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…

Microsoft Teams Templates –What it is and how to work with it? Episode 2 – Let’s Learn a M365 topic

Learn how what is Microsoft Teams Templates , how to work with it?

Look at the video to understand:

Transcript of the video

Hello and welcome to the series ‘Let’s Learn a Microsoft 365 topic’, today’s topic is “Microsoft Teams Templates”. We will try to understand what it is , why it is important and how to work with it?

Before Teams was introduced we had/have “team site template” in SharePoint which was the place for collaboration and sharing files. Introduction of Teams has off course changed the way we collaborate for better.

The things we were missing till now was Templates because one Team cannot fit all and we definitely needed different sets of Templates.

Now as an end user you can select one template when you create a Team and as an Admin you can create multiple templates based on existing Team templates, create a new one from scratch or use an existing team to create a template.

So let’s have a look at all the options in the video.

Details of out to box templates available

  • Adopt Office 365: Help build, grow, and sustain your Champions community roll out by evangelizing and helping your peers with the new technology.
  • Manage a Project: Manage tasks, share documents, conduct project meetings and document risks and decisions with this template for general project management.
  • Manage an Event: Manage tasks, documents and collaborate on everything you need to deliver a compelling event. Invite guests users to have secure collaboration inside and outside of your company.
  • Onboard Employees: Improve your culture and streamline your employee onboarding with this central team for resources, questions and a bit of fun.
  • Organize Help Desk: Collaborate on documentation, policy and processes that support your helpdesk. Integrate your existing ticketing system or use our template to manage requests.
  • Collaborate on Patient Care: Streamline healthcare communication and collaboration within a ward, pod, or department. The template can be used to facilitate patient management, as well as the operational needs of a ward.
  • Collaborate on a Global Crisis or Event: Centralize collaboration for your crisis team across business units and help create business continuity plans, share remote working tips, track customer comms., and keep everyone in the loop with announcements, and news.
  • Collaborate within a Bank Branch: Centralize collaboration for your bank branch employees across Huddles, Customer Meetings, Business Processes such as Mortgage Collaboration, and keep everyone in the loop with Announcements and Kudos.
  • Coordinate Incident Response: Centralize communication and critical resources for your crisis management or incident response team. Within this team you can include many different types of files to help create a central place for all your documents. Use online meetings to improve information flow and situational awareness.
  • Hospital Streamline communication and collaboration between multiple wards, pods, and departments within a hospital. This template includes a set of base channels for hospital operations, and can be self extended to include specialties, ad-hoc.
  • Organize a Store: Bring your retail employees together in one central experience to manage tasks, share documents and resolve customer issues. Integrate additional applications to streamline shift start & end processes.
  • Quality and Safety Centralize communication, access to resources, and plant operations with a Manufacturing Plant team. Include policy and procedure documents, training videos, safety notices, shift handover processes.
  • Retail – Manager Collaboration: The Manager Collaboration template is ideal for creating a team for a set of managers to collaborate across stores/regions, etc. For example, if your organization has regions, you might create a Manager Collaboration team for the California Region and include all the store managers in that region, as well as the regional manager for that region.

There are three options to create a template:

1. Create a brand new template: Creates it from scratch

2. Use an existing Team as Template: If you have a team already existing you can use that create a template

3. Start with an existing template: You can start with an template which already exists by default or you have created before.

In the video you can see how to create a template and how to create a Team using the template

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

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…