Building Your First Canvas Power App Event (Hands-On Tutorial)

Power Apps Free Course for Life - https://www.pragmaticworkstraining.com/on-demand-learning-aiad

Get ready to learn how to build your first canvas Power App with low-code knowledge, the common functions that all developers must know in Power Apps and how to share the application after construction.

0:00 - Intro
3:30 - Features of Power Apps
16:40 - Types of Power Apps
28:00 - Power Apps Cheatsheet
30:25 - Community Plan
32:00 - Environments
35:11 - Licensing Power Apps
37:45 - Where to store your data
42:10 - Creating the connection to SQL Server
47:25 - Creating a Power App from Data wizard
49:50 - Saving, version control, and publishing the app
1:03:55 - Creating an app from scratch
1:06:14 - Creating the connections
1:08:10 - Creating global variables for theming
1:15:34 - Creating the app title
1:17:24 - Creating the first gallery
1:22:12 - Creating the second gallery
1:46:19 - Using Filter on the second gallery
1:53:40 - Using Search on the first gallery
1:59:06 - Creating the second screen and form
2:17:07 - Coding the Submit button to insert data
2:28:34 - Editing data in Power Apps
2:36:50 - Deleting data
2:39:26 - Final touches
2:49:45 - Q&A

To begin this example, you'll need a connection to my database in the cloud. Go to https://make.powerapps.com​. Go to Data, Connections and Create a new SQL Server Connection. Here's the info you'll need for the connection:

Type: SQL Server
Authentication Type: SQL Server Authentication
Server: pragmaticworks.database.windows.net
Database: Demo
UserName: DemoUser
Password: DemoPW123 (yes, it's case sensitive)
Gateway: None selected

Other code we use today:
Variable Creation for theming:
Set(varBackgroundGreen, RGBA(232, 244, 220, 1));
Set(varHeaderGreen, RGBA(53, 91,14, 1));
Set(varCoreGreen, RGBA(78,132,22,1))

Assessment Gallery:
Sort(
Filter(
'[dbo].[NursingWellCheck]',
PatientID = Gallery1.Selected.PatientID
),WellCheckDate, Descending)
Event Overview:
Power Apps is quickly becoming a go-to low-code platform for building applications for small companies and enterprises around the world. In this interactive session, you'll learn how to design and build an application from the ground up. You'll also learn the common functions that all developers must know in Power Apps and how to share the application after construction.

What You'll Learn:
• How Power Apps is licensed
• Where is the best place to store your data
• Best practices when creating your screens
• User interface tips
• Using variables
• The 7 key must-know functions in Power Apps
• Deploying and sharing your app

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

On-Demand Learning Courses FREE Trial: https://www.pragmaticworkstraining.com/on-demand-learning-free-trial/

Pragmatic Works Blog: http://blog.pragmaticworks.com/

Let's connect:
Twitter: https://twitter.com/PragmaticWorks
Facebook: https://www.facebook.com/pragmaticworks/
Instagram: https://www.instagram.com/pragmatic.works/
LinkedIn: https://www.linkedin.com/company/pragmatic-works
YouTube: https://www.youtube.com/pragmaticworks

Pragmatic Works
Phone: (904) 413-1911
Email: training@pragmaticworks.com

Видео Building Your First Canvas Power App Event (Hands-On Tutorial) канала Pragmatic Works