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

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 Single Page Application using Microsoft Graph and JavaScript – Let’s Learn a M365 – vlog 6

In this video I explain how to create a Single Page Application using Microsoft Graph and JavaScript.

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

Source code used in the Tutorial can be downloaded from here: https://github.com/sinhakislay/SPA-MS…

This solution is based on a solution created by Cameron Dwyer https://github.com/CameronDwyer/M365D…

I have extended this to learn more and added another page to get Outlook messages.

In this video I have explained all the files and code in detail.

References: https://camerondwyer.com/2020/10/27/g…

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

Node.js: https://nodejs.org/en/

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 – 12 Nov – 18 Nov 2020 – VLog 6

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 the 6th episode of Last week in Microsoft 365 I discuss five topics

1. Dynamically Populate Owner Value (User or Team) in Power Automate – Lin Zaw Win: In this Lin explains how to update owner value on basis of another row owner value, great description how to do it. Links: https://twitter.com/LinnZawWin https://linnzawwin.blogspot.com/2020/…

2. Calling the Microsoft Graph with PnP PowerShell – Paul Bullock: A very simple and neat explanation of how to call Microsoft Graph from PnP PowerShell and great scenario where you want to find out if Group is Team Connected or Yammer connected Links: https://twitter.com/pkbullock/status/… https://capacreative.co.uk/2020/11/11…

3. Outlook REST API v2-0 deprecation notice: Time has come to replace Outlook REST API with Graph API, it will be deprecated on 30th Nov 2022 Link: https://developer.microsoft.com/en-us…

4. Learn to build Apps for Teams – Learn TV: A great opportunity to learn from best people to create Apps for Teams, please register fast Links: https://twitter.com/LearnTV/status/13… https://learntogether.splashthat.com/

5. Microsoft Forms Brings Polls to Teams Meetings – Melinda Hu: Foems is now available as App or Tab and also in Meetings which is a great addition https://techcommunity.microsoft.com/t…

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 – 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 – 26 Nov – 02 Dec 2020 – VLog 8

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 about 5 topics

1. Launch of Festive Tech Calendar Follow Cloud Family and festivetechcalendar.com for new videos all December. there will be one video from my side as well https://twitter.com/_CloudFamily/stat… https://festivetechcalendar.com

2. Create single sign-on authentication for tab apps with Microsoft Teams Toolkit for Visual Studio Code https://developer.microsoft.com/en-us… Teams Toolkit First look: https://www.youtube.com/watch?v=Yfi0D…

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…

5. Use the Page Diagnostics for SharePoint tool https://docs.microsoft.com/en-us/micr…

#Festivetechcalendar #SSO #MicrosoftTeams #Teams #Power App #Microsoft Form #Diagnostic Tool #Dashboard

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…

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 YouTube 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…