Creating A Low Code App Using PowerApps & The Power Platform

Creating A Low Code App Using PowerApps & The Power Platform

Mike Chappell

Mike Chappell

Solutions Director - Public Sector|Kerv Digital

Published 06/07/22 under:

Have a question about something here?

Get in touch

Step By Step Low Code/No-Code App Building

Demonstrating the building of a low-code/no-code Microsoft PowerApp with text recognition, using Azure Cognitive Services

 

The Kerv Digital team recently attended an all-day Microsoft Hackathon to demonstrate how easy it is to use the Microsoft Stack, Power Apps and the Power Platform to create low code/no code apps.

The various teams involved weren’t given a brief till first thing in the morning (so there was absolutely no prep time) with just four hours to design and create a solution.

For those of you who have never attended a Hackathon hosted by Microsoft before, these briefs typically take the form of a business scenario or problem to solve… You then go away and as a team come back with your finished solution, built using the Microsoft Stack, and present it to the other 70/80 attendees, all who have done the same thing, and then (the fun bit) have your solution judged.

 

The brief on the day was to create an app that could be useful during a COVID-19 world.

Our intrepid Kerv Digital team decided to build an app that would help getting people their cars and their rubbish whilst in lockdown into and out of recycling centres.

They chose this as the scenario had actually happened to one of the team recently who’d (believe it or not) had to use a re-purposed theatre booking system to book a time slot at his local tip, then, on arrival, the staff were waiting with big clipboards and reams of paper/license plate numbers to check people in and out.

Not an ideal situation we’re sure you’d agree!

 

In traditional Kerv Digital fashion they rolled up their sleeves and decided to fix that problem… in under four hours!

The Hackathon was on!

 

Their chosen solution was a website (Power Apps Portal) within the Microsoft Power App Platform that an end user could access to book a time slot at a recycling centre.

Their data would then be stored in the Common Data Service (more on that in a minute) but the main thrust of the solution on the day was automatic text recognition for the staff checking in cars.

The app would allow staff at the recycling centre to take a photo of a car coming in and automatically check if that person had a booking and if so, what time they were booked in for.

 

The first thing they did was to head to make.powerapps.com where they created a demo environment.

The great thing with PowerApps is that you can just go on to the Microsoft Dynamics trial section and say… “I’d like to play around with Dynamics and the Power Platform please” and it’ll create you a temporary area for you to play in that’s free for the first thirty days.

 

The first step was to head to entities and, as you can see below, select bookings.

 

 

From there, the team guessed a few details that would be helpful to know about someone visiting a recycling centre (or tip if you prefer).

 

 

At this point (just in case any existing or potential clients are reading this) we should point out that Kerv Digital aren’t in the habit of guessing anything and if this was a real project we’d have conducted a lot of research into your organisation, with our Business Architects and Solution Architects building out both staff and customer personas for how the app would be used… but the team only had four hours so we’ll give them a bit of a break!

Our Power App Pro builders. As they’d been trained to do, first defined the problem (managing queues in and out of recycling centres), before building user personas and designing a solution with a clearly defined outcome of what the app should achieve as an end result.

 

Once the fields they wanted to capture had been structured (and adding new fields was literally just a case of clicking the add button, typing the field name and pressing save) they just need to head to the Apps tab (shown below) and start building.

 

 

As mentioned, all the data was to be held in the Common Data Service so once they’d done that it would automatically start to build a default app with loads of options for customisation.

 

 

Once you click connect (bottom right in the image above) PowerApps will head off to read the entity and create a mini app that should allow you to view records within that entity, edit them and add new ones.

 

 

Back in the bad ol’ days of yore (and depending on the sector you’re in) this could have taken a developer anywhere from a day or so to six months but with the Microsoft’s PowerApps Studio and a bit of Kerv Digital know-how you can see the team accomplished the same result in minutes.

Customising and then integrating the app into specific business processes  is a more complicated matter and will likely require a Power Apps Pro builders expertise but as you can see, the basics aren’t insurmountable for anyone with access to the Microsoft Power Platform.

 

 

From here you can see Power Apps has gone away and created three screens.

A browse screen in the middle with a list of all the bookings…

 

 

