Make a SharePoint Online Modern Private Site into Public Site

Introduction

I had to make a modern private site into a public site so that all the users in the organization can use it without making any access request. 

Solution

Steps: 
Site Information -> Privacy Setting -> Make public

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/

Updated On 15th June

Slide Deck

Build Microsoft Teams Apps with Teams App Studio from Suhail Jamaldeen

The internal view of new Microsoft Sri Lanka Office

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

Visual Studio 2017 Hangs on Startup

Introduction
My Microsoft Visual Studio Community 2017 was hanging on startup. 

Solution

I reset the user data and it worked fine. 

Step 01.
Open "Developer Command Prompt for VS 2017"

Step 02.
Navigate to the following location 
C:\Program Files (x86)\Microsoft Visual Studio 14.0\Common7\IDE
By typing 
cd "C:\Program Files (x86)\Microsoft Visual Studio 14.0\Common7\IDE"

Step 03.

Run the below command

devenv.exe /ResetUserData

Send E-Mails from MS Flows as HTML

Introduction

If you want to have styles in the mail which we send from Microsoft Flow.

Here are the simple option you have to enable.

Solution

Step 01.

Click on Show Advanced Option

Step 02.

Set “Is HTML Option” to Yes

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

MS Flow doesn't allow adding @ sign in the body of HTTP Action

Introduction

I was trying to call a rest api call through HTTP action in Microsoft Flow. I had to use "@odata.id" as a parameter.

Problem Background

After adding "@odata.id" I tried to save the Flow, when I tried to save I got the below error message.
“The template validation failed: 'The template action 'HTTP_-_Add_User' at line '1' and column '5342' is not valid: "Unable to parse template language expression 'odata.id': expected token 'LeftParenthesis' and actual 'Dot'.".'.”

Solution

You will have to add two @ signs as give below.
"@@odata.id"