Friday, December 15, 2017

Create a Simple Automation using Microsoft Flow

Create a Simple Automation using Microsoft Flow.

This is very simple scenario where you can use Microsoft Flow to create a simple automation.


Assume that you are having support email address on Gmail and you want to create a follow up task to the supporting team which is on the Microsoft Outlook environment.

To begin the automation we need to understand few key concepts.

  • Connections
  • Triggers
  • Actions


Connections are the middle man who connects Microsoft Flow with other systems. For this scenario we need two connections.

  • Gmail Connection
  • Outlook connection


In simple you can think as how to start the automation flow, in this scenario receiving email is the trigger to the workflow.


Actions are basically what we do after initiating the Flow. Here we need to create a Outlook task and it will be our action.

Launching Microsoft Flow

If you need to know about basic details please refer this link.
There are so many ways to start with existing template. To be familiar with the process and make it simple we will start as a Blank Template.

Start with Bank template

Add a trigger to read from Gmail

Click on Gmail and proceed with Trigger Gmail - When a new email arrives. If you don’t have any connections (if this is your first time), Flow will ask to sign in to your Gmail and it will automatically create a connection for you.

You need to grant the access to Flow to read from your Email.

After that you need to specify the Gmail Label, If you have a specific label specified you can choose it from the list or just go with the inbox.

Add an Action

Action is where you going to create a task to Outlook. Thus search for the Outlook Task and click on it to proceed.

It is a first time connecting to Outlook it will ask the credentials to proceed.

Once you are ready with credentials, you will see a screen with task creation. You can take the body from the Email and insert it as Task Body. To do that you need to find the relevant field form Dynamic content.

Click on Save to create the Flow.

Now you are done. You will see the task created it the Outlook once you received an Email to your Gmail.

Friday, December 8, 2017

Automate your Business flows with On-premises Data using Microsoft Flow

Automate your Business flows with On-premises Data using Microsoft Flow

Microsoft Flow is a Cloud service yet it allows you to connect your business data to automate the process.

When it comes to Could Data services you can use existing database connectors to fetch and manipulate data.

These are the available connectors for the moment, but it covers pretty market leaders

But when it comes to real business you might have your own database cluster connects with multiple applications and you also wants to connect to Microsoft Flow.

In this case you might need a Data Gateway to be installed.

Gateway is a middle man who’s talking care of data flow between cloud and your premises.

Microdot On-Premises gateway is a one option you may need to consider, but it comes with following concerns and practices.

Minimum Requirements:
·         .NET 4.6 Framework
·         64-bit version of Windows 7 / Windows Server 2008 R2 (or later)
·         8 Core CPU
·         8 GB Memory
·         64-bit version of Windows 2012 R2 (or later)
Keep in Mind:
·         The gateway cannot be installed on a domain controller
·         Should be always on

How to Install Data Gateway

Go to Microsoft Flow and Click on Gateways to download the Gateway.

Then you can see three options where you need to select the On-Premises Data Gateway.

Installation will be start in a while.

Once it is downloaded usually it is asking for a restart.

Monday, November 13, 2017

Empowering your business and personal processes with Microsoft Flow.

Introduction to Flow

This is a cloud base products which you can use individually or aligned with Office 365. In generally you can think this is as an alternative to windows workflow foundation with profoundly amount of features and concepts.

You can access the Microsoft Flow through Office O365.

If you are wish to subscribe Flow as a direct service you can just login in

Concept of automating


Automating workflow is all about

  • ·         Initiation
  • ·         Flow
  • ·         Out

If a system or a platform can be integrated with variety of inputs by other systems, it is a well indication of viability of the   platform.

Microsoft Flow contains significant number of initiation methods called triggers or connectors. Currently it is contains 184 + connectors and will be expanded more in the future.

Initiation / Out

Connectors are base mechanism for Initiation and out.

“More the connectors more the integration”