A detail screen with an expanded view displaying more information about each booking

 

 

And an edit screen that would allow you to amend any booking details you might wish too.

 

At this point not one line of code has been written for this app.

It took about four/five minutes from having no app to having a perfectly functioning data capturing app and that’s the power of the Power Platform and Power Apps itself!

 

So far, the above is the basic framework you’d need to get an app up and running. We’re now going to demonstrate how easy it is to expand it out.

 

The first screen we’ll add is a bit of a blank screen for when an end user first opens the app.

To do that’s it’s as simple as clicking new screen (you’ll note we’ve still not had to write any code)

 

 

And choosing the kind of screen we want

 

 

We take this blank screen and move it to the very ‘top’ of the application

 

 

As we’ll want this to be the very first thing users see when they open it up on their phones.

From here we can add image both images, texts and functioning buttons.

 

 

 

(Still no real coding!)

These buttons will give the staff at the recycle centre the option to view bookings or book people in.

Now, making these buttons ‘do something’ is actually incredibly easy.

All you need to do is select the button you want to work on and head over to advanced settings.

 

 

If you choose the onselect box, which means when the user ‘does’ something with the button (i.e. presses it) you can describe what you want to happen.

In this case we want them to navigate somewhere (one of the many pre-built options within the Power Apps toolkit).

 

 

Power Apps will then very helpfully list all the screens you’ve previously built for you to select which one you wish the button to navigate to (if you’re feeling fancy you can even add in a pre-built transition fade).

Right… now let’s get on to the fun bits…

 

 

Rather than manually typing in the number plate you can head to media and select the camera option.

 

 

On a mobile this automatically defaults to your device’s camera, and it’ll do the same thing if you’re on a tablet or laptop.

Once that image is taken by the app it can be saved in a database or sent off to another API or service. Power Apps had always been able to do that though.

What’s really new and cool is this bit here called AI Builder…

 

 

Power Apps being Power Apps there’s then lot’s you can do within this section with the analytics like:

 

  • Business card reader
  • Form Processor
  • Object detector
  • Text recogniser

 

 

As we all know there’s loads of things within Microsoft Azure around Cognitive Services that will try and learn or recognise things for you and many of those have started to be added into the Power Apps framework.

The one we used for this app was text recogniser…

 

 

This camera option, like the last, will automatically default to your devices standard camera or you can just choose to upload an image.

 

 

 

Related Articles

You might also be interested in

From our world to yours

Compliance monitoring under the spotlight

From our world to yours

The rise of business messaging apps and the need to stay on...

From our world to yours

Compliance: important ownership changes while adapting for flexible remote workforces

From our world to yours

Data silos and legacy compliance monitoring systems – barriers to effective surveillance...

From our world to yours

What it takes to top the Gartner CCaaS Magic Quadrant

From our world to yours

Why gamification is topping the bill for contact centre agent workforce management...

From our world to yours

8 contact centre trends to future proof your business

From our world to yours

Spotlight on Local Government – Where is CX heading for citizens?

From our world to yours

Think bigger with Microsoft Teams.

From our world to yours

Microsoft Teams is here to stay, what’s the next step?

From our world to yours

At Kerv we want to make customer-first really mean something…

From our world to yours

Different by design

From our world to yours

How Engagement Technology is Transforming the Membership Sector

From our world to yours

A modern CRM system needs a modern data platform

From our world to yours

What is… Microsoft Cloud for NonProfit?

From our world to yours

6 Back-office technologies modern supply chains should already be using

From our world to yours

Re-imagining CX in a golden age of integrations – combining Genesys and...

From our world to yours

Maximising CX value through AI-driven digital engagement

From our world to yours

Experience as a Service: What it is, why it’s important and where...

From our world to yours

Achieving empathy across digital channels

From our world to yours

Redesigning CX from the ground up

From our world to yours

Genesys EMEA Cloud Partner of the Year 2020

From our world to yours

Life at Kerv Digital As A Functional Consultant

From our world to yours

Life @ Kerv Digital as an Apprentice Power Platform Consultant

From our world to yours

How To Increase Efficiency With Dynamics 365 Supply Chain Management

From our world to yours

Supply Chain Control Towers – The Tech That’s Changing Logistics Forever

