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 List v Spreadsheet - which is best?

O365: SharePoint List v Spreadsheet - which is best? See also - Blogs on  Library ,  List ,  Linking ,  Teams ,   Invoicing ,  Workflow  and  Bulk Invoicing The image shows the same data displayed in different applications. On the left is the information imported into a SharePoint List and on the right is a table representation in Excel What's The Difference? Let's assume you are running Office 365 and you may even have Teams launched. You need to provide your users with access to a table of data, the sort of thing that has traditionally been circulated in spreadsheet format. Only now, you have SharePoint Lists as well.  So, which is the best way to store, maintain and distribute the data? In both apps you can sort and filter the rows and columns, you can add new columns that read original columns and perform arithmetic, mathematical, statistical and text manipulation on the content of the original. In the SharePoint List linking to other lis...
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