SharePoint Online – Picture Column and Column Formatting I had earlier blogged about Microsoft Rolling out column formatting to the first release tenants and how it could be useful in many scenarios.

For anyone who wants to get started with column formatting following article is by far the best technical documentation.

Today I am going to talk about one specific scenario where you could use column formatting.

Let’s assume that you want to create a picture column in SharePoint to show some sort of status progress. I know we can achieve this in many ways but just for the sake of this blog post we are going to assume that you have a column in your list/library of type Picture.

Now in SharePoint Online when you have a picture column and you insert the URL of the image in that column it displays the image. This image is clickable and when you click on that image it opens the new tab with the image displayed.

This behavior may work in some scenarios but in our case since we want to use this picture column just to show the status progress we do not want that image to be clickable.

We can use column formatting for this. Follow the steps below to make that image not clickable.

  • Open context menu on your image column and select à Column Settings à Format this column.
  • This should open JSON editor on right hand side.
  • Paste the following code in the editor and click Save.


    "elmType": "div",
    "children": [
            "elmType": "img",
            "txtContent": "",
                "min-height": "initial",
                "margin-top": "0px"
            "attributes": {
                "src": "@currentField",
                "width": "100%"


As you can see I am not doing anything extra ordinary. I am simply displaying the same image without anchor link. If you follow the article that I have linked above you would be able to figure out it’s straight forward.

One thing that I needed to do on top of that is to add couple of styles. Since when you use column formatting it uses its default class and that makes your image smaller and aligns it to the top.

I have set min-height and margin-top attributes to align images properly with the list item as well set the width to 100% so it does not shrink the image.

I hope this helps to get started with the column formatting.

In the next column formatting article I will cover how to make image clickable using the URL from the different column.

SharePoint Online – Column Formatting rolling out to first release tenants

At Ignite 2017 Microsoft announced the Colum Formatting feature in SharePoint Online. You can check out the awesome session on Channel 9.

Microsoft have started rolling out the column formatting feature to the first release tenants. For anyone who did not hear about column formatting, it helps customizing how SharePoint list columns gets displayed.

If you are currently using SharePoint on-premises then it is like JSLink. Not exactly the same but you can achieve many formatting options using column formatting. As a matter of fact there is git repo for the column formatting samples. Check them out below.

To use column formatting you can go to your SharePoint list column and select “ buy Lyrica dubai Format this column” under “ generic Misoprostol Column settings”.

This will open a “ Westervoort Format column” window on the right where you can paste your JSON and either click Preview to see the changes or click Save to apply the changes.

If there are any syntax errors then you will get the error notification on that screen so you can correct the error.

Anyone who can create and manage views in a list can access column formatting from the column settings.

For anyone who wants to get started with column formatting must check the following article out as it has all the details you need to know about column formatting.


I will cover some examples that I have used in my next blog post.

SharePoint Communication site pages in Microsoft Teams

For anyone that is living under the rock, in May last year Microsoft announced Communication sites. Communication sites are mobile friendly and allows users to communicate to people throughout the organization with beautiful, dynamic, mobile-ready communication sites and pages that keep everyone informed and engaged.

You can read more about that HERE and HERE.

While communication sites are awesome they are not Group connected sites. In many cases you would want to use Communication pages within your Team.

It is very simple to bring them to your Microsoft Teams.

  1. Go to Microsoft Teams and click Add a Tab (+)
  2. Click WebSite under the various options.
  3. Give tab a name and paste the URL and select if you want to share that message in your Team channel.

  4. Click Save and you should see the communication page shows up in your Team Tab.



Teams is smart enough to trim all the additional SharePoint controls and display only the page in the Teams teab.

This is one of the awesome feature and I cannot wait to start integrating MS Teams and communication pages.

Microsoft Flow – Get Item from SharePoint List

I wanted to write this blog post for a while. This one is on how to use Microsoft Flow and get SharePoint list item.

So when using Flow you have two actions for getting a SharePoint list Item.

  1. SharePoint  – Get Item
  2. SharePoint – Get Items


Picture above displays the description of each action.

Lets talk about the SharePoint – Get Item action first. As you can see that when using this action you will need to specify item ID to get the item. Now for the most part this would not work unless you have a context of the item and you are passing the ID using the context. We will talk about this in details when I cover For Each action. But for now my recommendation is do not use this action using the hard-coded ID unless you are in a situation where you have pretty static list and ID never changes.

Now the second action, SharePoint – get Items is the real deal. I mean do not judge that action by the description provided by Microsoft. That description does not justify the action. 😀

This action allows us to specify query to get the items and also allows us to specify Order By and Item count.

You need to specify ODATA filter query. You can get some general ideal about ODATA query using THIS article.

Basically you would have to specify field’s internal name and then your expression and then your value.

If you are expecting more than one item returned then you can use the Apply to Each action which I will cover in future blog post.

Office 365 – Cannot add Plan to your favorites – Planner

For anyone that is new to Office 365 and not know what Planner is then you should spend time understanding MS Planner service. Planner makes it easy for your team to create new plans, organize and assign tasks, share files, chat about what you’re working on, and get updates on progress.

In this blog post, I am not going to talk about Planner much but I am going to talk about potential issue that you may face depending on your tenant configuration.

When you are on the Planner Hub you see various options to visualize your plans. One of the feature is to add plan to your favorites.

When you add planner to your favorites you may receive the following error. As I said earlier this is not going to be the case for the most part but as far as I know in one specific scenario you may receive the following error when adding plans to your favorites.

Upon researching I found the following very useful blog post.

With all credits to Brian (author of the blog post) I am posting scenario that I ran into where I go the above error.

In hybrid scenarios we do not support comments or favorites for users with their mailboxes on-premises as the users needs to have an Exchange Online mailbox to engage with these features.  EXCEPT – if the user does have an external email address configured and is configured as a MailUser in Exchange AD.  In this scenario the user will be able to use these features even though they have no EXO mailbox.  If the user is configured as a User rather than MailUser – and has no external email address then things won’t work.  This has explained the situations where some users work and some don’t in a hybrid environment.  Also of course some users may be fully in EXO and others in on-premises mailboxes.

So, if you run into the above error make sure to read the above blog post.

I hope this helps someone who is currently using Exchange in Hybrid scenario and running into this planner error.


Microsoft Teams now rolling out Guest Access

If you are using Microsoft Teams then you must know that  the #1 request feature on Microsoft Teams uservoice is to allow Guest Access. Microsoft Announced on September 11 that they will start rolling out Guest Access to Microsoft Teams.

This is awesome news and I am looking forward to testing the guest access with Microsoft Teams.

Now there are couple of things that we must know. Microsoft Teams have decided to only allow Azure AD accounts that are currently part of Office 365 tenant. This means if you are inviting external user as Guest to your MS Teams they must be part of any other Office 365 tenant as a regular user. Then you will be able to add them to your Team.

Now to add external users you will need to make sure that this setting is enabled at the admin level.

  • Navigate to your Office 365 Admin Center
  • Click Settings –> Services and add-ins –> Click Microsoft Teams
  • Select Guest from the “Select the user/license type you want to configure” dropdown
  • Turn ON the “Turn Microsoft Teams on or off for all users of this type” switch.

Once this is turned on you will be able to go to your MS Teams and add external users. Once the external users are added they can switch their tenants to access the Teams. Currently switching the tenant option is not supported on mobile devices and hence you must use the desktop app or browser to switch the tenant.

This is a great start by Microsoft Teams and hopefully in future we will more improvements around this area specifically allowing any external users and allow switching the Teams using mobile devices.