Skip to main content

O365: Automation - The First Step

 O365: Automation - The First Step


Making SharePoint Lists and Libraries is a simple process and these act as data containers for information passing through your business. We can capture data into the containers by creating the content from within the list or library, by scan and by import.

In most businesses, once the information, whether it is a document or data, is stored in SharePoint it will need to be followed through to ensure that it is made available to the right personnel and is acted on in a timely fashion.

The traditional method of ensuring this workflow is to send out email reminders and/or to place the information where the affected users can find it.

There is a better way.

Simple Work Flow 

The simplest work flow is to equip each List and Library with a column for status.

Using a SharePoint Library created to store customer orders


The status column can be seen to the right of the customer column

To add a status column go to Library Settings and click on create column

Name the column 'Status' and select 'Choice (Menu to choose from), enter the choices 


You can enter any number of choices in the box.  As this field will be used to filter the library the object is to cause the user to select from a list and ensure quality of field entry. 

 The Library or List content can now be filtered by the Status field

The above shows the Order Library filtered by Status = Competed

The filtered view can be saved and this will give it it's own unique URL, which means that the filtered view web page can be added as a tab in Teams or embedded as a web part page in a specific SharePoint domain.

In Practice

If an individual, or a group of Team members, are charged with taking action on new pending orders, they can be allocated a screen or Teams tab that will show only pending orders.
As the orders are accepted and approved, the same users can change the status field to Live or In Process.
Those orders will no longer appear in the Pending filtered list, but may appear in lists filtered for the updated current status.

Supervisors can, of course, be given access to the unfiltered list and will be able to see the entire order book. In addition they can see the length of time any order has been held at any particular status.

Manual v Automation

The above process works on manual allocation of a status field. However, the status field can also be automatically changed by using a Power Automate Work Flow.

We can show you how, or we can do it for you.



Comments

Post a Comment

Popular posts from this blog

Microsoft Teams

Microsoft Teams – Not only but also... What is Teams? Chat, Meetings, Calling, Collaboration | Microsoft Teams That’s the legend that Microsoft uses to head their Google listing. And it does those things really well. But -  There’s more . Teams also delivers a gateway to the fabulous world of SharePoint file storage, SharePoint and Office 365 index and search and Office 365 file security. All without the need for technical knowledge or extensive configuration. All well and good... What exactly does that mean? When you create a new team, simply click the ‘Join or Create a Team’ box at the lower left of the teams window, you launch a new team that has all the necessary attributes. This includes a mailbox, chat, call and video meeting area and a SharePoint file space with a basic library. Move shared documents, of any type, into the library and they are shared with other team members (the share facility is configurable to exclude individuals in the team who do not have sufficient righ...
Post a Comment
Read more

O365: SharePoint Searching in Office 365 and Teams

 O365: SharePoint Searching in Office 365 and Teams See also -  Other Office 365 Posts Earlier posts have discussed the huge advantages of centralising documents, files and communications in SharePoint and Office 365. One of the strongest functions in Office 365 is the ability to search all content so that locating data is easy. However, the search tools in Office 365 are not always obvious. Teams Search Teams is becoming really popular, not least due to the fact that it makes SharePoint very easy to deploy, use and control. At the top of each Teams General Tab is a search box This is multi function. Type / into the box and you will see a list of commands that will perform all sorts of Teams functions    The /Files option will return files you have recently accessed. Great, if the file or document you are looking for is actually in the recent file list. What if the information you require is in an older file, or in a different location? Location Search Also in Teams ...
Post a Comment
Read more

Knowledge - The Ultimate Resource

Knowledge – the ultimate resource? I can’t argue with that. As a writer I’m in the business of providing knowledgebase elements. I take my own experience and that of others, I then turn it into some form of written document that may be understood and acted upon by the intended audience. Quote from Wikipedia - Human-readable knowledge bases are designed to allow people to retrieve and use the knowledge they contain, primarily for training purposes. They are commonly used to capture explicit knowledge of an organization, including troubleshooting, articles, white papers, user manuals and others. The primary benefit of such a knowledge base is to provide a means to discover solutions to problems that have known solutions which can be re-applied by others, less experienced in the problem area. · The most important aspect of a knowledge base is the quality of information it contains. The best knowledge bases have carefully written articles that are kept up to date, an excellent information ...
Post a Comment
Read more