Learn how to connect Excel and Power Apps to create data-driven business applications.
Overview
Syllabus
Introduction
- Create data-driven apps with Power Apps and Excel
- Link O365 tools in new ways
- 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
- 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
- Add dropdown fields
- Add radio buttons
- Conditional formatting
- Validate entries
- Auto-populate information in fields
- Link multiple data sources
- Using Galleries
- Add a chart
- Add image fields for input
- Create apps and collections from scratch
- Using Power Apps templates
- Share via a shared cloud service
- Using the app on a mobile device
- Export and import app packages
- Extend your Power App and Excel skills
Taught by
Phil Gold