From our world to yours

Supply Chain Digital Twins – The What, The Who & The Why...

From our world to yours

On-Demand Logistics & The Tech That Makes It Possible

From our world to yours

What Is… Insurtech?

From our world to yours

What Is… Microsoft Cloud For NonProfit?

From our world to yours

16 Times You’ve Been Using Artificial Intelligence Without Realising

From our world to yours

Jack’s Worried – His Website Is Losing Him Dues Paying Members

From our world to yours

From Paper Based To Cutting Edge… With Zero Downtime

From our world to yours

Life at Kerv Digital as a UX Designer

From our world to yours

Sarah is Sad – Her Staff Aren’t Finding New Members Or Engaging...

From our world to yours

How To Squeeze Hidden Value From The Hidden Data You Didn’t Know...

From our world to yours

Reducing Member Churn & Delivering Member Insights With Data Science

From our world to yours

Life @ Kerv Digital As A Dynamics Functional Consultant

From our world to yours

The Effect Fintech Is Having On Our Everyday Lives

From our world to yours

Dealing With Ethical Walls In Tech… Ethically

From our world to yours

Life @ Kerv Digital As A DevSecOps Engineer

From our world to yours

IOT: Dragging The Future Of Healthcare Into Today

From our world to yours

How Will Tech Revolutionise Health Care Over The Next Half Century?

From our world to yours

Empowering Public Transport With Big Data

From our world to yours

Putting Patients First Vs. Cost Concerns

From our world to yours

Life @ Kerv Digital As A Power Platform Solution Architect

From our world to yours

What’s The Best CRM For The Membership Sector?

From our world to yours

How Remote Patient Monitoring Data Can Drive Health Efficiencies

From our world to yours

Is A Career In NonProfit Digital Transformation Rewarding?

From our world to yours

Six Back-Office Functions NonProfits Should Be Using Robotic Process Automation For

From our world to yours

How Data Storage Management Will Change In 2022

From our world to yours

Business Central Vs Sage – Which Does Your Organisation Need?

From our world to yours

How To Debug Something With A Rubber Duck

From our world to yours

Using Design Thinking To Empower Digital Transformations

From our world to yours

How Business Central Can Keep You GDPR Compliant

From our world to yours

What Can Business Central Actually Do?

From our world to yours

