PAD Use Case: SQL to Excel to HTML Table to Email | Power Automate Desktop
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
Смотрите видео PAD Use Case: SQL to Excel to HTML Table to Email | Power Automate Desktop онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь Dave The RPA Guy 09 Июль 2021, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 9,428 раз и оно понравилось 170 людям.