In this video, I use a suggestion given in a comment on a previous PAD video to try building out a use case in Power Automate Desktop that involves querying SQL Server for some data, placing that data into Excel, then taking that data from Excel, converting the datatable into a HTML Table, and then sending it in an HTML-enabled email from Outlook.
---------------------------------------------------------------------------------------------------------
Power Automate Desktop Version 2.10.36.21161
Windows 10 Pro
SQL Server 2019
SQL Server Management Studio
---------------------------------------------------------------------------------------------------------
  / davemorrisatl  
---------------------------------------------------------------------------------------------------------
00:00 Introduction
01:08 Overview of what I intend to build
02:07 Create all the Subflows that we’ll need
04:31 Build Subflow for Query SQL Server
08:29 Build Subflow for Write To Excel
15:53 Build Subflow for Read From Excel
20:10 Build Subflow for Convert DataTable to HTML Table
33:36 Build Subflow for Send HTML Email
34:46 Final End-to-End Test and Closing remarks