This blog series is for anyone trying to learn how to use the Power Platform. Readers should know software development fundamentals. It begins by explaining why we would want to create a home inventory system. It then takes the reader over the requirements of the system, including potential future enhancements. It takes time to explain the database model and how it translates into tables in the Microsoft Dataverse. This post concludes with a review of the User Interface mockup. The […]

Pluralsight Course Overview Robotic Process Automation (RPA) has been a top tech trend over the last few years, and we are seeing great interest in augmenting RPA with Artificial Intelligence (AI) to make automation more resilient. While Power Automate (previously called Flow) has been around for a while, RPA capabilities have been a recent addition, allowing you to automate all repetitive desktop processes. You can choose between prebuilt drag-and-drop actions or record your own desktop flows. In this course, Intelligent […]

This video demo and blog provide a step-by-step walkthrough of adding related subgrids to a Power Apps portal for a Trip Planner Application. You may consider adding a related subgrid to your portal if you have tables associated with each other. For example, you have a Trip table that is your main table and a Traveler table. You want your traveler table to be directly related to your trip table so that any data you add to your traveler table […]

Rapidly deploy Microsoft’s Return to the Workplace solution and leverage the underlying technology for future growth Today, Microsoft announced the release of the Return to Work, Return to Growth strategy in a white paper developed jointly with AIS. We’re also releasing our Return to Work implementation service via Microsoft App Source, and are excited to begin working with large enterprise organizations rolling out Microsoft’s Return to the Workplace solution and then using the Power Platform to empower citizen developers, build […]

This blog is a step-by-step walkthrough of building a fully functioning leave request app for any organization with a vacation, sick leave, military leave, bereavement leave, holidays, Jury Duty, and so on. This app will include a solution in the Common Data Service, a Model-Driven App, a Canvas App, and Power Automate. The Canvas App is for employees to submit a request. The Model-Driven App will be a back-office system used by admin or supervisors to check everyone’s requests. The Power Automate flow will trigger […]

Assumptions This write up is executed in sequence in that if you jump to a section, it assumes you have completed the parts before it. This write-up assumes the following; You have a Power Apps tenant with administrative privileges. For the source control and CI/CD sections; An Azure DevOps project configured with the Power Apps Build Tools Extension. 3 Power Apps environments; development, staging/build, and production. Executive Summary This write-up is for anyone looking to learn how to automate the […]

Summary To break this series apart into more manageable chunks, in this installment, we’ll focus on setting up the API in Azure API Management (APIM) and the custom connector. If you missed the first installment where we set up our On-Premises Data Gateway and Azure Logic App, please check it out here. Scenario The company has an on-premises SQL Server database that contains customer data that needs to be available to various apps built on the Power Platform and/or Azure. […]

Last week, Microsoft introduced its new Dataflex technology for data services inside of Microsoft Teams, in addition to the rebranding of its former Common Data Service (CDS) to be called Dataflex Pro. Below I have outlined five real-world scenarios where Microsoft Dataflex is a game-changer, particularly in larger enterprise organizations. These 5 scenarios are a reflection on actual situations I see playing out with AIS clients today. Requirement-driven Application Development These are common scenarios when the organization has a specific […]

This blog is part of a series of hands-on labs on leveraging the Power Platform and Microsoft Azure. To break this series up into more manageable chunks, in this installment, we’ll focus on setting up the On-Premises Gateway that will connect to our local SQL Server and the Azure Logic App that will use the new gateway to connect to our local SQL Server 2017 and return customer data using an HTTP request and response. We’ll wrap it up by […]

Leveraging the Power Platform and Microsoft Azure to connect housing agencies and intermediaries with the Department of Housing and Urban Development (HUD) Intro The US Department of Housing and Urban Development runs a program known as the Housing Counseling Program that aids housing agencies around the nation through things like grants and training. These agencies provide tremendous benefit to Americans in many forms including credit counseling, foreclosure prevention, predatory lending awareness, homelessness, and more. One of the requirements for approval […]