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.


Labels:

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: Getting Really Useful Data into SharePoint Libraries

O365: Getting Really Useful Data into SharePoint Libraries See also - Blogs on  Library ,  List ,  Linking ,  Teams ,   Invoicing ,  Workflow ,   Bulk Invoicing  and  Spreadsheet Data A really useful SharePoint Library structure will give you something like this -  Just typing the words 'Credit Card' into the SharePoint search box returns a list of items relating to credit card across the entire Office 365 site. Security Don't worry about users accessing documents that are restricted. If you create or place a document into a Teams Document Library, it will be available to members of that Team by default. However, each document can be locked down to no access, view only or edit. You can also stop sharing any document, or alternatively share only with the members of the team you select. Users with whom the document has not been shared with will not be able to access it. Being More Specific   That's fine if you know which Credit C...
Post a Comment
Read more

O365: Create a SharePoint-On-Line Library

O365 is a tremendous resource. It can serve a business better when SharePoint on-line libraries are used as a repository for files and documents on which collaboration is required.  Instead of circulating documents for input by different users, simply save them to a SharePoint library where selected personnel can access them for update. Creating a library is a simple process which needs no technical expertise greater than the ability to use a computer. For this exercise we will create and start to populate a library for storing invoice documents.  Select the Site  An O365 domain can contain many sites. Libraries and Lists within a site can be made to interact with one another so data can be readily shared across the site and recycled. For example, if we choose to create a Customer List within a site and we populate the list with customer names and addresses we can allow other libraries and lists within the site to access and use the name and address data. So, the first jo...
Post a Comment
Read more