+91 9176633248
+91 9176633248
+91 9176633248

Courses

New

By learning Power Apps and Power Automate, you’ll become a Microsoft Power Platform
Professional, a skillset that is seeing explosive demand across industries.

On-Cloud Tools

Tools Covered

Application Development Tool

Power Apps

Power_apps_img

Work-flow Automation Tool

Power Automate

Power_automate_img

Key Highlights

Course Syllabus

Objective:

Master this low-code platform for developing tailored business applications. Learn to create responsive apps that integrate seamlessly with data sources, enhancing efficiency in business operations without requiring advanced Coding Skills

Topics Coverd

Power Apps Training Course for Working Professionals

INTRODUCTION TO POWER APPS

Overview of Power Apps

  • What is Power Apps?
  • Benefits and use cases
  • Types of Power Apps: Canvas, Model-Driven, and Portal Apps

Getting Started

  • Setting up your Power Apps environment
  • Navigating the Power Apps interface

DATA INTEGRATION AND MANAGEMENT

Connecting to Data Sources

  • Introduction to connectors
  • Connecting to common data sources (SharePoint, Excel, SQL Server, etc.)

Managing Data

  • Understanding data tables and collections

BUILDING YOUR FIRST CANVAS APP

Basics of Canvas Apps

  • Understanding Canvas Apps
  • Creating a simple Canvas App
  • Adding screens and navigation
  • Creating simple app to view details from data source.
  • Using simple forms to display and edit data

ADVANCED CANVAS APP FEATURES

User Experience Design

  • Designing responsive layouts
  • Using themes and templates
  • Best practices for user interface design

Working with Controls

Using different types of controls like

  • Button
  • Text input
  • Drop down
  • Combo Box
  • Date picker
  • List box
  • Radio
  • Text label
  • Vertical gallery
  • Horizontal gallery
  • Flexible height gallery
  • Blank Vertical gallery
  • Blank Horizontal gallery
  • Blank Flexible height gallery
  • Data table
  • Horizontal container
  • Vertical container
  • Container
  • Image
  • Icons
  • Shapes
  • Working with control properties

Working with Variables

  • Global variables
  • Context variable
  • Collections

Using formulas for dynamic form management

Functions to be used in forms

  • SubmitForm
  • EditForm
  • Clear
  • ClearCollect
  • Collect
  • Filter
  • If
  • Navigate
  • NewForm
  • Notify
  • Patch
  • Refresh
  • Search
  • Set
  • Text
  • ThisItem
  • Value

Advanced Controls and Features

  • Working with media (images, videos)
  • Implementing charts and graphs
  • Using Power Automate for workflows

INTRODUCTION TO MODEL-DRIVEN APPS

Basics of Model-Driven Apps

  • Understanding the Common Data Service (Dataverse)
  • Creating entities and relationships
  • Building a simple Model-Driven App

SECURITY AND ADMINISTRATION

Security in Power Apps

  • Understanding security roles and permissions
  • Implementing data security

App Management

  • Managing app versions
  • Publishing and sharing apps

BEST PRACTICES AND ADVANCED TOPICS

Performance Optimization

  • Tips for improving app performance
  • Debugging and troubleshooting techniques

Real-World Use Cases

  • Case studies and examples
  • Industry-specific applications

REALTIME PROJECTS

  • Project 1: Employee Leave Request App

  • Project 2: Inventory Management App

  • Project 3: Customer Feedback App

  • Project 4: Project Management Dashboard

  • Project 5: Sales Order Processing App

Objective:

In this section, you will learn how to automate repetitive tasks and streamline workflows. You can set up automated processes that connect your BI tools with other software, like sending notifications or updating data automatically. This automation

Topics Coverd

Power Automate Training Course for Working Professionals

INTRODUCTION TO POWER AUTOMATE

Overview of Power Automate

  • What is Power Automate?
  • Benefits and use cases
  • Types of flows: Cloud Flows, Desktop Flows, and Business Process Flows

Getting Started

  • Setting up your Power Automate environment
  • Navigating the Power Automate interface

CREATING YOUR FIRST FLOW

Basics of Flow Creation

  • Understanding triggers and actions
  • Creating a simple flow
  • Running and testing flows

Flow Templates

  • Using predefined templates
  • Customizing template flows
  • Best practices for using templates

WORKING WITH CONNECTORS

Introduction to Connectors

  • Understanding connectors and their roles
  • Connecting to common data sources (SharePoint, OneDrive, Outlook, etc.)

Advanced Data Integration

  • Using premium connectors
  • Connecting to SQL Server, Azure, and other advanced data sources

ADVANCED FLOW FEATURES

Conditions and Loops

  • Implementing conditional logic
  • Using loops for repetitive tasks

Approvals and Notifications

  • Creating approval workflows
  • Sending email and mobile notifications

Error Handling and Troubleshooting

  • Managing errors in flows
  • Debugging and troubleshooting techniques

DESKTOP FLOWS (RPA)

Introduction to Desktop Flows

  • Understanding Robotic Process Automation (RPA)
  • Setting up Power Automate Desktop

Building Desktop Flows

  • Recording desktop actions
  • Automating desktop applications

Advanced Desktop Flow Features

  • Using conditions and loops in desktop flows
  • Integrating with cloud flows

BUSINESS PROCESS FLOWS

Introduction to Business Process Flows

  • Understanding business process automation
  • Creating a simple business process flow

Customizing Business Process Flows

  • Defining stages and steps
  • Implementing business rules and logic

