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"

Disable Quick edit for SharePoint List

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

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.