Google

18 February 2019

SharePoint Workflow for Version History Buttons

Would you like to have a button at each library file that quickly takes you to the document's version history? Or somewhere else? I have recently published a kalmstrom.com Tips article on how to create a workflow that adds a version history button to each new file in a SharePoint document library. Similar buttons can of course be used for other things than the version history.

Check changes and restore earlier versions
The SharePoint version history is a useful feature that I always recommend customers to keep enabled. It is on by default in document libraries, but in other SharePoint lists you have to enable it.

In the version history, you can see who changed each document or list item and when the changes were made, and if necessary, you can also restore earlier versions of items and files. To see the version history in a SharePoint document library, you must select a file, click on the ellipsis and go to ‘Version History’.
Version History icons

Version history button
If you often use the version history, it would of course be easier to just click on a button to reach it. The workflow I suggest runs when a new file is added to the document library, and it adds a small image that is linked to the new file's version history in a separate column in the library.

Create rich text column in SharePoint Designer
We need to use HTML code for the version history button, and therefore it must be placed in a column with enhanced rich text. SharePoint lets us use enhanced rich text in multiple lines of text columns, but if you create the new column in SharePoint, you can only get the rich text in lists, not in libraries.

To have a multiple lines of text column with enhanced rich text in a document library, you must create the column in SharePoint Designer. Therefore, I show how to create such a column in my demo below before I start with the actual workflow.


SharePoint Workflows from Scratch
The Tips article and the demo is created for my new book, SharePoint Workflows from Scratch, that I hope to release on Amazon at the end of this month.

My recently published book on Microsoft Flow goes well, but a SharePoint power user needs knowledge about both flows and workflows. That way, you can select the best option for all SharePoint automation. (Should you want to create a version history button in Flow, refer to my demo about a tasks list progress bar, that uses a similar technique.)

Peter Kalmström
CEO and Systems Designer
kalmstrom.com Business Solutions

15 February 2019

Technical Savvy and Dedication Makes Indore Cleanest in India

Indore has been elected India's cleanest city in 2018, among 4203 inspected cities. My congratulations to all who live Indore, among them our Indian team members!

Clean India Mission
In 2014, the Indian government launched the Swachh Bharat Mission (Clean India Mission) to enhance the nation's hygiene, waste management and sanitation. A "cleanest city" contest is part of the campaign, and Indore was number one in 2017 – and again in 2018! Now the city is hoping for a hat trick in 2019!

This achievement owes its success to the joint efforts of the Indore authorities and the two million inhabitants. These are the key factors:
  • Garbage collection: All garbage bins have been taken away. Instead there is door-to-door garbage collection every day. Garbage is collected from shops in the evening, and markets are cleaned at night.

    The garbage collection is performed efficiently with the help of specially designed software and GPS. It is supervised from a control room where the operators have direct contact with all truck drivers.

  • Garbage processing: Wet garbage is used for compost making. Robots sort the dry garbage in 27 categories. What cannot be sold to recycling is converted into fuels. This means that everything is taken care of, and no more dumpsites will be necessary.

  • Education: People have started carrying small dustbins in their cars to collect their garbage. Use of plastic is discouraged. Teachers and parents have educated children about the dangers of littering, and an eighth pledge has been added in the wedding rituals: and oath of cleanliness.


New gardens
The Indore inhabitants have not only received a cleaner environment. Around 100 acres of old dumpsites have also been reclaimed and transformed into gardens and woodlands that further enhance the city.

We have had a kalmstrom.com office in Indore for the last 10 years and during my many visits to the city I have seen continuous improvements. Indore shows how a combination of high technology and education can achieve stunning results, and I hope that many other cities will follow the example!

The video above is from India Times, and here are links that give further information:
India Today
NDTV
IndiaWater Portal

Peter Kalmström
CEO and Systems Designer
kalmstrom.com Business Solutions

11 February 2019

Roll Back SharePoint Column Changes with Flow or Workflow

In two new kalmstrom.com Tips articles I describe how unwanted column changes can be rolled back with a flow or workflow.

Protect column values
SharePoint Designer iconBy default, SharePoint users have Edit permission over lists and libraries, and that allows them to change column values. Users must have this permission level to be able to work actively with the content, but this means that they also can change column values that should be kept as they are. It is possible to restrict their access to certain items or documents, but it is not possible to restrict access at column level.

Flow iconI therefore suggest a workflow or flow that simply rolls back any changes in the column that should be protected. This does not stop the column value from being changed, but as the unwanted change starts the flow/workflow and the change is rolled back, no harm is actually done. Any changes can still be seen in the version history, if you want to track them.

Set original column value
The process is similar for both automation methods. We assume that the first value that was added to the column is the original one, that should be kept. The first step is therefore to decide what that value is and save it in another, hidden, column.

Check if the value has been changed
Next step, is to decide if the column that should be protected has been changed. If that condition is true, the flow/workflow will roll back the modification so that the changed column gets the value from the hidden column.

Workflow
To automate this process in SharePoint Designer, I recommend creating two workflows: one that runs at creation and sets the original value and one that runs at changes and rolls back any modifications of the protected column.


Flow
If you prefer to use a flow for the roll-back process, it becomes a bit more complicated. That is because Microsoft Flow does not (yet) have the SharePoint trigger "when an item is modified".

