Send Power Automate Approvals To Groups – YouTube
Jul05

Send Power Automate Approvals To Groups – YouTube

The Power Automate approvals function is a really easy way to make your boss love you – easily send approvals to a web page, email or mobile devices. But today, approvals can only be sent to email addresses. In this video I show you how to create a flow that will allow you to send an approval to the members of an Office 365 group. source

Read More
On Premises SharePoint Connected to Power Platform – YouTube
Jun01

On Premises SharePoint Connected to Power Platform – YouTube

Even though you may have a SharePoint site that lives on premise, it doesn’t mean that it can’t take part in the Power Platform fun. In this video I take an on premise SharePoint server, install the On Premises Data Gateway and run a flow that saves incoming email attachments to a list on SharePoint on premise. source

Read More
Get Text For CDS Multiselect Option Sets Using Power Automate – YouTube
May31

Get Text For CDS Multiselect Option Sets Using Power Automate – YouTube

Multiselect option sets are a useful feature of CDS, but when you retrieve a record you get the numeric ID, not the text of the options. If you want the actual text of the options, this video shows how to build a flow that will retrieve them from the CDS Stringmap entity so that you can provide your users with a list of their selected options in an email or elsewhere. This solution is on Github here:...

Read More
Power Virtual Agent Bot To Submit Travel Requests – YouTube
Apr25

Power Virtual Agent Bot To Submit Travel Requests – YouTube

This video builds on top of the GSA-connected travel approval system in SharePoint that I built in a previous video (https://youtu.be/cd2xubPKx5k) and the Power Virtual Agents authentication overview in this video (https://youtu.be/Zd9mi88V91Q), to create a bot that submits travel approval requests. This shows a real-world example of using Power Virtual Agents authentication, but also integrating with existing systems (like...

Read More
Power Automate Travel Approvals Connected to GSA Per Diem (Custom Connector) – YouTube
Apr24

Power Automate Travel Approvals Connected to GSA Per Diem (Custom Connector) – YouTube

With the world under quarantine I decided to build another travel approval app. I have no idea why. My earlier app (https://youtu.be/y3oEhNRH2T4) used custom SharePoint forms in Canvas apps, but had static GSA Per Diem data. This one uses SharePoint out of the box features like calculated columns and location columns and a custom connector to access GSA Per Diem data from Power Automate. I show how to import the custom connector,...

Read More
Personalizing Power Virtual Agents for Authenticated Users – YouTube
Apr12

Personalizing Power Virtual Agents for Authenticated Users – YouTube

Authenticating users in Power Virtual Agents gives you the ability to not only personalize the experience with the user’s name and email address, but also look up their manager and more. In this video I show how to configure Power Virtual Agents for authentication, then look up a user’s first name and email address in order to personalize the chat. In this video I’m showing a method that I first read in Tomasz...

Read More
Importing a Custom Connector – GSA SAM Data of US Government Contractors – YouTube
Mar23

Importing a Custom Connector – GSA SAM Data of US Government Contractors – YouTube

Custom Connectors allow your organization to use Power Platform to leverage data and functionality in your custom systems, or other systems on the internet. This video shows how to import and use a Power Platform custom connector that is open source or written by someone else. I’ll be using a connector that I created to query GSA SAM data, a database of US Goverment Contractors. After importing it I’ll create a simple...

Read More
Power Apps Test Framework – Automated Testing – YouTube
Mar21

Power Apps Test Framework – Automated Testing – YouTube

Power Apps test framework enables you to build automated test cases for your Power Apps. This helps you ensure that your app changes don’t affect the other functionality of your app. In this example I’ll show how to use this framework address some of the current limitations of Power Apps test framework by using mock data for variables. I also show how to use the Assert statement to verify data or UI elements, form...

Read More
Power Virtual Agents – Reading CDS & Embedding In A Portal – YouTube
Feb18

Power Virtual Agents – Reading CDS & Embedding In A Portal – YouTube

Power Virtual Agents are a Power Platform feature that allows you to create bots without writing code. In this demo, I create a bot that reads data from the Common Data Service and I embed that bot in a Power Apps Portal. This demonstration uses a forms automation application that I create in this video: https://youtu.be/qaHOrwgfe5Y source

Read More
UI Flows – Calling a Desktop UI Flow from flow (email trigger) – YouTube
Dec29

UI Flows – Calling a Desktop UI Flow from flow (email trigger) – YouTube

UI Flows are most powerful when they are triggered by a cloud process. In this video I use flow to trigger a desktop UI flow when flow detects an incoming email. In particular, when an email request comes in for an autograph, the desktop UI flow creates an personalized autographed photo of Charles Lamanna, the technical leader behind Power Platform, then flow emails the image back to the requester. In this video I use a virtual...

Read More
Power Automate UI Flows – Creating a Virtual Machine To Run UI Flows – YouTube
Dec29

Power Automate UI Flows – Creating a Virtual Machine To Run UI Flows – YouTube

UI Flows manipulate the mouse and keyboard just as a human would, so they work best when they run on a dedicated machine. In this video I show you how to … source

Read More
Split Flap in Power Apps (2/2) – Building An Old-School Schedule Board CDS & Flow – YouTube
Nov24

Split Flap in Power Apps (2/2) – Building An Old-School Schedule Board CDS & Flow – YouTube

This is the second part of building a Split Flap display board using Power Platform. Split Flap boards are the old-school digital display boards in airports and train stations. In the first video (here: https://youtu.be/U9D9zG2rExo) we built the foundation using Canvas Components. In this video, I show you how to make the display a “live” display by using Power Automate flow to populate the Common Data Service directly...

Read More
Split Flap in Power Apps (1/2) – Building An Old-School Schedule Board With Canvas Components – YouTube
Nov24

Split Flap in Power Apps (1/2) – Building An Old-School Schedule Board With Canvas Components – YouTube

This is part one of two of building a Split Flap display board using Power Platform. Split Flap boards are the old-school digital display boards in airports and train stations. In this video I use Canvas Components to create a split flap letter and then place 36 of these on a board that we can control. In the second video (here: https://youtu.be/ZHvRiEK8v-0) I Power Automate flow connections to gather new messages from Twitter, Teams...

Read More
Power Automate UI flows – The Ghost In The Machine – YouTube
Nov10

Power Automate UI flows – The Ghost In The Machine – YouTube

UI Flows are a preview capability launched this week at Microsoft Ignite. They’re a robotic process automation capability that allows actions on desktop software or websites to be automated by Power Automate. In this video I go through the process of recording and automating a UI Flow using desktop software (Paint.Net). At the end I review some tips and tricks that I learned. You can download the Chromium browser (Chrome, new...

Read More
AI Builder – Built Before Your Eyes – YouTube
Oct21

AI Builder – Built Before Your Eyes – YouTube

Easy, accessible Artificial Intelligence with AI Builder is one of the newest and most exciting features of the Power Platform. In this video is an end to end demonstration of each of the five types of AI Builder models: • Business Card Reader • Binary Classification • Form Processing • Object Detection • Text Classification We are the CEOs of “Whoopee Incorporated” a business focusing in fine products like whoopee...

Read More
Tame Forms with Power Platform, Portals and AI – YouTube
Sep13

Tame Forms with Power Platform, Portals and AI – YouTube

Trying to move your organization to modern, mobile platforms like the Power platform, but weighed down by process that use paper and PDF forms? If you work in or with the government, you’re likely surrounded by paper and PDF forms: GSA has 800 electronic forms, DoD has 100,000. Rebuilding hundreds or thousands forms in a modern system isn’t always practical, in this session we’ll build a system that uses them to...

Read More