Download Beginning PowerApps: The Non-Developers Guide to Building Business Mobile Applications PDF

TitleBeginning PowerApps: The Non-Developers Guide to Building Business Mobile Applications
File Size18.8 MB
Total Pages383
Table of Contents
About the Author
About the Technical Reviewer
Part I: Getting Started
	Chapter 1: Introducing PowerApps
		What Is PowerApps?
		Who Is the Typical Developer?
		What Are the Typical Uses?
			Asset Checkout App
			Budget Tracker
			Service Desk App
			Site Inspection App
			Other Sample Apps
		How Do You Build a PowerApp?
		How Do Users Run PowerApp Applications?
		What Data Can a PowerApps Consume?
			Connecting to On-Premises Data
			Common Data Service
			Connecting to Other Data Sources
		How Do You Write Code?
		How Much Does It Cost?
	Chapter 2: Subscribing to PowerApps
		How to Get PowerApps
		Obtaining PowerApps via Office 365
			What Is Office 365?
			Consumer vs. Business Office 365
			Understanding Work Accounts and Personal Accounts
			What Office 365 Editions Support PowerApps?
		Subscribing to a PowerApps Stand-Alone Plan
			Registering for an Account
			Obtaining a Suitable Email Address
		Logging onto PowerApps
		Configuring Environments
		Installing PowerApps Studio
	Chapter 3: Creating Your First App
		Preparing an Excel Data Source
		Creating an App
		Creating an Auto-Generated App
			Creating Apps from SharePoint
		Exploring the Designer
		Running Your App
			Examining the Screens at Runtime
		Understanding the Auto-Generated App
			Adding and Removing Data Sources
			Adding, Deleting, and Rearranging Screens
			Understanding How Screens Are Connected
				How the Browse Screen Works
				How the Detail Screen Works
				Searching for Controls
				How the Edit Screen Works
			Understanding Forms and Cards
				Reading Data into a Form
				Saving Form Data to a Data Source
				Choosing Not to Use Forms and Cards
				Recap of Concepts
		Setting Project Properties
		Saving Your Project
		Opening a Project
	Chapter 4: Sharing Apps
		Sharing Your App
			Adding a User
			Applying Permissions
		Managing Environments
			Moving an App to a New Environment
			Updating a Data Source
			How Data Connections Work
		Versioning an App
		Installing the Mobile Player
		Running with Foreign Languages
