1PART I
231CHAPTER 13
2POWER APPS FUNDAMENTALS
232DEVELOPING MODEL-DRIVEN APPS
3CHAPTER 1
233Introducing Model-Driven Apps
4INTRODUCING POWER APPS
234Making an application
5What are Power Apps?
235Uploading Web Resources
6The Background of Power Apps
236Setting up menus
7What Does PowerApps Do?
237Building dashboards
8What doesn’t it do?
238Building business process flows
9What are the key benefits of Power Apps?
239Customizing a Model-Driven App: Create a new model-driven app using a modern app designer
10What sources of data may we use?
240Create or edit a custom page
11Sample Apps
241Embedded Canvas Apps: Overview
12Canvas Apps
242Customizing Apps with JavaScript
13Model-Driven Apps
243Additional client-side field validation
14Model-Driven Apps vs. Canvas
244CHAPTER 14
15Portal Apps
245BUILDING PORTAL APPS
16How are Power Apps Applications operated by users?
246Creating a Portal
17How do we write code?
247Managing Portal trials
18CHAPTER 2
248Working with Designers: Adding pages
19SUBSCRIBING TO POWER APPS
249Designing Web pages
20How to Get Power Apps
250Adding text and images
21Which plan do I need to Access a Data Source?
251Adding sections
22Subscribing to Power Apps
252Managing a Portal App
23Obtaining a suitable email address
253Understanding page templates
24What are the licensing options
254Web templates
25Licensing portal and AI builder apps
255Securing a Portal: Setting up login accounts
26Accessing power apps via Microsoft/office 365: What is Office 365?
256Configuring authentication providers
27Microsoft 365: Business Plans vs. Consumer Plans: Features
257Controlling registrations
28Security and Compliance
258Camera
29Which Is the Best for You?
259Save Button
30Which Office 365/Microsoft subscriptions provide Power Apps?
260Setting up web roles
31Accessing Power Apps via Dynamics 365: What is Dynamics 365?
261Clearing the Cache
32How much does it cost?
262CHAPTER 15
33Logging on to Power Apps
263RETRIEVING DATA FROM PORTAL APPS
34Overview of Other Administrative Areas
264Working with Data: Creating Data entry pages
35CHAPTER 3
265Adding a new record
36CREATING YOUR FIRST APP
266Editing a record
37Creating an App
267Viewing a record
38On to the PowerApp Builder
268Listing data
39Creating an Auto-generated App
269Creating Web Forms: Defining Web form steps
40Creating Apps from SharePoint
270Branching form steps
41Exploring the Designer
271Configuring Form Fields
42Running your App
272Validating fields and forms
43Understanding the Auto-generated App
273Setting default form values
44Adding and Removing Data Sources
274Data Searching
45Adding, Deleting, and Rearranging Screens
275Customizing Content
46Understanding how Screens are connected
276Liquid language
47Understanding Forms and Cards
277Retrieving the current user
48Getting Started with PowerApps Forms: Creating and Viewing a New Form
278Customizing Pages with JavaScript
49Adding and Populating Your Data
279Uploading JavaScript files
50Editing and Managing Data Cards
280PART V
51Custom Data Card Creation
281ENHANCING APPS
52Layouts and Card Field Management
282CHAPTER 16
53Setting App Properties
283WORKING WITH IMAGES AND MEDIA
54Open and Save Applications
284Setting up a data source
55Opening Apps
285Setting an excel spreadsheet up
56CHAPTER 4
286Setting up an SQL server to store Images
57SHARING APPS
287Creating an image app
58Sharing Apps with end users
288Using the camera control: Switching between cameras
59Specifying owners and users
289Working with the Add Picture Control
60Creating users
290Converting Images to Text
61Setting up security groups
291Building a Photo Gallery
62Setting up external users
292Model-Driven Apps: Uploading and viewing Images
63Sharing App Data Sources
293Canvas App features: Using the pen control
64Running Apps
294Scanning barcodes
65Installing the mobile player
295Working with media controls: Play an audio or video file
66Understanding Environments
296CHAPTER 17
67Creating New Environments
297STORING AND RETRIEVING FILES
68Choosing an Environment Type
298Storing Files in SharePoint
69Setting Environment Permissions
299Storing Files in Azure Blob Storage: Setting up an Azure Blob Storage account
70Moving Apps between Environments and Tenants: Exporting an App
300Managing an Azure Blob Storage account
71Importing an App
301Connecting to an Azure Blob Storage account
72Updating a data source
302CHAPTER 18
73Versioning Apps
303INTEGRATING MAPS AND LOCATION SERVICES
74CHAPTER 5
304Introducing Location Services and GPS
75USING FORMULAS
305Longitude and Latitude
76Writing Formulas
306Retrieving Location Details
77Display a basic value
307Introducing Signals
78Adding Comments
308Freezing the Location Details
79Block Comments
309Getting Latitude and Longitude Readings
80Working with Variables
310Displaying Maps
81Setting Screen Variables
311Using Google Maps
82Setting global variables
312Using Azure Maps Services
83Working with Basic Data types: Working with numbers
313Interactive Maps
84Working with dates
314Address Suggestion
85Syntax
315CHAPTER 19
86Date
316CHARTING DATA
87Time
317Canvas App: Building a Column Chart
88Conditional statements and logical operations
318Bring in the sample data
89Calling the switch function
319Building a Pie Chart
90Color functions
320Displaying Charts
91Navigation functions: Syntax
321Displaying Dashboards
92PowerApps Back function: Syntax
322XML customization
93Exiting an App
323CHAPTER 20
94Managing Errors: Errors (Properties)
324ADDING ARTIFICIAL INTELLIGENCE TO APPS
95PART II
325Introducing Artificial Intelligence
96WORKING WITH DATA
326Prebuilt models vs. Custom models
97CHAPTER 6
327Licensing
98SETTING UP SHAREPOINT, SQL AND MORE
328Processing Images: Reading Business cards
99What is the best data source?
329Recognizing Texts
100Using a SharePoint data source
330Processing Forms
101Create a connection
331Processing Texts: Analyzing Sentiment
102Understanding the SharePoint special columns
332Categorizing Texts
103SharePoint conflict management
333Extracting Entities
104Building SharePoint forms
334PART VI
105Launching the form.
335REUSABILITY
106Change and eliminate a field
336CHAPTER 21
107Publish and save the form.
337BUILDING REUSABLE CANVAS COMPONENTS
108SQL Server
338What can we do with Canvas Components?
109SQL Server limitations
339Designing a Component
110Setting up SQR Azure
340Where to Define Components
111Managing a SQL database
341Creating a Component Library
112SQL database views
342Adding Controls to a Component
113Syntax
343Defining Properties
114On-premises data gateway
344Setting Property Values
115Installing the gateway
345Adding Components to Apps
116Starting the gateway service
346Updating a Component
117Uninstalling a gateway
347Editing a Component
118Other data sources
348Exporting and importing Component
119Static excel data
349Importing and Exporting Component Libraries
120Microsoft translator data source
350CHAPTER 22
121Microsoft MSN weather services
351BUILDING REUSABLE CODE COMPONENTS
122Sending push notifications
352What Can We Do?
123CHAPTER 7
353Microsoft Samples
124WORKING WITH TABLES, ROWS, AND COLLECTIONS
354Other Samples
125Overview of Collections and Functions
355Quick Guide: An Overview
126Working with Collections
356Prerequisites
127Retrieving server-generated values
357Installing NPM
128Adding multiple child rows
358Installing the .NET Framework Developer Pack
129Updating multiple rows
359Installing the Command Line Interface (CLI)
130Deleting multiple rows
360Installing Virtual Studio Code
131Processing data row by row
361Creating a Project
132Grouping, Counting, and Aggregating records: Creating sequences
362Creating a PCF Project
133Counting records
363Examining Our Project Layout
134Returning Min and Max records
364Adding Project Preferences
135Grouping and Aggregating values
365npm install
136Ungrouping records
366Developing a Control
137Ungroup (GroupedProperties, "PropertyTypeID”)
367Defining a Control Manifest
138Row Combination (Union Results)
368Writing the Code
139Splitting texts into rows
369Style the Component with CSS
140Splitting CSV strings
370Building a Control
141Split ("House, Apartment, Bungalow", "," )
371Testing a Control
142Trim (Split (“House, Apartment, Bungalow", ",”))
372Deploying a Control
143Building Comma-Separated Strings
373Creating a Solution
144Getting Hashtags
374Building a Solution Project
145CHAPTER 8
375Installing a Control
146SEARCHING AND RETRIEVING DATA
376Using the Control
147Understanding Delegation
377The Canvas App
148Increasing the Data Row limit
378Model-Driven App
149Searching Data
379PART VII
150Basic Search Functions
380OFFLINE AND INTEGRATION
151Sorting Data by Multiple Columns
381CHAPTER 23
152Joining Data
382WORKING OFFLINE
153Joining Records: Displaying Related Records
383What Happens Offline?
154Search procedures that can cause difficulties: Matching against a list of data
384Canvas Formulas that Enable Working Offline
155Matching Blank Fields
385Saving and Retrieving Local Data
156Returning Distinct Records
386Making a Canvas App Available Offline
157Resolving delegation issues
387Setting the Data Source to a Local Collection
158SQL Server views
388Handling Office Deletions
159SharePoint Columns
389Handing Offline Record Updates
160PART III
390Building the Synchronization Screen
161DEVELOPING CANVAS APPS
391Building the Conflict Resolution Screen
162CHAPTER 9
392Making Model-Driven Apps Available Offline
163CANVAS APP DESIGN
393Setting up a Mobile Profile
164Using Screen Predefined layouts
394Running a Model-Driven App Offline
165Scrollable Screen template
395CHAPTER 24
166Tutorial Screen template
396CREATING CUSTOM DATA CONNECTORS
167Office 365 Screen templates
397Overview of Web Services and Custom Connectors
168Icons and Shapes
398Understanding How the Web Works
169Using Themes
399Making HTTP Web Requests
170Building a List and Details Screen
400Documenting a Web Service
171Updating the Detail Section of a Screen
401Creating a Web Service Description
172Displaying a Delete Confirmation Screen: Remove (User, gallery1.Selected);
402Using Swagger
173Organizing Controls: Grouping Controls
403Examining an Open API Document
174Phone vs Tablet Apps
404CHAPTER 25
175Supporting Multiple Device
405USING POWER AUTOMATE
176Designing a responsive app
406What Is Power Automate?
177Formulas that we use
407What Can We Do with Power Automate?
178Building a responsive app
408Managing and creating Flows
179Using the Timer control
409Define Triggers
180CHAPTER 10
410Calling Flows: From Canvas Apps
181USING SIMPLE CONTROLS
411Working with Data
182Building data structures to support control
412Connecting to Data
183Displaying data
413Filtering Data
184The Label Control
414Working with Variables
185The HTML text control
415Manipulating Data: Constructing HTML Tables
186Using Simple Data Entry Controls: Text input control
416Introducing Workflow Definition Language
187Rich text control
417Approving Actions: Managing Files
188Radio control
418Calling SQL Stored Procedures
189Toggle and Checkbox control
419Stored Procedure
190Slider control
420Power Automate
191Rating control
421Power Apps
192Working with Dates: Date Picker Control
422Element - Text Input
193Understanding Time Zones
423PART VIII
194Saving Dates in a Year-Month-Day Format
424ADMINISTRATION
195CHAPTER 11
425CHAPTER 26
196USING TABLE/RECORD DATA CONTROLS
426TRANSFERRING APPS AND DATA
197Data Entry Controls
427Managing Data: Transferring Dataverse Data with Dataflows
198Drop-Down Control
428Managing Dataverse Data with Excel
199Customizing the Drop-Down display value
429Importing Data to SharePoint
200Selecting multiple items with a combo box
430Working with SharePoint Data
201Data Display Controls
431Transferring Data from Canvas Apps: Export Data
202List Box Control
432Importing Data
203Working with Gallery Control
433Transporting Apps with Solutions
204Choosing a Gallery type
434Using the Default Solution
205Applying layouts
435Work with Solution
206Setting Properties
436Creating a Solution
207Working with forms: Laying out a form
437Adding Objects to a Solution
208Defining form columns
438Exporting a Solution
209Combining forms and patch
439Export using the classic experience
210Resetting form control
440Importing a Solution
211Validating form values
441Understanding Solution Layers
212Retrieving form validation rules
442CHAPTER 27
213PART IV
443ADMINISTERING SECURITY
214DEVELOPING MODEL-DRIVEN AND PORTAL APPS
444Configuration Authentication Settings
215CHAPTER 12
445Securing SharePoint Lists
216BUILDING A DATAVERSE DATABASE
446Implementing Role-Level Access
217Why use Dataverse?
447Limiting Users' Capabilities to View SharePoint Lists
218The Common Data Model
448Limiting Users' Ability to Access Records
219Creating a Dataverse Database
449Canvas App Formulas
220Listing Tables
450Creating Data Loss Prevention Policies
221Editing Tables
451Using PowerShell
222Creating a custom table
452Installing Components
223Table setups
453Other Useful Commands
224Adding a new column
454Hiding SharePoint Lists
225Storing currencies
455Auditing and Analytics: Auditing App Activity
226Defining Relationship
456Auditing Dataverse Record Activity
227Setting up a many-to-many relationship
457Viewing Analytic Data
228Defining Keys: Choices
458Top 40 Microsoft PowerApps Questions and Answers
229Defining Calculated and roll-up columns: Creating calculated columns
459CONCLUSION
230Aggregating figures with roll-up columns
460INDEX