Date and time Expression in MS Flow

Expression	Output
@utcnow()	2019-03-10T12:07:30.6298153Z
utcnow('MM')	03
utcnow('yyyy')	2019
utcnow('dddd')	Tuesday
utcnow('mmmm')	March

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

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"

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.

Kalmunai IT Hub Monthly Meetup and Expert Talks – November, 2017

I did the session for Kalmunai IT Hub monthly meetup and Expert Talks for the month of November
Title: Automate your business processes with Microsoft Flow and SharePoint Online
Date: 26^th of November 2017
Time: 10 am to 12 pm
Venue: IDM Nations Campus, Addalaichenai
Event Url: https://www.facebook.com/events/837998646382348/

Slides

Automate your business processes with Microsoft Flow and SharePoint Online from Suhail Jamaldeen

Some clicks during the event

More Photos On: https://www.facebook.com/pg/Suhail.Cloud/photos/?tab=album&album_id=579101805783021

IDM Knowledge Share – Team Collaboration in Office 365

I will be conducting a workshop on “Team Collaboration in Office 365”, as a part of IDM Knowledge Share.

Date: 29^th of October 2017

Time: 10 am to 12 noon

Venue: IDM Nations Campus, Kotahena

Event Post Url: https://www.facebook.com/idmnc/posts/1586187304737107

Updated On: 29^th of October 2017
Slide deck used for the event

Team Collaboration in Microsoft Office 365 from Suhail Jamaldeen

Some clicks during the event

Save my email attachments to a SharePoint document library using Microsoft Flow

Introduction

I was trying Microsoft Flow and I thought of sharing how I did my first Flow App using the template provided by Microsoft.

The template I’m using is “Save email attachments to a SharePoint document library”.

Steps

Step 01

Go to https://flow.microsoft.com/en-us/ and find the “Save email attachments to a SharePoint document library” using the search box or by navigating through all template.

Step 02

Click on the app and you will get a screen as below. Then you have to select “Use this template” option.

Step 03

Click Sign In and then use your Office 365 username and password.

Step 04

The template will be created for you as below.

 

Step 05

Select Inbox for the folder option. You can select the Inbox by clicking on folder icon.

 

Step 06

Site URL: Provide the SharePoint site URL

Folder Path: Give the name of the document library where you would like to store the attachments.

File name: You can give any dynamic value or static value. Please note that you can’t store two documents in the same name. So please make sure the name is dynamic.

File Content: Select “Content”

Step 07

Click on “Create Flow” from the top.

Conclusion

Send a mail with attachment and check your SharePoint Document library. There you can find the attachments.