Thursday, June 7, 2018

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:

Sri Lanka Business Application Community - June 2018 Meetup - Suhail Jamaldeen - Suhail Cloud

Updated On 15th June

Slide Deck

The internal view of new Microsoft Sri Lanka Office

Suhail Jamaldeen - Suhail Cloud  - Sri Lanka Business Application Community

Saturday, June 2, 2018

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


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

Resources and References

Saturday, April 21, 2018

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:

Kalmunai IT Hub April 201 Suhail Jamaldeen Suhail Cloud

Slides for the event

Wednesday, March 7, 2018

Disable Quick edit for SharePoint List


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.


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



Wednesday, February 21, 2018

Create SharePoint Online Lists and Fields using PnP PowerShell


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.


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 




$NumberFieldString =''
Add-PnPFieldFromXml -List ListName -FieldXml $NumberFieldString 



$TextFieldString =''
Add-PnPFieldFromXml -List ListName -FieldXml $TextFieldString 



$DateFieldString = ''
Add-PnPFieldFromXml -List $ListName -FieldXml $EndDateFieldString 

Multi Lines


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



$Boolean =''
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 

Wednesday, February 14, 2018

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:

Office 365 CLI - Managing Office 365 tenant and SharePoint Online - Suhail Jamaldeen - Suhail Cloud - SharePoint Forum Sri Lanka

Slides which used for the event.

Clicks during the event

Office 365 CLI Managing Office 365 tenant and SharePoint Online - Suhail Jamaldeeen - Suhail Cloud (6)Office 365 CLI Managing Office 365 tenant and SharePoint Online - Suhail Jamaldeeen - Suhail Cloud (2)

Monday, February 5, 2018

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.

Sunday, January 21, 2018

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


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.


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.

Suhail Cloud - January 2018

Tuesday, January 9, 2018

Invoke a code activity (Native Activity) and retrieve the results using code – Workflow Foundation 4.5


We can create code activity as a part of workflow solutions using workflow foundation 4.5. In this post I will show how we can create a native code activity and access the results in controller. Native code activity


   //The string mentioned in NativeActivity is the resut type.  

     public sealed class MySampleNativeCode : NativeActivity     {

         // Define an activity input argument of type string

         public InArgument Name { get; set; }

         protected override void Execute(NativeActivityContext context)


             var name = context.GetValue(Name);

             //Here we set the string value to the Result property in NativeCode

             context.SetValue(base.Result, "Hello from Native Code Activity " + name);


Invoke the code activity The code activity is invoked in web api controller.
 // GET: api/CustomerRegistration

         public string Get()


             //Create a instance of the native code

             Activity wf = new MySampleNativeCode();

             //Define the input argumentes

             Dictionary arguments = new Dictionary();

             arguments.Add("Name", "Suhail");

             //Invoke the workflow

             IDictionary outputs = WorkflowInvoker.Invoke(wf, arguments);

             //Get the output value and assign to return string

             var returnString = outputs["Result"].ToString();

             return returnString;



You can see the value in “returnString” which is returned from Native Code Activity.

Saturday, January 6, 2018

Cannot add .Net Standard 2.0 Class as .Net Type in Workflow Foundation Activity Designer projects in Visual Studio 2017


I was working on Workflow Foundation 4.5 using Activity Designer Library template in Visual Studio 2017.

Problem Background

When I try to add a class library as input Type through Type Browser in Activity designer it shows an error as “The selected type could not be created” as shown in the image below.


I compared another machine with the latest update of Visual Studio which was working fine. The problem seems to be I didn’t have .Net framework 4.6.2 SDK and .Net framework 4.7 SDK installed.



I modified the Visual Studio as below using Visual Studio Installer.



You will can refer .Net Standard 2.0 projects and dlls in workflow foundation project templates and use without any issue.