UNiSOFT Education Center

Certificate in
Power Apps Development
(Canvas Apps)

No Code and Low Code Development 編程不再高門檻，人人都能輕鬆上手

課程簡介

Power Apps 是 Microsoft 旗下的低代碼/無代碼應用開發平台，讓所有人都能輕鬆創建客製化的業務應用程式，快速解決複雜的業務挑戰並提升效率。透過直觀的拖放設計介面，Power Apps 能快速連接各類內外部數據源，包括 SharePoint、Excel 等，並結合 Power Automate 實現流程自動化，打造跨平台運行的應用程式。其強大的功能廣泛應用於費用報銷、庫存管理、員工入職等場景，降低開發門檻，讓非技術人員也能參與應用開發，助力企業快速推動數位轉型與業務創新。

課程目標

Canvas Apps

探索 Power Apps 界面，並了解 Canvas Apps 的用途與目標。

Data Sources

連接多種數據源（如 SharePoint 和 Excel）

User Interfaces

使用控件和組件設計應用程式介面，並實現驗證功能

Work with Gallery and Form

表單 (Form) 用於創建、編輯和查看數據；數據集合（Gallery）用於動態顯示和篩選數據。

Power FX

學習 Power FX 函數（如 If、Switch、LookUp、Filter）實現條件邏輯與數據處理

Advanced Power FX Features

使用 Patch 和 Filter 函數更新數據和創建基於條件的數據篩選功能。

Integrate with Power Automate

將 Power Automate 流程集成到應用中，實現任務和流程的自動化。

Publish and Secure Your App

發布應用程式，設置安全角色與權限，並通過共享的方式促進協作

課程相關資料

課程對象針對企業客戶而設
上課模式面授上課或者即時網上教學
上課安排客戶可到本校上課或要求導師上門授課
上課收費每班最多20人，每班收費$12,800
課程時數6小時
使用軟件Windows 365
入學要求需懂 Excel 基本功能，方能事半功倍

課程內容

Overview of Power Apps and its capabilities.
Understanding the Power Apps ecosystem (Canvas Apps).
Use cases and benefits of using Power Apps.

Navigating the Power Apps interface.
Creating a Power Apps account.
Overview of the Canvas App type and its purpose.

Understanding Canvas Apps and their flexibility.
Step-by-step guide to creating a simple Canvas App.
Practical Example: Create a basic app to collect feedback from users.

Understanding different types of variables (global, context, and collections).
Using collections to store and manipulate data within the app.
Practical Example: Create a collection to manage temporary data.

Overview of Gallery and its role in displaying data dynamically.
Using Forms for creating, editing, and viewing data.
Practical Example: Combine Gallery and Forms to create a data management interface.

Connecting to various data sources (e.g., SharePoint, Excel, SQL Server).
Understanding Common Data Service (Dataverse).
Practical Example: Connect your Canvas App to a SharePoint List.

Using controls and components to design the app.
Best practices for user experience and accessibility.
Practical Example: Design a user-friendly form with validation.

Introduction to Power FX and its syntax.
Common functions and expressions in Power FX (e.g., If, Switch, LookUp, Filter).
Practical Example: Use Power FX to implement conditional logic and data filtering in your app.

Working with collections and context variables.
Using functions for data manipulation (e.g., ForAll, ClearCollect).
Practical Example: Create a dynamic data table using collections and implement search functionality.

Integrating Power Automate flows into Power Apps.
Automating tasks and processes triggered by app actions.
Practical Example: Create a flow that sends email notifications when a form is submitted in Power Apps.

Understanding security roles and sharing apps.
Best practices for securing your apps and data.
Practical Example: Set up user permissions for different roles in an app.

Steps to publish your app for users.
Sharing options and collaboration features.
Practical Example: Share your app with colleagues and gather feedback.

Instructor

Dannis Mok

who has rich experience in business web and apps system development and have over 20 years of teaching experience. He has great passion in learning and teaching new technologies and his teaching style is clear to point and can explain complex technologies in simple terms. He has delivered various workshops and classes for different corporate, government departments and local universities and is the principal lecturer for NCC Education and University of Greenwich. Besides BSc degree in IT, he also got a MBA, MSc in IT and MSc in Telecommunication degree.

