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

The New Computer Age: Office 365 Vs Google, Dropbox and Others

Differences in Software as a Service ( SaaS ) This is the 21st century, the New Computer Age. Cloud services and SaaS are available for all to use. Word on-line, Excel on-line and Power Point on-line are just such services. They are available to all who want them, they are free, if taken via One Drive Live, and they enable the creation, editing and viewing of Word documents, Excel spreadsheets and PP presentations on ANY device that has a browser installed. This without any need to install software on the device used. The on-line software that is used to create the files is the same on-line software used to view them. There can be no incompatibilities and no missing fonts. Open Document Standards, to which these most office applications conform, requires that any document file should contain the properties of style, layout, font etc. These elements are the property of the document file and will travel with it wherever it is stored or sent. However, issues can still aris...
Post a Comment
Read more

O365: Mobile Apps - the easy way

 O365: Mobile Apps - the easy way See also -  Other Office 365 Posts Anyone following these posts will now know how easy it is to create data stores in SharePoint for documents and files and for listing data, such as customer details. We've also looked at making this data easily findable, how to flag items for the attention of individuals and teams within the Office 365domain and moving work through the system in a controlled manner. We've also seen how we can access this content when away from the office via mobile apps for Teams, SharePoint and OneDrive. Occasionally the standard apps aren't really convenient and fail to lend themselves to mobile use. I'm thinking here of functions like stock lists, customer contact lists and the like, when the standard app delivers too much detail for a small screen, or where links and buttons are small and difficult to use. For these functions it would be better to deploy an app that is designed for fast, effective use on a mobile. ...
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