Microsoft Power Apps and Python Integration

Inquire now

This course equips participants to develop integrated business applications using Microsoft Power Apps and Python. It covers Python programming fundamentals, structured data processing, REST API development with FastAPI, canvas application design with Power Fx, and workflow automation with Power Automate.

Participants learn to connect applications to SharePoint and Microsoft Dataverse, integrate Power Apps with Python backend services, and apply validation, security, troubleshooting, and deployment practices. The course culminates in an Employee Request Management System that combines the technologies into a complete business solution.

 

 

Duration 7 Days – 49 hrs.

 

Objectives

  • Explain Python programming fundamentals and the core components of Microsoft Power Platform.
  • Write Python programs using variables, operators, conditions, loops, and functions.
  • Process business records using collections, classes, files, JSON, and exception handling.
  • Develop REST APIs using FastAPI, Pydantic models, and standard HTTP methods.
  • Design interactive canvas applications using screens, controls, galleries, and forms.
  • Apply Power Fx formulas, variables, collections, validation, and data operations.
  • Connect Power Apps to SharePoint and Microsoft Dataverse.
  • Create Power Automate workflows triggered from Power Apps.
  • Exchange data between Power Apps and Python APIs through HTTP actions and custom connectors.
  • Apply basic security, error handling, troubleshooting, and deployment practices.
  • Build an integrated business application using Power Apps, Power Automate, and Python.

 

 Target Audience 

  • Application developers building business applications and backend integrations.
  • Business analysts translating business requirements into applications.
  • IT professionals supporting Microsoft 365 and Power Platform solutions.
  • Power Apps users and citizen developers extending applications with Python.
  • Python beginners interested in business application development.
  • Business process automation specialists developing integrated workflows.

 

Prerequisites 

  • Basic computer literacy and familiarity with Microsoft 365.
  • Familiarity with business forms, records, and common business processes.
  • Basic programming exposure is helpful; prior Python or Power Apps experience is not required.
  • Access to a computer with Python 3, Visual Studio Code, FastAPI, and Uvicorn.
  • Access to Postman or FastAPI interactive API documentation for API testing.
  • Access to a configured Power Platform environment with appropriate Power Apps and Power Automate premium capabilities.
  • Access to SharePoint and Microsoft Dataverse, with permissions to create applications, flows, connections, and data structures.
  • An HTTPS-accessible Python API endpoint and the authentication and permissions required for integration.

  

 

Course Outline 

Day 1 — Python Programming Fundamentals

Module 1 — Introduction to Python Programming

  • Python applications in business solutions.
  • Development environment setup.
  • Python interpreter and script execution.
  • Syntax, indentation, and code structure.

  

Module 2 — Variables, Data Types, and Operators

  • Variables and value assignment.
  • Strings, numbers, and Boolean values.
  • Arithmetic, comparison, and logical operators.
  • Type conversion, input, and output.

 

Module 3 — Conditional Statements and Loops

  • Conditional logic using if, elif, and else.
  • Logical expressions and nested conditions.
  • Iteration using for and while loops.
  • Loop control using break and continue.

 

Module 4 — Functions and Modular Programming

  • Function definitions, parameters, and return values.
  • Variable scope.
  • Reusable functions and introductory modules.
  • Calculator, salary computation, and business rule examples.

 

Hands-on Laboratory Activities

  • Python calculator
  • Employee salary computation
  • Business rules using conditions and functions

Expected learning outcome: Create Python programs using fundamental programming constructs and reusable functions.

 

Day 2 — Python Data Structures and Data Processing
Module 5 — Python Data Structures

  • Lists, tuples, dictionaries, and sets.
  • Collection operations and iteration.
  • List comprehensions.
  • Nested collections for business records.

  

Module 6 — Object-Oriented Programming

  • Classes, objects, and constructors.
  • Attributes and methods.
  • Encapsulation.
  • Introduction to inheritance and polymorphism.

 

Module 7 — File Handling and JSON Processing

  • Reading and writing text and CSV files.
  • JSON objects and arrays.
  • Serialization and deserialization.
  • Processing employee and business records.

 

Module 8 — Exception Handling and Project Organization

  • Exception handling using try, except, else, and finally.
  • Raising errors and handling invalid data.
  • Modules, pip, and virtual environments.
  • Organizing reusable application components.

