Posts

How to Create SharePoint Items with Power Automate Desktop

Image
Overview Power Automate Desktop is a great way to automate many of your daily task so you can focus on real work. A prime example of this is getting data from one place to another, especially when those data sources do not have an API such as a legacy desktop application or a file. In this example I demonstrate several ways in which an Excel sheet containing fictitious customer data could be loaded into a SharePoint list. In order to do this I first generated some fake data for my customers using Mockaroo . I then created a new SharePoint list and added some columns to match my spreadsheet. Methods My original plan was to just use the PAD recorder , which I did, but after creating that Flow I decided to find other possible ways to accomplish the task. The list below is not a complete list but should provide some ideas. The flexibility of PAD allows for an even wider range of possibilities for carrying out tasks such as these. At the end of each section I have placed the s

Power Apps Portal - Configure Azure AD Provider in Azure B2C

Image
It is recommended that you no longer use Local Login authentication for Power Apps Portal but instead utilize Azure Active Directory B2C to provide this type of authentication. See Migrate identity providers to Azure AD B2C Configuring the B2C providers is fairly straightforward utilizing the new preview interface Configure the Azure Active Directory B2C provider . Make sure you navigate to the preview version of the Maker portal for now to access this, https://make.preview.powerapps.com/ . For this article my goals were the following. Set the existing Azure AD and Local Login configuration as deprecated authentication mechanisms within the portal to migrate the users to B2C. Allow user to authenticate to B2C using Azure AD, Google or create local B2C account. Deprecate Old Providers Once I had run through the instructions for configuring the Azure B2C authentication I then had to mark the Local Login and Azure AD authentication methods as deprecated. This ensures that whe

Issue Connecting Through Remote Desktop Gateway

Image
While attempting to connect to a remote desktop though a Remote Desktop Gateway (RDG) the connection would ask for credentials but then just drop. After some searching I found the answer to the issue. First open open the regedit utility. Navigate to HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Terminal Server Client If there is a DWORD key called RDGClientTransport set it’s value to 1. If that key is not there right click and select **New -> DWORD (32-bit) Value" from the context menu. Set the name of the key to RDGClientTransport and it’s value to 1 .

Power Automate Desktop Example - Downloading Image From Email To Network Drive

Image
After watching the RPA (Robotic Process Automation) demo from Steve Winward Real-Life Use case using AI Builder Form Processing with Power Automate Desktop I have been looking for ways to utilize Power Automate Desktop Flows in order to make my life a little easier. Yesterday like every day I started clicking through the emails that I receive from my kids schools. I open each email, download the image, then move the image to a network drive on my computer. This takes me a few minutes every day but my kids are worth it :) This scenario was a perfect one for me to automate using Desktop Flows since they can access the network drive on my desktop. The basic flow of the solution will be as follows: A Power Automate Cloud Flow will be triggered to run whenever a new email comes into my Gmail account with a specific tag. The Cloud Flow will gather up all the information needed to run the Desktop Flow The Cloud Flow call the Desktop Flow by connecting through an On-Premise Data Gate