Advanced Business Process Flow Features

  • Using custom entities and fields
  • Integrating with power apps

PROJECTS

Power Automate Projects

  • Project 1: Automated Invoice Approval Workflow

  • Project 2 : Employee Onboarding Automation

  • Project 3: Social Media Post Scheduler

  • Project 4: Customer Support Ticketing System

  • Project 5: Monthly Sales Report Automation

Desktop Flows (RPA

  • Project 1: Automated Data Entry from Emails

  • Project 2: Invoice Processing and Archiving

  • Project 3: Automated Report Generation

  • Project 4: Customer Account Reconciliation

  • Project 5: Automated Data Migration

For FSBI Students Only.

Course Fee

INR 15,000(Initial Payment)
5000 / month (for 3 - months)

₹500 | Register Now

Cohort Date

Training Schedule

Month 1 - Power Apps

Sat, Jul 05 | Sat, Jul 12 |Sat, Jul 19 |Sat, Jul 26

03:00 PM to 05:30 PM

Month 2 - Power Apps

Sat, Aug 02 | Sat, Aug 09 |Sat, Aug 16 |Sat, Aug 23

03:00 PM to 05:30 PM

Month 3 - Power Automate

Sat, Aug 30 | Sat, Sep 06 |Sat, Sep 13 |Sat, Sep 20

03:00 PM to 05:30 PM

Month 4 - Integrated scenario on Power Apps, Power Automate and Power BI

Sat, Sep 27 | Sat, Oct 04 | Sat, Oct 11 | Sat, Oct 18

03:00 PM to 05:30 PM

Excelgoodies

We're just a call away!

Connect with Us

Excelgoodies Software Private Limited

56, 1st & 2nd Floor, North Boag Road,

T. Nagar, Chennai - 600 017

Mr.Raj

Business Associate

Tel: +91 9176633248

Email: support@excelgoodies.com

Reserve My Seat

Cohort Date

Training Schedule

Alternate Text

Week 1 - Power Apps

Sat, Jul 05 | Sat, Jul 12 |Sat, Jul 19 |Sat, Jul 26

03:00 PM to 05:30 PM

Week 2 - Power Automate

Sat, Aug 02 | Sat, Aug 09 |Sat, Aug 16 |Sat, Aug 23

03:00 PM to 05:30 PM

Week 3 - Advanced Power Automate

Sat, Aug 30 | Sat, Sep 06 |Sat, Sep 13 |Sat, Sep 20

03:00 PM to 05:30 PM

Week 4 - Integrated scenario on Power Apps, Power Automate, and Power BI

Sat, Sep 27 | Sat, Oct 04 | Sat, Oct 11 | Sat, Oct 18

03:00 PM to 05:30 PM

Reserve My Seat

We're just a call away!

Connect with Us

Excelgoodies Software Private Limited

56, 1st & 2nd Floor, North Boag Road,

T. Nagar, Chennai - 600 017

Mr.Raj

Business Associate

Tel: +91 9176633248

Email: support@excelgoodies.com

Globally-Certified

Total Certificates: 03

Workflow Specialist using Power Automate

Power_Automate_certificate

Power Apps Business Solutions Expert

Power_Automate_certificate

Fullstackbi Reporting & Automation Specialist (On-Cloud)

FSBI_Cloud

Globally-Certified

Total Certificates: 03

Projects & Case Studies

What is Included?

  • 5 Power Apps Project
  • 5 Work-flow (RPA) Projects
  • 5 Power Automate Project
  • 3 Master Projects

Hands-on

Projects You'll Work On

  • 1: Employee Leave Request App
  • 2: Inventory Management App
  • 3: Customer Feedback App
  • 4: Project Management Dashboard
  • 5: Sales Order Processing App
  • 6: Automated Invoice Approval Workflow
  • 7 : Employee Onboarding Automation
  • 8: Social Media Post Scheduler
  • 9: Customer Support Ticketing System
  • 10: Monthly Sales Report Automation
  • 11: Automated Data Entry from Emails
  • 12: Invoice Processing and Archiving
  • 13: Automated Report Generation
  • 14: Customer Account Reconciliation
  • 15: Automated Data Migration

6 reasons why FSBI students should learn
Power Apps & Power Automate?

1

Become a Microsoft Power Platform Professional

By learning Power Apps and Power Automate, you’ll become a Microsoft Power Platform Professional, a skillset that is seeing explosive demand across industries.

2

No-Code/Low-Code Development

While Python and VBA require coding expertise, Power Apps & Power Automate allow you to build custom applications and automate workflows without the need for complex coding, making it faster and more accessible

3

Rapid Prototyping & Deployment

Build and deploy apps in days, not weeks. Power Apps and Automate significantly speed up development compared to traditional coding solutions.

4

Seamless Integration with Microsoft Ecosystem

These tools integrate smoothly with other Microsoft products like Power BI, Office 365, SharePoint, and Dynamics 365, making them ideal for businesses already using Microsoft technologies.

5

End-to-End Automation

Power Automate enables end-to-end automation of business processes, including integration with third-party tools and external systems, which can be cumbersome to achieve with Python or VBA alone.

6

Empower Business Users

With Power Apps, non-technical business users can also build apps and automate processes, making you a key resource in bridging the gap between technical teams and business users.

APPLICATION DEADLINE

Registration Closes on Wed, 02 Jul.

Enroll Now

By clicking any of the above buttons, I agree to the terms & conditions and privacy policy, and I consent to receive updates via SMS or email.