PowerApps connects to tables stored in a cloud service. This video demonstrates formatting a data range in Excel as a table, saving the Excel workbook, and uploading the workbook to OneDrive for Business. When these tasks are completed the workbook is ready for use as a data source for PowerApps.
- [Instructor] We'll create our final app from scratch.…Before we begin here's a little orientation…to the service call report.…This is an empty version of a spreadsheet used at KinetEco.…The spreadsheet is used to track issues,…problems that have come up that are discovered…because a customer reports them…or because someone from the quality assurance staff…has discovered an issue with an installation…or perhaps one service call generates another call.…These are our headings, Install Type, Reported by,…Date Reported, and so on.…
These first four columns are typically filled out…by the person who spots the problem,…the Install Type, Reported by, Date Reported, and Problem.…The first column is a drop-down,…Geothermal, Hybrid, Solar, Wind.…That drop-down list is found here…is in fact a named range called Install Type.…So that can be modified at any time.…After the problem has been reported…it is then assigned to someone…and that service technician…then types a report of their resolution…and records the date on which the problem was resolved.…
Author
Gini von Courter
Released
11/14/2018- Recognize which devices a mobile-first app is designed for.
- Explain how to download an app template.
- Recall which screen in PowerApps displays one card after another.
- Identify layouts available in PowerApps.
- Determine how to enter text as a constant.
- List two terms to describe the first screen that’s loaded when the app is launched.
- Identify the URL used to run PowerApps in a browser.
- Explain how to launch an app from Dynamics 365.
Skill Level Beginner
Duration
Views
-
Introduction
-
1. Get Started
-
What is PowerApps?1m 58s
-
Explore the interface4m 42s
-
-
2. Work with PowerApp Templates
-
Run the application6m 21s
-
PowerApps data sources2m 57s
-
Use PowerApps Studio5m 13s
-
Publish an app2m 37s
-
3. Create a PowerApp from Scratch
-
Save the app1m 16s
-
Select layouts2m 26s
-
Add a screen to the app6m 46s
-
4. Use and Share Apps
-
Open an app in a browser1m 56s
-
Share an app4m 49s
-
Open an app from Dynamics1m 50s
-
-
Conclusion
-
Next steps1m 34s
-
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.
Share this video
Embed this video
Video: Prepare and upload the Excel data source