In the previous installment, you saw how to work through a set of prerequisites to get you going in your Power Platform Application Lifecycle Management journey. In this video, I will work through building an app and adding it to a solution and show you some additional Azure DevOps configuration options to link your repository to your Power Platform development environment.
Topics Covered:
1. Building app based on template
2. Adding your app to a solution
3. Linking your DevOps project to your Power Platform environment
This series is in response to multiple requests by my viewers to address the topic of Power Apps Application Lifecycle Management (ALM). This series is intended to breakdown the entire process in as much detail as possible, without lengthy explanations on how to get it done or, as often happens, little to no explanations on how you arrived at a particular step or result.
My first installment will focus on Prerequisites, this is, what you need to have in place to get started. I will walk you through provisioning your Power Platform Dev, QA, and Production environments, along with installing the Power Platform Build Tools and setting up your Azure DevOps project. I also explain the concept of solutions in Power Platform and why they are important to your ALM strategy.
Topics covered:
1. Creating Power Platform Environments
2. Azure DevOps and Installing Power Platform Build Tools
3. Creating an Azure DevOps Project
4. Solutions
Majority of times, when we are working with various data sources, we want information to go from one source to another, conditioned to the occurrence of an event. Today, I will show you how to transfer records from a SharePoint list to Azure SQL database tables in response to a timesheet approval event. In the process, you will learn how I leveraged the existing Power Apps Expense template app and converted it into a Timesheet app for the purpose of recording time for various activities
Other topics covered:
Working with SharePoint lists and Azure SQL databases
"When an item is created or modified" SharePoint connector trigger
"Delete Item" SharePoint connector action
"Get Items" SharePoint connector action
Conditional actions
Get Rows and Insert Row SQL connector actions
Apply to each action
substring(), formatDateTime()
Please leave your comments below and let me know what you think. Also, please feel free to suggest topics you would like me to cover.
References:
Reza Dorrani - Expense Tracking Sample Power App with Receipt Scanning AI - Click here