企業客戶

Dannis Mok

導師曾教授以下客戶 - 辦公室軟件或者相關課程

Prince Hotel 香港太子酒店
Marco Polo Hong Kong Hotel 馬哥孛羅香港酒店
Kerry Warehouse 嘉里貨倉
Labor Department 勞工處
Baguio Green Group 碧瑤綠色集團
香港耆康老人福利會
Education Bureau 教育局
Hong Kong Institute of Education 香港教育大學
Hong Kong Housing Authority 香港房屋委員會
Hong Kong ICAC 香港廉政公署
Hang Seng Bank 恒生銀行
Civil Aivation Department 民航處
Darty Asia
UA Finance 亞洲聯合財務有限公司
基督教香港信義會
NCSI Hong Kong Ltd
香港善道會
恆生銀行
聯合國兒童基金會
City University of Hong Kong 香港城市大學
香港明愛
救世軍
City Facilities Management Holdings Ltd
HACEO 香港飛機工程
JLL 仲量聯行
Hong Kong VTC 職業訓練局
Hong Kong IVE 香港專業教育學院
Adidas Hong Kong
Polyplastics
Apex Logistics
Defond 德豐
JAS Worldwide
VTech Hong Kong 偉易達香港
VTech Hong Kong 偉易達香港
YWCA 女青年會
東華三院
iRobot Hong Kong
Bureau Veritas
Boardway 百老滙
StarLite Holdings (星光集團)
Puma Hong Kong
Marriott International 萬豪國際
WheeLock會德豐
香港立信德豪會計師事務所 (BDO)
Kering Group
中華電力有限公司
Wilko Worldwide Limited
華懋集團
機電工程署
無國界醫生
Unilever Hong Kong 聯合利華
獅王 (Lion Corporation)
菱電商事株式会社
Merck & Co 默克藥廠
九龍木球會
香港航空發動機維修服務有限公司
維他奶國際集團
Toyota 豐田汽車
adidas Hong Kong
連續五年 (2017,2018,2019,2020,2021) 為VTC 職業訓練局的員工作培訓
連續八年為勞工處YES的會員作”辦公室軟件”培訓
浸會大學
西門子 Siemens
Fujitsu Hong Kong
Luxasia
Miele
Pacific Coffee
PersolKelly
Schmoll Group
Johnson & Johnson
周大福集團
Tory Burch
南洋商業銀行
新鴻基
迪士尼樂園
一田百貨

Certificate in Power Apps Development (Canvas Apps)

課程簡介

課程目標

Canvas Apps

Data Sources

User Interfaces

Work with Gallery and Form

Power FX

Advanced Power FX Features

Integrate with Power Automate

Publish and Secure Your App

課程相關資料

課程內容

Introduction to Power Apps

Getting Started with Power Apps

Creating Your First Canvas App

Introducing Variables and Collections

Using Gallery and Forms

Working with Data Sources

Designing the User Interface

Implementing Logic with Power FX

Advanced Power FX Techniques

Using Power Automate with Power Apps

Managing App Security and Permissions

Publishing and Sharing Your App

Instructor

Dannis Mok

相關專業認證

相關教學經驗

企業客戶

Dannis Mok

導師曾教授以下客戶 - 辦公室軟件或者相關課程

Our Clients

Enrollment Form for Power Apps

Please fill in the details

Enrollment details

Your enrollment details are as follows:

Class Code:

First Name:

Last Name:

Email:

DOB:

Mobile:

Other Phone:

Gender:

Chinese Name:

Address:

Enrollment Confirmation

Thank for your enrollment

We have already reserved a seat for you and wee will contact you soon to inform your payment procedures

Enquiry Form

Please fill in the details

Enquiry Confirmation

Thank for your Enquiry

We have received your question and will feedback you soon

Success

Error

Thank for your Enquiry

We have received your question and will feedback you soon

Certificate in
Power Apps Development
(Canvas Apps)