Hands-on Laboratory Activities

  • Employee management program
  • Records using Python collections
  • CSV and JSON processing
  • Exception handling and modular code

Expected learning outcome: Build structured Python programs that manage records and handle errors.

 

Day 3 — Python REST API Development Using FastAPI

Module 9 — RESTful Web Service Fundamentals

  • Client-server architecture.
  • HTTP and HTTPS communication.
  • GET, POST, PUT, and DELETE methods.
  • Status codes and JSON requests and responses.

  

Module 10 — Introduction to FastAPI

  • FastAPI application setup and Uvicorn.
  • Endpoint creation.
  • Path parameters, query parameters, and request bodies.
  • Interactive API documentation.

 

Module 11 — Developing REST APIs

  • Create, read, update, and delete endpoints.
  • Pydantic request and response models.
  • Data validation and business logic.
  • Exception handling and route organization.

 

Module 12 — API Testing and Security Fundamentals

  • Endpoint testing using Postman and Swagger UI.
  • Response validation and invalid request handling.
  • Authentication and API security concepts.
  • Employee management API development.


Hands-on Laboratory Activities

  • Create FastAPI application
  • Employee management API
  • Implement CRUD endpoints
  • Test endpoints with Postman

Expected learning outcome: Develop and test JSON-based Python APIs for integration.

 

Day 4 — Power Apps Fundamentals and Canvas Application Development

Module 13 — Introduction to Microsoft Power Platform

  • Power Platform components and business uses.
  • Canvas and model-driven applications.
  • Environments and licensing concepts.
  • Power Automate overview.

  

Module 14 — Building Canvas Applications

  • Power Apps Studio.
  • Screens and navigation.
  • Labels, text inputs, buttons, and dropdowns.
  • Control properties and application behavior.

 

Module 15 — Power Fx Fundamentals

  • Formulas and expressions.
  • Global and context variables using Set and UpdateContext.
  • Conditional logic using If and Switch.
  • Collections, filtering, sorting, and validation.

 

Module 16 — Interactive Application Design

  • Application layouts and responsive design.
  • Galleries, forms, and data cards.
  • Employee registration screens.
  • Saving and previewing applications.

 

Hands-on Laboratory Activities

  • Create canvas application
  • Employee registration form
  • Power Fx expressions
  • Multi-screen navigation

Expected learning outcome: Design interactive Power Apps canvas applications.

 

Day 5 — Power Apps Data Integration and Workflow Automation

Module 17 — Connecting to Business Data

  • Data sources and connectors.
  • SharePoint Lists and Excel.
  • Dataverse tables and columns.
  • SQL Server overview and multiple data sources.

  

Module 18 — Managing Application Data

  • Displaying records in galleries.
  • Creating, updating, and deleting records.
  • Patch and SubmitForm.
  • Filtering, sorting, validation, and delegation considerations.

 

Module 19 — Creating Power Automate Workflows

  • Cloud flows, triggers, and actions.
  • Flows triggered from Power Apps.
  • Passing inputs and returning outputs.
  • Workflow error handling.

 

Module 20 — Security and Application Management

  • Application sharing and data source permissions.
  • Connections and data loss prevention policies.
  • Publishing applications.
  • Embedding applications in Teams and SharePoint.

 

Hands-on Laboratory Activities

  • Connect to SharePoint
  • Emloyee CRUD canvas app
  • Create Power Automate flow
  • Trigger flow from Power Apps

Expected learning outcome: Create data-driven canvas apps and automate workflows.

 

Day 6 — Integrating Power Apps with Python REST APIs

Module 21 — Integration Architecture

  • Power Apps as the application frontend.
  • FastAPI as the Python backend.
  • Power Automate as the integration intermediary.
  • REST communication and JSON data exchange.

 

Module 22 — Preparing Python APIs for Integration

  • Request and response models.
  • Input validation and backend business rules.
  • Structured JSON responses and error messages.
  • HTTPS endpoint readiness.

 

Module 23 — Power Automate HTTP Integration

  • Power Apps (V2) trigger.
  • HTTP POST requests and JSON payloads.
  • Parsing API responses.
  • Returning results to Power Apps.
  • Error and timeout handling.

 

Module 24 — Custom Connectors and Integration Security

  • OpenAPI concepts.
  • Basic custom connector creation and configuration.
  • Connector authentication concepts.
  • Connector testing and integration troubleshooting.

 