Part II: Refining Your Application
	Chapter 5: Exploring Data Sources
		Using the Common Data Service
			Getting Started
			Exploring the Common Data Model
			Exploring a Standard Entity
				Creating a Custom Entity
				Adding a New Field
			Creating a Relationship
				Deletion Behavior
			Using Field Groups
				Creating a Picklist
				Adding Picklist Items
				Applying Picklists to Fields
				Deleting a Picklist
			Deleting CDS Data
		On-Premises Data Gateway
			Installing the Gateway
			Starting the Gateway Service
			Connecting to a Data Source
				Connecting to SQL Server
			Uninstalling a Gateway
		Using a SharePoint Data Source
			Creating a SharePoint List
				Choice Items
			Connecting to a SharePoint Data Source
		Other Data Sources
			Microsoft Translation Data Source
			Microsoft MSN Weather Services
	Chapter 6: Using Formulas
		Writing Formulas
			Using the Function Tool
				ThisItem/Parent Syntax
		Working with Variables
			Setting Screen Variables
				Passing Values to Screens
				Example of Context Variables
			Setting Property Values from Code
			Setting Global Variables
		Manipulating Data
			Working with Text
				Text Manipulation Functions
				Text Extraction Functions
				Modifying the Casing of Sentences
				Searching Within Strings
				Matching with Regular Expressions
				Replacing Text
			Working with Numbers
				Formatting Numbers
				Rounding Functions
				Trigonometric Functions
				Other Mathematical Functions
			Working with Dates
				Formatting Dates Times
				Performing Date Arithmetic
				Calendar Functions
		Working with Tables of Data
			Defining Hard-Coded Sets of Values
			Understanding Collections
				Collecting Data
			Defining Tables
			Working with Columns
				Adding Columns
				Dropping Columns
				Renaming Columns
				Showing Columns
			Table Functions
				Performing Actions Row by Row
				Concatenating Data
			Counting Records
			Performing Aggregate Calculations
		Conditional Statements and Logical Operations
		Specifying Colors
		Navigation Functions
			Launching Websites and Apps
			Retrieving Startup Parameters
			Exiting an App
		Managing Errors
	Chapter 7: Customizing Screens
		Using Predefined Layouts
			Laying Out Tablet Apps
		Understanding Sample Screen Designs
			Building a List and Details Screen
			Updating the Details Section of a Screen
			Displaying a Delete Confirmation Screen
			Building a Tab Control Screen
		Using Themes
	Chapter 8: Using Controls
		Overview of Controls
		Building Data Structures to Support Controls
		Action Controls
			Displaying Geometric Shapes
		Displaying Text with Label and HTML Text Controls
		Using Simple Controls
			Text Input Control
			Radio Control
			Toggle and Checkbox Controls
			Slider Control
			Rating Control
		Working with Dates
			Date Picker Control
				Showing Dates Only
				Understanding How Date Values Are Stored
				Saving Dates in year-month-day Format
		Setting Lookup Values
			Limiting Input Values with a Drop-Down Control
			Setting Lookup Values with a Drop-Down Control
			Customizing the Drop-Down Display Value
			Nesting Drop-Down Controls
			List Box Control
		Displaying Tables of Data
		Using CDS-Specific Controls
			Using Entity Form Controls
			Drop-Down Controls with CDS
		Working with Media Controls
			Playing Videos
			Playing Audio
			Image Controls
		Using the Timer Control
		Resetting Form Controls
	Chapter 9: Working with Data
		Basic Behavior
			Understanding Delegation
		Searching Data
			Basic Search Functions
				Filtering by Drop-Down Values
				Searching by Date Criteria
				Searching by Numeric Criteria
				Adding a Search Button
			Setting Multiple Sort Sequences
			Additional Search Criteria Options
				Matching Against Lists of Data
				Matching Blank Fields
		Joining Data
			Joining Records - Showing Related Records
			Checking for Nonexistence
			Returning Distinct Records
		Working with Data in Code
			Retrieving Single Records
			Updating Records
				Updating a Single Record
				Updating Multiple Records
			Creating a New Record
				Retrieving Auto-Generated Numbers
				Patching Associated Records in SharePoint
			Deleting Data
		Setting Default Screen Values
		Validating Form Values
			Checking Validation Rules
		Sending Notifications
	Chapter 10: Working with Images
		Choosing Where to Store Images
		Setting Up a Data Source
			Storing Images in Excel
			Storing Images in CDS and SQL Server Databases
		Creating an Image App
			Viewing Records in the CDS
			Using the Add Picture Control
		Using the Camera Control
			Retrieving the Camera Data
			Switching Between Cameras
			Setting Brightness, Contrast, and Zoom Levels
		Creating a Gallery
		Using the Pen Control
			Erasing Text
			Converting Annotations to Text
		Scanning Barcodes
	Chapter 11: Mapping Data
		Introduction to GPS
		Retrieving Location Details
			Introducing Signals
			Freezing the Location Details
			Obtaining Longitude and Latitude.Readings
			Saving Location Details
			Switching the Signal On/Off
			Other Signals
		Displaying Maps
			Using Google Maps
			Bing Maps
	Chapter 12: Using Charts
		Aggregating Data
		Column Chart
			Creating a Chart
			Setting Legends
			Setting Label Orientation
			Applying Colors and Styles
		Pie Chart
		Line Charts
			Grouping Data by Month
			Showing Chart Data Dynamically
			Showing Multiple Series
	Chapter 13: Securing Apps
		Role-Based Security
			Securing the CDS
				Granting Read and Write Access to Entities
			Securing SharePoint Lists
				On-Premises SharePoint
			Verifying Permissions Within an App
				Disabling Icons and Buttons
		Configuring Record-Level Access
			Setting Up the Data Source
			Getting the Logged On User
			Filtering Records by the Logged On User
		Creating Data Loss Prevention Policies
			Testing a DLP Policy
Part III: Maintaining Your Application
	Chapter 14: Importing and Exporting Data
		Using the Import and Export Controls
			Exporting Data
			Importing Data
				Importing New Records
				Inserting and Updating Data
				Understanding Import Errors
			Importing and Exporting Related Data
				Importing the Data
		Importing and Exporting CDS Data
			Importing Data
				Resolving Error Conditions
			Exporting Data
		Using the Excel Add-In
		Importing Static Data
	Chapter 15: Using Flow
		What Is Flow
		What Can We Do with Flow?
		Creating a Flow
			Copying Files
			Calling Flows from Apps
		Sending Notifications
			Filtering Data
			Working with Variables
			Sending the Email
		Manipulating Data
			Constructing HTML Tables
			Introducing Workflow Definition Language
			Applying Workflow Definition Language
			Using Output Values in Workflow Definition Commands
			Referring to Items in Loops
		Calling SQL Stored Procedures
		Approving Actions
		Managing Flows
Part IV: Extending Your Application
	Chapter 16: Working Offline
		What Happens Offline?
		Techniques to Enable Offline Working
			Saving and Retrieving Local Data
		Making an App Available Offline
			Setting the Data Source to a Local Collection
			Handling Offline Deletions
				Deleting Records from Local Collections
			Handling Offline Record Updates
				Merging Records
			Building the Synchronization Screen
				Disabling Icons and Buttons
			Building the Conflict Resolution Screen
	Chapter 17: Creating Custom Data Connectors
		What Can We Accomplish with Web Services?
		Overview of Steps
		Understanding How the Web Works
			Making HTTP Web Requests
			Understanding HTTP Responses
		Documenting a Web Service
			Creating a Web Service Description
			Using Postman
			Using Swagger
			Examining an Open API Document
		Creating a Custom Connector
		Using the Custom Connector
	Appendix A: Data Models
		Overview of CDS Entities
			Foundation Entities
			Person Entities
			Group Entities
			Sales Entities
			Purchase Entities
			Customer Service Entities
			Human Resources Entities
		CDS Field Names
			Foundation Entities
			Person Entities
			Group Entities
			Sales Entities
			Customer Service Entities
			Organization Entities
			Purchase Entities
			Human Resources Entities
			Retail Entities
		Data Structure of the Sample ‘Journey’ Application

Similer Documents