Description
In this course, you will :
- Explore how to use Power Apps and Excel to build robust business applications for data collection and visual display.
- walks you through the basics of connecting one or more data sources in Power Apps, as well as how to build and deploy a new application to your organisation.
- Learn how to personalise the design, add images and buttons, validate user data, and auto-populate form fields.
- Learn how to use Power Apps templates to save time and export app packages for distribution outside of your organization's Office 365 ecosystem.
Syllabus :
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