[ December 18, 2020 by Florian Endres 0 Comments ]

Extending Logic Apps – using Custom Connectors and Local Gateways to connect all of your services

Logic Apps are a powerful tool to automate tasks, processes, and workflows with little to no code. And it comes with hundreds of connectors to easy integrate different services. But what happens if there is no connector for this one service that you are using? Or what about the service that is running in your network and can’t be accessed from the cloud but holds very valuable information? Logic App Custom Connectors answers those questions and allows you to connect previously unavailable services. In this session, we’ll explore Logic App Custom Connectors, build our very first own connector and also look into connecting on-prem services to the cloud.

[ December 18, 2020 by Florian Krönert 0 Comments ]

Dynamics 365 CE and Dynamics Portals UI Testing with D365-UI-Test

In this session I want to show how to get started with UI Testing in Dynamics 365 Customer Engagement and Dynamics Portals with a new library that I created: D365-UI-Test. It’s a modern new framework, using Microsoft’s own latest browser driver “playwright” and written completely in TypeScript. The goal of D365-UI-Test is to provide an easily accessible, fast to get started and robust platform for writing UI tests in D365 CE and Dynamics Portals. I’m not too sure on the scope, whether a presentation where I run everything at my side or a workshop where the audience can set up the tool on their side would be a better fit for the session, so advice from your side would be great. The project is open source and available here: https://github.com/XRM-OSS/D365-UI-Test

[ December 18, 2020 by Sean McAvinue 0 Comments ]

Mastering Governance in Microsoft Teams through Automation

In this session, you will learn how to use automation to fill the governance and security gaps in your Teams deployments. Filled with real-world tips and tricks, we will demonstrate how to reduce overhead and make provisioning Teams easy and secure using Graph API, LogicApps and Azure Functions.

[ December 17, 2020 by David Robertson 0 Comments ]

Low-code automated UI testing for model-driven apps

This session is to give an overview of powerapps-specflow-bindings, an open-source automated UI testing framework for Power Apps. This framework is being used and maintained by Capgemini and is built on top of the popular open-source EasyRepro library from Microsoft. This framework drastically reduces the effort required to create automated UI tests that follow best practices. In addition, it handles many common problems, such as: test parallelisation, data setup and clean-up, and user identities. The repository can be found at https://github.com/Capgemini/powerapps-specflow-bindings

[ December 8, 2020 by Jan Vidar Elven 0 Comments ]

Protecting your Serverless Automation solutions with Azure AD

Serverless Automation solutions like Logic Apps and Azure Functions can be valuable tools for automating IT processes, much like Power Automate Flows automate user processes. While Flows run under the context of the calling user, Logic Apps and Azure Functions runs as itself, but can be triggered by anyone that knows the URI! In this session we will look into how to add Azure AD Authentication and Authorization to these solutions, and how we can let end users call them securely and protected by Azure AD, and how these can securely call APIs like Microsoft Graph.

[ December 4, 2020 by Kiril Radoslavov 0 Comments ]

Create Dynamics 365 Records from an Excel file

The process that I will demonstrate will show how automation can be created which will create new opportunities in Dynamics 365, but this will also check whether or not an account or contact already exists, and if it does, it will link them to the newly created opportunity, if not then will create new account and contact, and then will link them to a new opportunity. The process covers a scenario where salespeople work with partners from around the world. The partners enter all their new sales in an Excel file providing details about the deal such as estimated revenue, a product of interest, who is the customer, etc. These partners however are external users without access to Dynamics CRM, so for that reason, they must send the excel file to the salesperson, who has to manually enter all the deals as new Opportunities in CRM. The process will actually save time and will trigger when an email is received with the attached excel file.

[ December 2, 2020 by Rob Sewell 0 Comments ]

Jupyter Notebooks, PowerShell and Excel Automation

Everyone loves Excel. A common request that I hear is can you put that into Excel for me, please. I love automation and so have combined two of my favourite tools PowerShell and Notebooks. Using Jupyter Notebooks to accomplish regular tasks and run-books has become common over the past year. A particular use-case that my clients have found very useful is to quickly create Excel sheets of information using Notebooks, PowerShell, and the ImportExcel module. Let me share my experience with you and show you how to create your own Notebooks for your users and the tactics I have learned to enable users to self-service and create their own Excel Workbooks.

[ December 2, 2020 by Rob Sewell 0 Comments ]

Creating Azure SQL Database Users Programmatically with a Service Principal using Azure DevOps

The cloud enables us to quickly and easily, create and destroy resources when we need them. Automating this process reduces manual mistakes and the need for user input. You can use Terraform to put Azure SQL Databases into Infrastructure as Code, then deploy them with Azure DevOps with any additional steps that your business requires for approvals or other processes Once you can create your Azure SQL Database programmatically, a cool next step would be to be able to grant and remove access using automation as well. With a sprinkling of dbatools and a couple of configuration changes, you can also set this up in Azure DevOps This session will take you through the steps required to build an automated solution to create an Azure SQL Database with a Service Principal and create users and apply permissions using Azure DevOps, Terraform, Azure Key Vault and PowerShell.

[ December 1, 2020 by Markus Bütterhoff 0 Comments ]

Getting started: Azure Functions with PowerShell

Administrators love PowerShell. Since its first release, it has made life easier for many techies, helping them repeat daily tasks on-premises or in the cloud. Azure Functions makes it easy to create serverless functionality in the cloud – even using PowerShell. In this session I will show you how to use your PowerShell knowledge to develop event-driven serverless functions in Azure. We will use a small example to create a function that is started event-driven. We will go into the development environment, debugging and deployment of the Azure Functions.

[ November 29, 2020 by Dharanidharan Balasubramaniam 0 Comments ]

Automate Power Platform Deployments with ALM using Power Platform Build Tools

In this session, I will explain how to automate the Power platform deployments with ALM using the power platform build tools.