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

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

The New Computer Age: Infrastructure and the cloud

Most business managers don’t know it but this is very close to the truth. IT teams across the world live in day to day hope that their servers and networks hold together and pray that the disaster recovery schemes will be adequate in the event of catastrophe. IT people are highly professional and, of course, their server networks do deliver. Massive and expensive failure is surprisingly rare, provided that the IT department gets what the IT department needs in terms of budget. But, where budget is restricted, where the IT manager fails to make the business case for upgrade, then performance and security start to become threatened. In addition, a complex IT infrastructure brings with it the penalties of restrictive practise where a department head can’t get the software, services or technology required for a lean department because what is needed will not fit with the current IT infrastructure. So, what’s the answer? Sole Trader - Read more SME - Read more En...
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