Major connectors such as
  • Database systems (SQL server, Oracle , MySQL , InfoMix …)
  • Email Systems (Outlook, Gmail, MailChimp ..)
  • ERP systems (Dynamics, CRM)
  • IOT Systems (


Flow is basically manipulation and tasks, it can be a simple approval to complicated integration few non interdependent systems.

Microsoft Flow contains easy integration of all three elements just click on few buttons and entering relevant credentials and authentication to connections.  I will explain how to build your flows in futures posts.

Microsoft Flow is Free, Basic and Premium

Tuesday, October 24, 2017

TypeError: Cannot read property 'replace' of undefinedTypeError: Cannot read in SharePoint 2013

TypeError: Cannot read property 'replace' of undefinedTypeError: Cannot read property 'replace' of undefinedTypeError: Cannot read property 'replace' of undefined
TypeError: Cannot read property 'replace' of undefinedTypeError: Cannot read property 'replace' of undefinedTypeError: Cannot read property 'replace' of undefinedTypeError: Cannot read property '_events' of null

This is a common error you might receive based on very common actions that you performed as an Administrator


This might occur when you did a
Patch Update
Copy your content database from another SharePoint environment
Installing Security Updates


Main reason behind the error is localize content in your list. This error occurs most of the time with lists that has multi local content


Check the Localization updates and versions installed in the source server
Download the related KB and installed in the destination environment.

Monday, October 16, 2017

There are no products affected by this package installed on this system when you try to update the SharePoint

There are no products affected by this package installed on this system when you try to update the SharePoint

This a quiet a common massage that you can experienced with while you are trying to install updates in SharePoint.

These updates can be

 -  Hot fixes
-  SharePoint Updates
-  KBs.

AS message indicates, its giving a feeling that it is been installed in the environment, But when you check in the Central Admin you might wonder it is not installed yet.

How to check the Updates are installed in the SharePoint Environment

-  Open Central Admin
-  Navigate to Upgrade and Migration

You can check those info from Central Admin -> Upgrade and Migration


Select the View Farm where you can examine all the patches in the SharePoint environment.

Here you can see whether particular patch is really installed or not. IF it is not installed and you are getting the message there is something else to check on. There could me various reasons for this.

But most of the times pending windows updates are the root.

How to check windows updates and install the updates

There are many ways that you can check updates, I’m describing a common way which can be applicable for most scenarios

-  Go to control panel

-  Then click on check for updates to confirm that is there any pending updates in the system

Check products and patch installation status.

For my issue is there are pending updates in windows updates in control panel.

You can install pending updates from here itself.

After installing the updates you can restart (this is optional) the machine to give a fresh try.

Monday, September 25, 2017

Add-SPSolution : This solution contains one or more assemblies targeted for the global assembly cache


Add-SPSolution : This solution contains one or more assemblies targeted for the global assembly cache. You should use a strong name for any assembly that will be in the global assembly cache. At line:1 char:1 + Add-SPSolution + ~~~~~~~~~~~~~~ + CategoryInfo : InvalidData: (Microsoft.Share...dletAddSolution:   SPCmdletAddSolution) [Add-SPSolution], SPException + FullyQualifiedErrorId :Microsoft.SharePoint.PowerShell.SPCmdletAddSolutIon


I have encountered this error when I deploy my SharePoint solution (wsp) to SharePoint farm as a global assembly.
This error is due to not singing the project before deploy.

Go to project properties of the SharePoint project.

Then select an existing signing key or create a new one to sign and build the project.

Now you can Build the project again and try using Add-SPSolution, which should work fine.

Tuesday, September 12, 2017

Insufficient SQL database permissions for user 'Name: doman\SP_UserProfiles SharePoint 2013 User Profile

Insufficient SQL database permissions for user 'Name: doman\SP_UserProfiles SID: S-1-5-21-2738186777-3937669245-3595685374-1123 ImpersonationLevel: None' in database 'SharePoint_Config' on SQL Server instance ''. Additional error information from SQL Server is included below.

The EXECUTE permission was denied on the object 'proc_putObjectTVP', database 'SharePoint_Config', schema 'dbo'.

This is a caused by not having permission to database objects of using least privileges configuration in farm configuration. Thus you need to give permission exclusively to this Object.
First you need to Connect to SharePoint Database using privileged account.
Then go the SharePoint Config Database and security section. Then go to Roles and find WSS_Content_Application_Pools under the Database Roles section.

Double click (or Right Click -> Properties) the item and select the Securable section in the modal window.

And click Search.. and select Object Type in the Window and Click OK.

Then click on Object Types and select the Stored Procedure.

 Type proc_putObjectTVP  in Object names section and check names for select the item.

and select the item and Click Ok.

Then you can see the item in the securable and give the execute permission to the object.

Tuesday, August 8, 2017

The URL is invalid, it may refer to a nonexistent file or folder or refer to a valid file that is not in the current Web in SharePoint 2013


This is common error when you are working with SharePoint.

This is can be due to various reasons but most common erros are due to Database issues.

1. Not Enough Space

Check your database related to SharePoint including

  • SharePoing Content Database
  • SharePoint Contect Database Logs
  • Temp Database Logs
  • SharePoint Service Databases
  • SharePoint Service Databases Logs
  • SharePoint Service Databases Temp Logs


check these databases have enough space to perform actions.


2.Not sufficient permision

Other reson is for not having enough permision to SharePoint Content Datase. YOu can find the related content databases from browsing through the cetral admin.


Go to application management and then click on Manage content databases.


Then you will find the related content database for the web applicaton. So make sure those databases having db_owner permision fo SharePoint Farm Account.

Monday, May 22, 2017

Getting started with NEW Office 365

Getting started with NEW Office 365

As you may already know, Office 365 comes with different subscription models. First you need make you’re your billing address is available in supported countries.

You can find the geographical availability by referring below URL.

Once you are confident with your location you can check the available subscription plans.

There are trial versions and service descriptions are clearly available in above link. Once you are done with the payment you will be redirect to a page with an introduction wizard, where you will be highlighted with main sections in Office 365.

I will provide a detailed article later in my post. But for the moment I will summarize the main


These screens talking about everything you see in your screen first time.

Admin Center

Admin center in where you manage your tenant and tenant settings including

  • Billing information
  • User licenses
  • Domain Setup
  • Data migration
  • Health

One Drive

This is where your cloud storage comes. Once Drive contents two part. Once drive user page and one drive admin page.

One drive user page can used to upload your data and files as any other service provider (like Google Drive, Drobox)

OneDrive admin can used to monitor as a whole when it’s comes to multiple users and sharing.


This is simply an apps store where you can fins enormous apps by various vendors around the world.