Hands-on Laboratory Activities

  • Prepare FastAPI endpoint
  • Build HTTP cloud flow
  • Send Power Apps data to Python
  • Display API results
  • Test basic custom connector

Expected learning outcome: Integrate Power Apps and Python through Power Automate; understand custom connectors as an alternative.

 

Day 7 — End-to-End Application Development and Deployment

Module 25 — Capstone Planning and Solution Architecture

  • Employee Request Management System requirements.
  • Application components and integration workflow.
  • Data structures and API endpoint definitions.
  • Validation rules and expected application behavior.

 

Module 26 — Capstone Application Development

  • Power Apps request submission and record viewing screens.
  • Python backend processing and business rules.
  • FastAPI endpoints and JSON processing.
  • Power Automate integration.
  • SharePoint persistence for employee requests.

 

Module 27 — End-to-End Testing and Troubleshooting

  • API, flow, and application testing.
  • Valid and invalid request scenarios.
  • Integration errors and permission issues.
  • Data consistency and response handling.

 

Module 28 — Deployment and Solution Documentation

  • Application publishing and sharing.
  • Connection and access configuration.
  • Architecture and configuration documentation.
  • Operating instructions and maintenance considerations.

 

Hands-on Laboratory Activities

  • Develop integrated app
  • Implement backend processing
  • Connect Power Apps and Python
  • End-to-end testing
  • Final project presentation

Expected learning outcome: Demonstrate an integrated business application and explain its architecture

 

Inquire now

Best selling courses

Duration: 5 days – 35 hrs   Overview The “SOC Network and Threat Detection and Analysis” training course is designed to equip Security Operations Center (SOC) analysts and IT security professionals with the skills and knowledge required to detect, analyze, and respond to network threats effectively. This comprehensive course covers essential topics such as threat...

Duration 1 day – 7 hrs   Overview   This 1-day training builds upon basic warehouse operations knowledge and introduces key logistics concepts involved in the movement and coordination of goods—especially wet and dry food items—within and outside the warehouse. Participants will explore transport logistics, inbound and outbound coordination, documentation practices, and cold chain considerations,...

Duration 2 days – 14 hrs   Overview   This hands-on course provides an introduction to Splunk, a powerful platform for searching, monitoring, and analyzing machine-generated data. The training focuses on how developers and QA professionals can leverage Splunk to gain insights from logs and metrics, improve application observability, detect anomalies, and support test validation....

Duration 3 days – 21 hrs   Overview.   This course is designed for fresh graduates aspiring to build a career in Data Science. It introduces the fundamentals of data science, focusing on data analysis, visualization, and basic machine learning concepts using Python. The course provides hands-on practice with real-world datasets, equipping participants with the...

Duration 5 days – 35 hrs   Overview   The Microsoft Certified: Azure Administrator Associate (AZ-104) Training Course is designed for IT professionals who want to develop expertise in managing Microsoft Azure environments. This course provides hands-on training on deploying, managing, and monitoring Azure services, including virtual machines, networking, storage, identity, and security.   Objectives...

ARTIFICIAL INTELLIGENCE / MACHINE LEARNING / DEEP LEARNING

Capstone Workshop: Build Your Own GenAI Toolkit TECH AI

GenAI Toolkit Training is a practical, hands-on capstone workshop designed to help participants bring their generative AI knowledge together into a personalized toolkit of AI tools, prompts, workflows, and practical solutions. Rather than simply learning individual AI platforms, participants will learn how to select and combine the right tools to address real-world technical and professional...

In this course, you will gain practical foundation level training that enables immediate and effective participation in big data and other analytics projects. Learn ways of storing data that allow for efficient processing and analysis, and gain the skills you need to store, manage, process, and analyze massive amounts of unstructured data to create an appropriate data lake.

Advanced Laravel Engineering Scalable Architecture, Performance, Testing, Queues & DevOps equips developers with the skills to design scalable Laravel applications, optimize performance, implement automated testing, manage queues, and integrate DevOps practices for reliable, production-ready deployments.   Duration 5 Days – 35 hrs   Overview This advanced-level bootcamp is designed for teams building large-scale or mission-critical...

// BG EARTH WHEN NOT PLAYING

We use cookies on our website to personalize your experience by storing your preferences and recognizing repeat visits. By clicking “Accept”, you agree to the use of all cookies. You can also select “Cookie Settings” to adjust your preferences and provide more specific consent. Cookie Policy