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