Why Data Classification Is Vital To Your Organisation (And How To Easily...

From our world to yours

How To Inspect Items When Using The Execute Pipeline Activity In ADF/Synapse...

From our world to yours

How To Create UI Flow’s In Power Automate

From our world to yours

D365 BC Vs D365 FO: Let’s Settle This Once And For All!

From our world to yours

How To Drive Donor Engagement With Kerv Digital’s Free Powerups

From our world to yours

9 Awesome Benefits To The Microsoft Dataverse

From our world to yours

Canvas Apps Vs Model-Driven Apps

From our world to yours

How To Set Up Field Monitoring In Business Central

From our world to yours

Check Out The Benefits Of The Microsoft Catalyst IDEA Framework…

From our world to yours

Component Led Development, Or… How To Make Your Organisation Instantly More Resilient

From our world to yours

How To Achieve A Single Customer View In 5 Easy Steps

From our world to yours

Best Practice For Creating Cloud Flows With Microsoft Power Automate

From our world to yours

Legacy Estate Reduction… Or When To Get Rid Of Old Tech

From our world to yours

What Is Fintech?

From our world to yours

How To Get Better At: Online Continuous Personal Development (CPD)

From our world to yours

Virtual Exam Proctoring (Or How To Stop People Googling The Answers At...

From our world to yours

How Hyperautomation’s Benefiting PAO’s (Professional Accountancy Organisations)

From our world to yours

Cyber Security For Remote Working… How Everyone Can (And Has To) Pitch...

From our world to yours

What Is An Advanced Persistent Threat (APT’S) Attack?

From our world to yours

Visualising Your Data Differently With Power BI

From our world to yours

Database Marketing – What Is It & How Can You Benefit From...

From our world to yours

Microsoft Dynamics Cloud Licensing Options – What’s Available?

From our world to yours

Privacy By Design – What You Need To Know

From our world to yours

How To Connect To A Named Sandbox Environment

From our world to yours

What Are The Different Types Of Cloud Licensing Agreements?

From our world to yours

How To Export To Text Files From Microsoft’s Business Central SAAS

From our world to yours

Technical Debt – The What, Why, When & How Do I Get...

From our world to yours

Ensuring Business Continuity With The Microsoft Stack

From our world to yours

What’s The Best CRM For The NonProfit Sector?

From our world to yours

Rage Donations – How To Engage Past The ‘Now’

From our world to yours

What Is It & How To Avoid: Vendor Lock-In

From our world to yours

The Bad Guys Don’t Care You’re The Good Guys

From our world to yours

Build The Future Of The NonProfit Sector… Today

From our world to yours

Data Protection & Artificial Intelligence: Best Practice

From our world to yours

Shadow IT – 9 Things To Look Out For & 1 Unexpected...

From our world to yours

Organisational Debt & Why It Makes Digital Transformation Hard

From our world to yours

Discussing All Things RPA… Robotic Process Automation

From our world to yours

Now’s The Time To Get Excited About Cognitive Search

From our world to yours

If You Don’t Have An Automated Deployment Process… You’re Already Obsolete

From our world to yours

Tips & Tricks To Creating Successful Volunteer Management Systems

From our world to yours

The Five Types Of Cyber Criminals

From our world to yours

Security-By-Design: Or… Better Safe Than Sorry!

From our world to yours

Leading With Technology In The Membership Sector

From our world to yours

What Does IAAS, PAAS & SAAS Stand For?

From our world to yours

What Is Business Architecture?

From our world to yours

What Is Data Gravity? (And How Your Organisation Can Benefit From It)

From our world to yours

How To Fix DateTime Stamps In Microsoft Dynamics 365

From our world to yours

6 Easy Steps For Promoting A Culture Of Cyber Security

From our world to yours

15 Cyber Security ‘Things’ To Safeguard Your Business

From our world to yours

Microsoft Dynamics 365: Settings In solutions

From our world to yours

13 Ways To Save Money When Using Microsoft Azure

From our world to yours

The Problems With Addresses In Microsoft Dynamics 365

From our world to yours

Understanding The Benefits Of Predictive Science In The NonProfit Sector

From our world to yours

Top 6 Digital Impacts On Membership Organisations

From our world to yours

The 7 Stages Of A Successful AI Project

From our world to yours

What’s The Difference Between UI And UX?

From our world to yours

8 Ways Your Business Can Increase Turnover With Big Data

From our world to yours

Dynamics 365 In NonProfits

From our world to yours

Kerv acquires TDS Global Communications Compliance Practice

From our world to yours

What is Microsoft’s Power Automate?

From our world to yours

What is InvestTech?

From our world to yours

Derek Is Stressed – His Purchasing Team Aren’t Coping With Long Winded...

From our world to yours

Life @ Kerv Digital As A Jnr DevSecOps Engineer…

From our world to yours

Life @ Kerv Digital As A Principal Architect

From our world to yours

Life @ Kerv Digital As An Azure DevSecOps Engineer…

From our world to yours

Life @ Kerv Digital As Head Of Client Services, Public Sector

From our world to yours

Life @ Kerv Digital As A Junior DevSecOps Engineer

From our world to yours

Life @ Kerv Digital As A Graphic Designer

From our world to yours

Microsoft Inspire 2022 – Here’s All The Big Announcements!

From our world to yours

The Need for WhatsApp Compliance Recording

From our world to yours

Life @ Kerv Digital As A UX Researcher

From our world to yours

Life @Kerv Digital As A Senior Delivery Manager

From our world to yours

Life @ Kerv Digital As A Senior Delivery Manager

From our world to yours

Data Silos and Legacy Compliance Monitoring Systems – Barriers to Effective Surveillance...

From our world to yours

Kerv and Venari Security Partner to Widen the Lens of Enterprise Encryption

Have a question?

Leave your details and a member of the team will be in touch to help.
Type your first name here
Type your last name here
Type your phone number here
Type the company you represent here
By pressing send, you agree to our Terms and Conditions and Privacy Policy.
This field is for validation purposes and should be left unchanged.