Power Apps: Building Data-Driven Apps

Learn how to connect Excel and Power Apps to create data-driven business applications.

Introduction

• Create data-driven apps with Power Apps and Excel
• Link O365 tools in new ways

1. Get Started

• Excel setup: Named tables
• Store files in an accessible location
• Connect Power Apps to data
• Your first app: Default from existing data
• Browse screen, edit screen, detail screen
• Save and other app settings
• Refresh the data source

2. Change Design and Styling

• Resize the app for the default viewer
• Correct design layout issues
• Fix data field auto layout on the Browse screen
• Correct data field auto layout of the Edit and Display screens
• Change form colors in Power Apps
• Change and resize fonts in Power Apps
• Add images in Power Apps

3. Add Functionality

• Add dropdown fields
• Add radio buttons
• Conditional formatting
• Validate entries
• Auto-populate information in fields

4. Create More Complex Solutions

• Link multiple data sources
• Using Galleries
• Add a chart
• Add image fields for input
• Create apps and collections from scratch
• Using Power Apps templates

5. Sharing Your App

• Share via a shared cloud service
• Using the app on a mobile device
• Export and import app packages

Conclusion

• Extend your Power App and Excel skills