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. I followed this up an hour later with a post on my Runway View blog that outlined four things to know and five things to do following the big Microsoft Dataflex + Teams announcement. Below I have outlined five real-world scenarios where Microsoft Dataflex is a game-changer, particularly […]
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 […]
Applied Information Sciences (AIS) has been recognized as the Microsoft Partner of the Year (2020) for Power Apps and Power Automate! This is an exciting award for our company and one which we are honored to receive. AIS has a long history helping customers in large, global, and often regulated industries work through their cloud transformation. We know that this success is due in large part to the Power Platform community and the hard work of our business applications leaders […]
A Framework to Meet Your Needs PowerApps comes with a wide variety of controls out of the box. However, these controls may not be on-brand or have the desired look and feel, functionality, or style for your app. The PowerApps Component Framework command-line interface tools let you create a custom PowerApps control specific to your individual needs. PCF works this magic by integrating JavaScript libraries into the PowerApps control. As a primarily JavaScript frontend developer, my normal workflow is project […]