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.…
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.
Share this video
Embed this video
Video: Prepare and upload the Excel data source