Skip to main content

O365: Make Life Simple. Grab Data on the Go

O365: Make Life Simple. Grab Data on the Go.


Earlier Office 365 posts have pointed towards simple ways to make SharePoint List and SharePoint Library data containers, simple ways to populate these with data that is useful to business and simple ways to filter that data for useful output commination like invoices and reports.

Reading back through those posts it becomes obvious that the more data you collect, the more you can do with it. This is probably best highlighted in the CRM example, where all communication between company representatives and individual customers is captured and used across the business.

The great thing about modern technology is that even when visiting a customer the person representing the business can access the same data that is available when sitting at a computer in the office.

In addition, updates can be made to the data without a return to the office being necessary.

Accounting

The same can be said of accounts and expenses records. Hotel, meal and fuel receipts can be filed direct from a smart phone instead of filing, indexing and storing all of those annoying bits of paper that have tied us down in the past.

Introducing Power Apps

Accessing and updating data through Teams and ASPX pages is great and can accommodate most business needs, but sometimes data update through a smart phone is not as easy as it could be. Buttons and links are small and a field worker in a hurry may find it necessary to spend more time in order to be accurate.

To overcome this you can easily deploy a Power App that will deliver a simple smart phone screen, with large buttons, that will file the data directly to the SharePoint List.



The above screen shots display a simple Power App generated from a SharePoint List called Contacts for an Android or IoS phone.

The left screen displays all the customers in the list, these are searchable and sortable and the screen incorporates a find function.
Clicking the right arrow next to a customer name displays the details for that customer. 
A new customer can be added or detail can be updated provided that the user has the necessary permissions.

Generating a Power App.

This is the really good bit about Office 365. You hardly have to do anything at all.

On a PC, launch the SharePoint List 
and click the menu item to launch Power Apps.

Name the App and allow Power Apps a few minutes to build. Once done test the operation and then share it with users.
You can either email the share or launch it into Teams as a Organisational App.

The App can be used from a PC as well as from a phone, so the user interface is the same for both field and desk workers.

Wide Ranging Uses

You can do the same with any SharePoint List, so the range of potential uses is almost endless. 


The above images show an inventory control app that can be updated from a tablet or phone in the store room.

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


Comments

Popular posts from this blog

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 ...

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. ...

O365: Getting the best out of SharePoint

O365: Getting the best out of SharePoint See also - Libraries , Lists , Linking List and Library Simplicity Anyone who has read my earlier posts on creating, populating and joining data containers like Libraries and Lists in Office 365 SharePoint will know how simple it is. Giving a little thought to what data or information you want to keep and what you will use it for in the future is the hard part. Once you have that, building the lists and libraries is as easy as creating a spreadsheet.  But, a SharePoint list or library is far more flexible and effective than a spreadsheet can ever be. Shadow IT This is the name given by IT departments to the practice of hiving off chunks of corporate data into silo data stores controlled and maintained by individuals. A mobile phone contacts list is a great example. The same data might be held in a dozen or more separate phones and the data might never be synchronised. Personal spreadsheet lists can fall into the same category. Data from any ...