Power Apps, Automation and BI

POWER APPS, AUTOMATION and BI

The Microsoft Power Platform is a software platform that enables the building of custom apps. These apps use workflow capabilities to help automate business processes.

Our Value Proposition

Our Power App Practice can assist you in automating your forms and processes.  You can choose from our library of pre-built power app templates, and customise to your business, or we can help you build an app to automate your specific business process. We work with you to understand your process and design the app to meet your business requirements. Then our developers utilise the Power Platform and develop an app in your Office365 environment.

3 Steps to Success

Choose from our pre-built power app templates:

* Expense Claim App  

*Timesheet App 

*Leave Request App

*Document Management Solution 

*Remote Work Request App

*Attendance tracker and

*Covid-19 Case Management App

*Web order Pick and Ship App and more.

We can add your company logo, and change to your company colours, and upload into your Office365 environment, quickly and cost effectively.

Customisation

  • We can work with you to customize a pre-built app to match your specific business requirements;
  • We can work with you to build an app to automate a specific business process for your company;
  • We can review current Nintex or Lotus notes processes and build a replacement within a Power Platform Solution.

Business Process Consultation

  • Our business process consultant can work with your business to uncover the process steps and design the process to enable the solution to be built within the Power Platform environment;
  • To automate a paper process does require some thinking about business rules and validations, and our experts can assist your business with designing the process and deliver an app that will work for you.

Please watch our video that showcases some of our Power Platform solutions we have developed for customers.

What is the Power Platform

Microsoft Power Platform and Common Data Service(now called Dataflex Pro).

The Microsoft Power Platform is a market leading Low-Code/No-Code platform that includes 5 solutions; 

PowerApps

Power Automate

Power BI

Power Virtual Agent and

PowerApps Portals. 

What is Low-Code / No-Code and why is it transforming our business?

A low-code/no-code development platform is a visual software development environment that allows business users- sometimes called Citizen Developers- to develop applications, using drag and drop application components, connect them together and create a mobile or web application.

This puts the power into the hands of the business and allows for rapid development of applications, automation of processes and the facilitation of business intelligence for the actionable, relevant data insights that organisations today are craving.

 It is therefore critical that IT gets ahead of this curve and offers this as a curated service to the business to prevent Shadow IT. IT can be a real accelerator and enabler of this change. 

Trends driving Low Code / No Code Development- by the numbers

Business Trends Driving Low-Code/No-Code Adoption

The primary drivers of this change are: 

 •A growing need to modernise legacy implementations; ERP, CRM, Web apps etc.

•Little appetite amongst business and IT leaders for large scale replacement programs due to; COVID, cost and project risk. 

•Outdated and manual processes- the need for speed and agility to support new business models and respond to changing market conditions 

•IT cant meet the demand for an integrated mobile and web experience to support a mobile and remote workforce 

•Siloed Data- the need quickly to consolidate, analyse and act on data from disparate sources

 •The emergence of platforms offering out of the box capability to rapidly develop and deploy applications at scale   

How could your business benefit from using the Power Platform?

The power platform provides a platform to build apps to replace manual forms and approvals via email.   Apps can automate a simple process – that is collect data, send for approval, notify approval. Or more complex, with multiple approval required, depending on budget authorisation limits, or other business rules.

The change to work from home has highlighted issues with business processes that were historically managed via paper and email approvals.  A power app can be accessed by users on mobile devices and apps are intuitive and easy to use.  Apps can include validations that paper forms cannot, eg your timesheet should add to 37.5 hours – an app can remind the user that this is case and ask user to solve issue before submission.  With a paper system, the form/email can go back and forwards many times before correct.

Power Apps can interact seamlessly with your ERP systems to enhance the user experience, or simply customize a process that is specific to your business that is unable to be solved using a legacy system.

Microsoft has developed a number of connectors that can be used to link your business systems with the Power Platform. 

A Power App can access ERP data, such as supplier/customer information, job/project codes, and automatically sync on a regular basis, so data is always up to date in the app.

If a pre-built connector is not available for your business system, a connection can be built.

An example, is inwards goods, where the goods arrive in warehouse, with a delivery docket.  The goods are required to be checked and counted.  The warehouse record the count on the delivery docket, and then enter the data into SAP, having to manually match delivery docket line item to SAP Purchase Order line item.  Automation using an app would be:

  • the warehouse scan the delivery docket;
  • the app uses AI to read the docket and upload relevant data to the app;
  • the app matches the Purchase Order Number to SAP data;
  • enables the warehouse to enter the quantity delivered against the Purchase Order goods request;
  • automatically notify manager of discrepancies;
  • upload quantity received into SAP.

Power Apps can replace your legacy systems and provide a simple, easy to use interface for users.

Our business process expert can assist in documenting current Nintex or Lotus Notes processes, assist your business to review/improve/update this process and design the new process for a power app solution.

Power BI is a powerful reporting tool that enables business to be able to report using data from disparate business systems.

Our expertise, in financial reporting as well as Power BI, can assist your business to improve their reporting capabilities.  We will design the most efficient way to store/access the data from multiple business systems, and link the data together, so that reports can be built in Power BI to meet business requirements.

All of our power app solutions utilize Power BI to provide relevant reports for the business.

Using AI, a power app can take a document, such as an invoice, and “read” relevant data, upload into the app ….

For example, when a supplier invoice is emailed requesting payment, the data on the invoice can be “read” by AI, and uploaded into the app, and notifies the manager to approve the invoice submitted.  Once the invoice is approved, data can be pushed from the app into the financial system, ready for payment.  

How does the Power Platform add business value?