I will be speaking at Sri Lankan Tech Summit – 2018 along with local and international MVPs and MCTs.
Title: Microsoft Office 365 Administration and Development
Venue: Batticaloa Public Library Auditorium
Date: 29 July 2018
Time: 09.00 am to 4.30 pm
Event Url: http://techeventsrilanka.com/tech-talk/
Title: Build Microsoft Teams Apps with Teams App Studio
Description: Microsoft Teams is the hub for teamwork in Office 365 that integrates with the apps and services. Microsoft Teams App Studio makes it easy to create and integrate custom apps and services. Teams App Studio is now the recommended way to develop Teams apps.In this session we will discuss on how to create apps using Teams App Studio.
Venue: Microsoft Sri Lanka, Access Towers II, Colombo
Date: 13th of June 2018
Time: 06 PM – 08 PM
Event Url: https://www.facebook.com/events/135965220607086/
Updated On 15th June
Slide Deck
Introduction
I was creating a Single Page Application using Angular 5, PnPJS Libraries and sp-rest-proxy.
I have created a boilerplate project in GitHub. Please clone and run the project after installing npm packages (npm install).
To run the project open two command prompts and type
npm run hmr
npm run serve.
You will be asked your SharePoint Online site url and the credentials in the command prompt. Feel free to provide them.
Once you done with these steps browse with http://localhost:4200/ and you will see your basic detail as below.
Since then you can develop your complex single page application.
GitHub Url
https://github.com/SuhailCloud/Angular5-PnPJS-SPRestProxy
Resources and References
I will be speaking at Kalmunai IT Hub Monthly Meetup and Expert Talks – April, 2018
Venue: IDM Nations Campus, Kalmunai Branch
Date: 28th of April 2018
Time: 10 AM – 12 PM
Title: Store Data in Azure SQL Database
Microsoft Azure platform provides a database as a service offering that allows developers to use SQL in the same way as they would in an on-premises location.
In this session we will discuss on Azure SQL Database and management tools. Also we will be developing a web application using Azure SQL Database.
Event Url: https://www.facebook.com/events/812530305608147/
Slides for the event
Introduction
In SharePoint List we have “Quick Edit” to edit list items from AllItems.aspx page.
Sometimes we need to remove “Quick Edit” from list and this blog post will show how to achieve it.
Solution
1. Go to List Setting
2. Go to Advanced Settings
3. There set the “Allow items in this list to be edited using Quick Edit and the Details Pane?” to False as shown below.
4. Click OK
Conclusion
Introduction
In this blog post we will be looking how to create Lists and Fields using PnP PowerShell. You can download and install PnP PowerShell here.
Solution
First you have to connect to SharePoint Online using PnP PowerShell.
Connect-PnPOnline –Url “site collection name” –Credentials (Get-Credential)Creating List
Generic List
$ListName = "Cohort"
$ListUrl = "Lists/Cohort"
New-PnPList -Title "ListName" -Url "ListUrl" -Template GenericList
Fields
Number
$NumberFieldString ='' Add-PnPFieldFromXml -List ListName -FieldXml $NumberFieldString
Text
$TextFieldString ='' Add-PnPFieldFromXml -List ListName -FieldXml $TextFieldString
Date
$DateFieldString = '' Add-PnPFieldFromXml -List $ListName -FieldXml $EndDateFieldString
Multi Lines
$MultiLines ='Yes/No' Add-PnPFieldFromXml -List $InstructorCohortListName -FieldXml $MultiLines
$Boolean ='Lookup' Add-PnPFieldFromXml -List $InstructorCohortListName -FieldXml $Boolean
#Please not that you have to give the Look up list guid for List Field $Lookup ='' Add-PnPFieldFromXml -List $CohortListName -FieldXml $Lookup
Title: Office 365 CLI: Managing Office 365 tenant and SharePoint Online
Description: Office 365 CLI is an open-source project driven by the SharePoint Patterns and Practices initiative. Using the Office 365 CLI, developers can manage the different settings of SharePoint and Office 365 no matter if they use Windows, macOS or Linux. In this session we are going to look at some cool features of Office 365 CLI.
Event Url: https://www.facebook.com/events/1880475591994592/
Slides which used for the event.
