What @trice602 has explained would work in Power Automate cloud flows. But for Desktop flows it's a bit trickier.
In order to add it to an Outlook email like that, you need the table to be formatted as an HTML table. And there is no native way to convert a simple data table in PAD to an HTML table.
There are essentially two ways to do what you want:
- Copy the table from Excel via Copy cells from Excel worksheet and then paste it into Outlook via using Send keys and trying to automate the UI of Outlook (not recommended)
- Read data as a table via Read from Excel worksheet and then creating your own HTML table, and putting it into the body of the email. I have described the correct way to do that in an earlier post. You can find my reply here: Copy Excel table by some rules, and paste to outlo... - Power Platform Community (microsoft.com)
-------------------------------------------------------------------------
If I have answered your question, please mark it as the preferred solution. If you like my response, please give it a Thumbs Up.
I also provide paid consultancy and development services using Power Automate. If you're interested, DM me and we can discuss it.
