PAD Use Case: SQL to Excel to HTML Table to Email | Power Automate Desktop

Published: 09 July 2021
on channel: Dave The RPA Guy

9,428

170

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

Watch video PAD Use Case: SQL to Excel to HTML Table to Email | Power Automate Desktop online without registration, duration hours minute second in high quality. This video was added by user Dave The RPA Guy 09 July 2021, don't forget to share it with your friends and acquaintances, it has been viewed on our site 9,428 once and liked it 170 people.

7,130

306