Learn Microsoft PowerApps
Matthew Weston更新时间:2021-06-24 12:09:24
最新章节:Leave a review - let other readers know what you thinkcoverpage
Title Page
Copyright and Credits
Learn Microsoft PowerApps
Dedication
About Packt
Why subscribe?
Contributors
About the author
About the reviewers
Packt is searching for authors like you
Preface
Updates to PowerApps
Who this book is for
What this book covers
To get the most out of this book
Download the example code files
Download the color images
Code in Action
Conventions used
Get in touch
Reviews
Section 1: Getting Started with PowerApps
Introducing PowerApps
Technical requirements
Understanding PowerApps
Understanding PowerApps licensing
Seeded apps
Per-user plans
Per-app plan
Community Plan
Understanding the types of apps
Canvas apps
Model-driven apps
The start screen
The Home screen
The Learning Resources screen
The Apps screen
The Create screen
The Data menu
Entities
Option sets
Connections
Custom connectors
Gateways
Business logic
What are templates?
Leave request app
Help desk app
Using PowerApps Studio
PowerApps Studio menus
Home
Insert
View
Action
PowerApps formula bar
Screens browser
App
Screen list
The PowerApps canvas
Breadcrumb
Zoom
Looking at the properties area
Properties
Advanced
Summary
Questions
Further reading
Creating Your First Canvas PowerApp
Technical requirements
Creating a mobile app
Creating a tablet app
Changing the app settings
Accessing the App name + icon setting
Changing the name
Setting the icon
Accessing the Screen size + orientation setting
Using the phone app
Using the tablet app
Accessing the Advanced settings
Data row limit for non-delegable queries
Preview features
Experimental features
Lab 1
Activity 1: Creating a blank tablet app
Creating the identity of the app
Saving the app
Activity 2: Creating a blank phone app
Creating the identity of the app
Saving the app
Summary
Questions
Creating Apps from SharePoint
Technical requirements
Preparing your list within SharePoint
Creating your app
Exploring the auto-generated PowerApp
Browse screen
Detail screen
Edit screen
Customizing forms
Modifying forms
Advanced options
Publishing the app
Lab 2
Summary
Questions
Publishing and Leveraging PowerApps
Technical requirements
Publishing a PowerApp
Version history
Accessing your app through SharePoint Online
Getting the PowerApp ID
Adding the PowerApp to SharePoint
Microsoft Teams
Adding a PowerApps tab
Using the mobile app
Using the app
Pinning to home
Lab 3
Activity 1: Installing the mobile app
Activity 2: Pinning the app
Summary
Questions
Section 2: Developing Your PowerApp
Exploring Controls
Technical requirements
Control properties
Text controls
LABEL
TEXT INPUT
HTML text
RICH TEXT EDITOR
PEN INPUT
Controls
BUTTON
DATE PICKER
Presenting multiple choices
DROP DOWN
COMBO BOX
LIST BOX
RADIO
Boolean controls
CHECK BOX
TOGGLE
Numerical inputs
SLIDER
RATING
TIMER
IMPORT and EXPORT
Gallery controls
Icon controls
Lab 4
Activity 1: Building basic branding
Activity 2: Adding the name of the app
Activity 3: Inserting an enter button
Summary
Questions
Exploring Formulas
Technical requirements
The function browser
Using the formula bar
Interacting with text
Replace and substitute
Searching and matching
Regular expressions
Using numbers
Rounding
Round
RoundUp and RoundDown
Other numerical functions
Working with dates
Formatting dates
Calculating dates
Using conditions
If
Switch
Variables
Global variables
Context variables
Reviewing variables
Lab 5
Activity 1: Navigating to our new screen
Activity 2: Using math to position a control
Activity 3: Using conditions to change control behavior
Summary
Questions
Further reading
Working with Data
Technical requirements
Creating and interacting with collections
Filling collections
Updating collections
Displaying data as tables
Displaying data in a gallery
Displaying data in a data table
Using forms
Lab 6
Activity 1: Creating the collections
Activity 2: Applying branding
Activity 3: Adding navigation
Summary
Questions
Introducing Connectors
Technical requirements
Understanding standard connectors
Interacting with tables of data
Interacting with actions
Understanding premium connectors
Introducing custom connectors
Creating a custom connector from scratch
The General tab
The Security tab
The Definition tab
The Test tab
Importing an OpenAPI file
Creating a connector from within Postman
Lab 7
Activity 1: Preparing the data source
Activity 2: Adding the data source to the app
Activity 3: Adding a list of assets
Summary
Questions
Further reading
Section 3: Extending the Capabilities of Your PowerApp
Using GPS in PowerApps
Technical requirements
Placing maps into your apps
Leveraging Bing maps
Leveraging Google Maps
Capturing geographic position
Finding the location
Finding direction
Lab 8
Activity 1: Updating the data source
Activity 2: Creating a new asset
Activity 3: Displaying a map
Activity 4: Adding navigation
Summary
Questions
Further reading
Working with Images and Barcodes
Technical requirements
Understanding how to store images within PowerApps
Using images with the camera control
Capturing the camera image
Capturing from an icon
Using the Add picture control
Understanding the barcode scanner
Lab 9
Activity 1: Updating the data source
Activity 2: Updating the PowerApp to capture a photo
Activity 3: Updating the app to scan and store barcode data
Summary
Questions
Securing Your PowerApps
Technical requirements
Securing your PowerApp
Securing your data
Applying in-app security
Storing access lists within the app
Implementing security with AAD security groups
Lab 10
Activity 1: Creating the collection
Activity 2: Creating the Administrators view screen
Activity 3: Creating the link
Summary
Questions
Working Offline
Technical requirements
Detecting a connection state
Working with local data
Saving data locally
Loading data from the local cache
Implementing offline capability
Implementing the on-start process
Working offline
Synchronizing online and offline data
Lab 11
Activity 1: Adding a connection indicator
Activity 2: Adding data to an offline cache
Activity 3: Tracking new additions while offline
Activity 4: Synchronizing changes
Summary
Questions
Using Power Automate with PowerApps
Technical requirements
Understanding Flows
Creating Flows through the Azure portal
Creating a Flow from templates
Creating Flows from scratch
Requesting data from PowerApps
Testing your Flow
Calling a Flow within PowerApps
Creating a Flow from within PowerApps
Returning data from Flow
Using Power Automate to process data
Lab 12
Activity 1: Updating the data source
Activity 2: Creating a Flow
Activity 3: Wiring up PowerApps
Summary
Questions
Further reading
Using Azure with PowerApps
Technical requirements
Utilizing Azure resources
Integrating with Azure Active Directory
Implementing Azure Automation
Creating an Azure Automation account
Preparing your automation account for use
Installing modules
Storing credentials
Storing variables
Using runbooks
Using Azure Automation in PowerApps
Calling CreateJob
Getting the job's output
Using Azure Functions
Using a queue
Creating an Azure Function
Lab 13
Activity 1: Creating the security group
Activity 2: Displaying the group users
Activity 3: Adding add and remove functionality
Summary
Questions
Further reading
Section 4: Working with Model-Driven Apps
Introducing Model-Driven Apps
Technical requirements
Understanding the CDS
Creating the CDS database
Understanding the CDM
Introducing entities
Exploring an entity
Modeling data
Creating an entity
Creating Fields
Creating entity relationships
Building a model-driven app
Lab 14
Activity 1: Creating the database
Activity 2: Modeling data
Summary
Questions
Further reading
Creating Model-Driven Apps
Technical requirements
Introducing Views Forms and Dashboards
Creating Views
Creating Forms
Creating Dashboards and Charts
Creating charts
Creating Dashboards
Creating a model-driven app from scratch
Using your model-driven app
Lab 15
Activity 1: Creating Views
Activity 2: Building the model-driven app
Summary
Questions
Section 5: Governing PowerApps
Exploring Environments within Our Tenancy
Technical requirements
Introducing environments
Viewing your environments
Creating environments
Setting security on the environment
Working with security with no database
Working with security within a database
Introducing data loss prevention
Creating data loss prevention policies
Lab 16
Activity 1: Creating an environment
Activity 2: Setting a DLP policy
Summary
Questions
Assessments
Chapter 1
Chapter 2
Chapter 3
Chapter 4
Chapter 5
Chapter 6
Chapter 7
Chapter 8
Chapter 9
Chapter 10
Chapter 11
Chapter 12
Chapter 13
Chapter 14
Chapter 15
Chapter 16
Chapter 17
Other Books You May Enjoy
Leave a review - let other readers know what you think
更新时间:2021-06-24 12:09:24