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
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
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
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
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.
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.
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
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…
Finally on 28th July 2020 Microsoft Lists have arrived in our tenants (10% targeted release), here is the icon and just click on it to access the Lists page.
What are the ways to create lists?
You can create a blank list as we use to do like custom list in SharePoint.
You can start with an existing excel which means that if you have excel you can use that create a list with same set of columns etc
You can pick any one of the templates to create a list.
You can also use an existing list of create a list which means you don’t have to start from scratch and any existing list can be used as template.
We will have a look at all these one by one but first let’s discuss templates.
What are the templates available and their usages?
Issue Tracker: This to track issues, similar template is available in SharePoint as well, look at the video below how to create and what are the columns etc. You will notice that the interface is same as SharePoint Lists and also settings page is same so the learning curve is pretty small.
2. Employee OnBoarding Template: Look at the video to understand what columns it has, this can be used for onboarding new employees or onboarding emoloyee transfers from one location to another or department
3. Event Itinerary template demo: A lists to track series of events such as who is the speaker, location, number of people allowed etc, look at the video for more details
4. Asset Manager Template: This template can be used to manage assets if new assets needs to be assigned, transferred or an inventory of existing assets. All required columns like Serial number, manufacturer etc are already available, look at the video for more details
5. Recruitment Tracker: This template can be used to track recruitment candidates, has all options to store candidate information, who is the requester, for what role etc., look at the video to understand more.
6. Travel Request Tracker: This can be used to track travel requests, it has all the columns you need, workflow of course can be created using Power Automate, good use of the “Location” column as users can enter location where they are travelling so you don’t need to maintain a list, flight cost, hotel cost etc, look at the video for details
7. Work Progress Tracker: This template can be handy if you are managing a team or you are tracking different tasks, this template has all the columns you need such categorization, priority, start date , end date etc, look at the video for more details
8. Content Scheduler: This template can be used to track launch of content in your organization, it has all the columns you need such as Content type, author, publish date, content link etc, view the video to get more details
Create a blank list: Use the same steps as before just use the option, blank list, it is more like a custom list we have in SharePoint and we can create columns as we wish. View the video for more details.
As you can see the experience is very similar as before and we have both modern way of creating ways also classic experience available with us, if you want to use metadata type it is also available.
Create a List using an existing list: Use the same options as before just use the option existing list and you will be able to create a list out of an existing list. Benefit of this is that whatever customization with respect to columns, formatting and views you have done will be copied over. View the video for more details.
Create a List using an excel: If you have data in existing excel and you would like to turn it into Microsoft Lists then it can be easily done, view the video below.
Some points before you do this:
There is a limit of number of rows for which data can be uploaded
Your excel sheet needs to have data in “Table” format else it will not work and will give a message for the same.
You can select multiple type of column type while uploading such as Single text, Multi text, Choice , Date time, Number , Currency depending on what data resides in the column or you can select not to upload data
When you upload the excel it will be first uploaded to OneDrive and then list will be created, later it can be found in OneDrive.
You have the ability to upload an excel from OneDrive as well.
I also encountered an issue while uploading, I was not abe to save List under “My Lists” as it gave me this error “The Site does now allow Site Designs” so I had to share it in one of the SharePoint sites and then it worked.
Your data along with columns will also be uploaded.
What happens when you create a list and how to create under SharePoint Site ?
If you will notice the List URL you will understand that the List App is actually running from your SharePoint My Site as we have our “OneDrive” running, a sample URL below so I believe all Lists are being created under your My Site. Check below URLs and you will understand. Anyhow our my sites are nothing but a SharePoint site so it makes sense to utilize them.
You have the ability to save list under a SharePoint site when you create a list, instead of My Lists select SharePoint Site this will create the List under SharePoint site, a link will be added in menu automatically and also you can find under the Site Contents.
Create a List from existing SharePoint List: Yes this is true you can create Microsoft Lists using existing SharePoint List, check the below video for details. Basically you will have to use “From existing list” option and you can select SharePoint sites and it will show compatible Lists whuch can be used.
How to create a Rule in Microsoft Lists: Rule is a great idea introduced by Microsoft which works similar to List formatting but has much more, check the video below in which I highlight a column and also add an exclaimation icon based on specific condition and that too only via few clicks.
How to access Microsoft Lists via PowerShell?
You can access Microsoft Lists just like any other list and I hope all kind of commands work, check below the screenshot to believe it
Sharing options in Microsoft Lists: When you create Microsoft Lists under My Lists it is accessible only by you so if you want to share with others you need to share with other persons. When you create under a SharePoint site then it will be accessible by SharePoint site users as well.
You can also share individual items as well.
Integration options: This is a big topic so I just want to say few lines as it has all the abilities for extending the functionality using Microsoft Graph, Power Automate, PowerApps
How to access normal SharePoint List in Microsoft Lists way:
If you want to see the new Microsoft Lists experience in any modern SharePoint list, go to the URL and append this query string after AllItems.aspx like this. AllItems.aspx?env=WebViewList
Credit goes to this tweet:
If you want to see the new Microsoft Lists experience in any modern @SharePoint list, go to the URL and append this query string after AllItems.aspx
Summary: This is a great decision from Microsoft to introduce Lists as a standalone App, it will provide a great value. It has huge capabilities which I have not been able to cover all things but I will do this in subsequent blogs.
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.