Instead, we have to use the trigger "when an item is created or modified" and make the flow understand if there has been a creation or a modification. We can do that with a condition that checks if there is a "null" value or not. SharePoint columns have such a value before they are used for the first time.


Microsoft has created Flow to have a more user friendly alternative to workflows. In this case, however, I find the two workflows easier to build than the single flow. I hope that Microsoft will add the SharePoint trigger "when an item is modified" to Flow in a near future.

By Peter Kalmström
CEO and Systems Designer
kalmstrom.com Business Solutions

07 February 2019

SharePoint Online Essentials for All Users

SharePoint Online Essentials cover I am happy to announce the release of my new book and e-book: SharePoint Online Essentials. It is intended for SharePoint Online users with no administrative capacity – just ordinary users with the default Edit permission or less.

Requests for a basic book
I have earlier written several more advanced books about SharePoint Online: SharePoint Online from Scratch, SharePoint Online Exercises and SharePoint Flows from Scratch. These books have become popular among SharePoint administrators and other power users who need to understand more about SharePoint than the basics.

However, I have also been asked to write a book about only those features that each SharePoint user needs to know to work efficiently with SharePoint. That is why I have put together SharePoint Online Essentials. Just like my other books, this new one has links to articles with video demonstrations from the kalmstrom.com Tips section.

Modern exercise included
SharePoint Online Essentials includes basic information about classic and modern sites, pages and apps. Readers will also learn how to share content and how to work with SharePoint lists and document libraries.

At the end of the new book, I have included an exercise from my book SharePoint Online Exercises: "Create a modern sites intranet". Here readers can make practical use of what they have learned by building and customizing modern team and communication sites and giving them a joint navigation. The process is explained step by step with many images.

Give to each user!
Peter Kalmström on Amazon.comSharePoint Online Essentials can be purchased from Amazon, and the book is available as a Kindle e-book and in a paperback edition.  If you buy the paperback from amazon.com you will have the e-book for free, as SharePoint Online Essentials – just like all my other books – participates in the Kindle Matchbook program.

I hope that organizations who are introducing SharePoint Online to their staff will find SharePoint Online Essentials a good help when it comes to educate the users. Therefore, I have decided to nearly give it away. That is not possible on Amazon, but the e-book is only $0.99. The paperback must cover the printing costs, so here I had to accept a higher cost: $3.99.

SharePoint Online Essentials may also be downloaded as a free PDF file from the European SharePoint, Office 365 & Azure Community.

Marketing
SharePoint Online Essentials will not make me a rich man, but in the long run, I of course hope that the book will serve as a marketing tool for my more advanced books and also for the kalmstrom.com products and services. We already see that new customers often refer to the books and the kalmstrom.com Tips articles.

By Peter Kalmström
CEO and Systems Designer
kalmstrom.com Business Solutions

05 February 2019

A Successful Adventure – A Decade Of Cooperation

Jayant Rimza In February 2009 I hired a young but very capable developer for the kalmstrom.com products. Today he is my friend and business partner, and I owe him a lot. His name is Jayant Rimza, and since 2010 he has been the director of the kalmstrom.com Indore office.

In 2009 we still hired our few Indian employees through a partner who had his interest in kalmstrom.com as a side hobby. That worked well in the beginning, but as the demand for the kalmstrom.com products grew, we wanted something that would give better control, more dedication and an enhanced team feeling.

TimeCard for Outlook iconAfter some time, I realized that Jayant Rimza was the right person to build the qualified team we needed. He was also eager to try, so we decided to start on our joint adventure. At that time, the kalmstrom.com portfolio had only a few Outlook add-ons: Calendar Browser, TimeCard and Folder HelpDesk. However, both Jayant and I had a lot of ideas that we wanted to develop and try on the market.
The kalmstrom.com Indore team
Today I can say that our cooperation has been a success, both on the business level and personally. During Jayant's management, the Indian team has grown considerably and is now more qualified than ever, and we have many more kalmstrom.com products. Most of the younger solutions are created for SharePoint, a Microsoft platform that was rather new in 2009 but where we both saw a great potential.

SharePoint iconAs more customers spread the word about kalmstrom.com Business Solutions, there was a demand for custom solutions and support contracts as well. Today, these services has become an important part of our business. We both appreciate this development, as it makes our work more varied and interesting.

Jayant and I get along very well also on a personal level – and I have found an Indian family! Since 2009 I have tried to visit India at least once a year, and the Rimza family has always taken very good care of me. Below I am posing for the camera with Jayant's wife, Sushma, Jayant and their son Atiksh.
Peter and Jayant
I have attended several weddings, and I have travelled with Jayant and the team and seen many fascinating places. Two more skilled and dedicated family members have also joined the kalmstrom.com team: Vijayant and Rituka.

I chat with Jayant nearly every day, to plan the current custom solutions and future development of the kalmstrom.com products. He often gives good suggestions, but even when we don't agree on how things should be done, we can always discuss in good humour and come to a solution that satisfies us both.

I am sure that my prosperous cooperation with Jayant Rimza and the Rimza family will continue many years into the future. It still feels like an adventure!

Peter Kalmström
CEO and Systems Designer
kalmstrom.com Business Solutions