In this article, I will show you: How to restrict users from accessing certain features in a canvas app, while other users can still see and use features. How to use SharePoint action in Power Automate to authenticate a user. Why Restrict Access? In any App, there’s always more than one type of user. For example, there will be customers, staff, administrators, and so on in an event management application. An administrator will have access to everything; meanwhile, staff will […]

Assumptions Visual Studio Code is installed Dynamics 365 (Try for free) or Power App Model Driven App is available Overview One of the challenges I had when learning Dynamics 365 / Power Platform development was how to add custom functionality to the User Interface. The .NET developer in me was frustrated when I wanted to add a button to the page that triggered some server-side code. Eventually, I learned a pattern of adding HTML / JavaScript resources to the page […]

My last post explored How to Build A Teams apps using SharePoint Framework. To continue exploring Teams app development, I will build an app using Power Platform to compare in this post. Many walk-throughs exist; I used this one. My steps appear below, along with my thoughts, to compare the two approaches. First steps: Install Power Apps in your Teams instance. Open MS Teams (either the desktop or the web version) and then click the ellipsis at the bottom of […]

In May, AIS held an internal hackathon for Microsoft Power Platform to expose our team to the platform, concepts, approaches through hands-on experience and to demonstrate the role Power Platform plays in modernizing legacy applications in the cloud. The front-end team focused on building the Power Apps Portal for the end-users and a model-driven app for the administrators. The Portal allowed the users to browse through the product catalog, add an item to the cart, place an order, view their past orders, and […]

The landscape for Power BI licensing is complex and evolving. To begin to grasp the structure and detail, let’s break it down. Today I am asking: what are the capabilities of using a free license? Really, It’s Free More than one path exists to obtain a free account. For our exploration in this article, I will use two: Individual Free Account Office 365 (Dev Tenant) Member Free Account Let’s frame this in a story with two fictional characters. Cary Small […]

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 […]

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. […]

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 […]