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
3 Steps to Success
Choose from our pre-built power app templates:
* Expense Claim 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.
- 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;
Power Virtual Agent and
Power BI is a business intelligence (BI) application used to connect and display data through real-time dashboards. This application can collect data from on-premises or cloud data sources; these data sources can be from Microsoft-based or third-party applications. There are currently over 300 supported data sources.
PowerApps is an application that allows users to create low-code applications for desktop and mobile platforms that run off data. PowerApps allows users to connect easily to Power BI and Automate, as well as connect to other applications such as Dynamics and Office 365. PowerApps also comes with Common Data Service (CDS) -- which allows users to securely store and control data used in business applications.
Power Automate is a process automation application which allows users to create automated workflows between Microsoft applications and other services. The application is designed to be used by non-technical users and to automate business processes as well as workflows.
Organisations can use Automate to create their own automations or use templates for any common automations. Users can also set triggers, alerts, emails and push notifications with Automate as well. The workflow automation is made with insights that can be gained by Power BI. The workflows can be run from the cloud and managed by Microsoft.
Power BI, PowerApps and Power Automate all work together to achieve Microsoft's goal: to create a platform that can gain insights from data and use that data to drive and automate business processes.
Power Virtual Agents Power Virtual Agents empowers teams to easily create powerful bots using a guided, no-code graphical interface without the need for data scientists or developers. Power Virtual Agents addresses many of the major issues with bot building in the industry today. It eliminates the gap between the subject matter experts and the development teams building the bots, and the long latency between teams recognising an issue and updating the bot to address it. It removes the complexity of exposing teams to the nuances of conversational AI and the need to write complex code. And, it minimises the IT effort required to deploy and maintain a custom conversational solution.
Power Apps Portals allow organisations to engage with external customers and partners by quickly creating low code/no code portals that give internal and external users secure access to your data either anonymously or through commercial authentication providers like LinkedIn, Microsoft, Facebook, and Google, or enterprise providers such as Azure AD B2C and Okta. The beauty of the service is that you can integrate all your data and bring data from the apps you use—including Power BI and Power Automate—together with the Common Data Service and enable your users to interact with it anytime, anywhere . You can enrich portals with model-driven forms, views, lists, charts, and dashboards to offer more value with each interaction.
Common Data Service(Dataflex Pro)- Microsoft Power Platform works with the Common Data Service, which is a cloud tool on Azure that acts as an underlying data platform. The CDS also provides a data schema that an application can operate with. The Power Platform also works using what Microsoft calls a "triple-A loop." This term refers to the loop data takes in the platform: gaining insights from data, using that data to drive business processes and the process that data can automate.
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
Application development that will be delivered on Low Code/No -Code platforms by 2023 - Gartner
IT Dev budgets required to support legacy apps- IDC
Ratio by which demand for mobile apps will outstrip developer capacity - Gartner
Workforce which is now mobile and working remotely due to COVID19
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?
- Faster collection of information from frontline workers
- Faster an easier transfer to decision makers
- Decisions made are much closer to real time