OneDrive for Business – File Restore is rolling out

If you are using OneDrive for Business then today is a good day. Today Microsoft announced Files Restore for our OneDrive for Business customers.

Files Restore is a self-service recovery solution that allows administrators and end users to restore files from any point in time during the last 30 days. If a user suspects their files have been compromised, they can investigate file changes and allow content owners to go back in time to any second in the last 30 days.

This is huge since it gives users flexibility to revert their OneDrive to previous known stable state. To user File Restore functionality follow the steps below.

  1. Sign-in to your Office 365 ad go to OneDrive.
  2. Click on Settings and click Restore your OneDrive.
  3. One the restore page you will get a dropdown where you can either select predefined date range or select to enter your own custom date.
  4. When you select the custom date and time you will see the 30 day history and then you can select your custom date and time to restore the data.

Stephen Rose has a great blog post on this. You can read more about this at the URL below.

https://techcommunity.microsoft.com/t5/OneDrive-Blog/Announcing-New-OneDrive-for-Business-feature-Files-Restore/ba-p/147436

 

Cheers

Micorosoft Flow and Hyperlink Column

Microsoft Flow is a service that helps you create automated workflows between your apps and services. This could mean getting the approval process in SharePoint automated or automating certain tasks based on some triggers. Microsoft Flow is awesome and I would say that everyone using Office 365 should consider using Microsoft Flow to automate tasks.

When working with SharePoint Flow offer various actions and triggers. I will cover some of these in future but today I am going to talk about couple of challenges when working with Microsoft Flow and SharePoint.

If you are using SharePoint “Update Item” or “Create Item” action you would notice that currently (as of writing this blog post) they do not support picture column. I hope this gets fixed in near future.

Another interesting challenge I ran into was the Hyperlink column. Now Flow does support Hyperlink column but not 100%.

Let me explain what I mean. When using Hyperlink column in SharePoint, you can enter the URL as well as the Description of that URL e.g. my URL value would be http://www.microsoft.com but my description can be just Microsoft. This helps me not showing long URLs to the users.

When working with Microsoft Flow Hyperlink column only accepts the URL part. Currently there is no support for entering the description for that URL.

This could be bit annoying depending on your situation. Currently if you “Get Item” and update the HyperLink column using the Get Item context fields it would still not keep the description. You would end up losing the description when using Update Item action.

I hope this gets resolved soon as it is very important for services like MS Flow to catch up with SharePoint list columns. Until then you can use some workaround where you can have the URL and Description in different columns and then using the column formatting to rescue you. I know not the best option but until it gets fixed you can use that option.

 

Microsoft Teams – Managed Path for SharePoint Site

When using SharePoint online you would have noticed that you can create sites under /Sites or /Teams managed path. This is fine when you are creating classic sites where you can pick your managed path.

When creating modern sites you do not have option to select the managed path and it is always defaulted to /Sites managed path. This behavior is exactly the same when you create a new Team using MS Teams. When you create the new Team it creates the Office 365 Group as well as a brand new modern SharePoint site. This site is also created under the /Sites managed path.

What if you wanted to create all your teams connected SharePoint sites under /Teams managed path? Well it is possible as long as you want all your SharePoint sites gets created under /Teams managed path.

There is a setting in SharePoint Admin Center which allows you to select default managed path.

Go to your SharePoint Admin Center and click Settings.

Under Settings, scroll down to site creation section and there you would see that you can set the managed path for the new site that gets created.

Now there is another gotcha here. This would only work if you have your Self Service Site Creation setting is set to “Show the Create Site Command to user who have permission to create sites”. The moment you choose “Hide the Create site command” option, section which allows you to set the managed path is not visible.

I really wish Microsoft would allow two things here.

  1. Allow me to add more managed paths
  2. Allow me to set the managed path for SP Sites that gets created as part of Teams. Probably a setting on the Teams Admin page.

I understand there is not much flexibility here but I hope this help someone.

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.

https://channel9.msdn.com/Events/Ignite/Microsoft-Ignite-Orlando-2017/BRK3252

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.

https://github.com/SharePoint/sp-dev-column-formatting

To use column formatting you can go to your SharePoint list column and select “ http://recochiropractic.com/?gclid=CjwKCAjw9-KTBhBcEiwAr19igyucM0AJb6xTyKRYA2kDLpeU8cbapjPObUmDuec2-0uSZx-A-WIHChoC8H8QAvD_BwE Format this column” under “ Loudi Column settings”.

This will open a “ http://relaxapartmanitara.com/uncategorized/kostenlose-casino-50-freispiele-spiele-je-anfanger/ 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.

 

https://docs.microsoft.com/en-us/sharepoint/dev/declarative-customization/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.