Sri Lanka Business Application Community - June 2018 Meetup

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/

Create SharePoint Online Single Page Application with Angular 5, @PnPJS and SP-Rest-Proxy

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

• https://pnp.github.io/pnpjs/
• https://www.npmjs.com/package/sp-rest-proxy
• http://johnliu.net/blog/2017/9/angular-4-sharepoint-on-premises-localhost-development-and-sp-rest-proxy
• https://github.com/koltyakov/sp-rest-proxy/issues/41

Kalmunai IT Hub Monthly Meetup and Expert Talks – April, 2018

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

Store Data in Azure SQL Database from Suhail Jamaldeen

Create SharePoint Online Lists and Fields using PnP PowerShell

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 =''
Add-PnPFieldFromXml -List $InstructorCohortListName -FieldXml $MultiLines

Yes/No

  

$Boolean =''
Add-PnPFieldFromXml -List $InstructorCohortListName -FieldXml $Boolean 

Lookup

  
#Please not that you have to give the Look up list guid for List Field
$Lookup =''
Add-PnPFieldFromXml -List $CohortListName -FieldXml $Lookup 

Sri Lanka SharePoint Forum monthly gathering – February 2018

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.

Clicks during the event

Awarded Microsoft MVP for Office Servers and Services

All the praises belong to Almighty

Today I'm honored to be a new member of the Microsoft MVP community for Office Servers and Services.

I would like to thank our mentor Prabath Fonseka for guiding me throughout my professional career, Dinusha Kumarasiri for nominating me and guiding me.

In addition, I would like to thank Wellington Perera, Upul Weerasinghe, Sachira Chinthana Jayasanka and Fiqri Ismail for the support and encouragement which they have given me.

Also I would like to thank Hibathul Careem sir, my family, friends who are with me always.

Trigger a Microsoft flow only when a SharePoint list item is modified – An alternative approach

Introduction

One of my friend asked me whether there is a Microsoft flow action to trigger the flow only when a SharePoint Online list item is modified. Unfortunately there is no out of the box trigger available.

Solution

We can overcome this by adding a condition at the beginning of the flow - we have to check whether the created date time and modified date time are not equal. So the flow will execute only if the created time and modified time is not equal.

Please check the below screenshot for the reference.