Answered

Using Power Automate to copy an Excel Range to the body of an email

(0) Share

Report

Posted on by MarkDan

I have a Flow that takes data from a MS Form and puts it into an Excel table. Within Excel there is another worksheet set out as a Form which looks up the latest set of data to display it as a more user friendly Form. I want the flow to be extended so that after writing the new data to the file it copies the fixed Range of the Form (including format) and pastes this into an Outlook email body to send (can paste as a picture or as cells).

I cannot work out how to do this. Would any one be able to help?

Categories:

General topics

All responses (3)

Answers (1)

Sort by

ScottShearer 25,331 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@MarkDan

I don't believe that you can do exactly what you want in the way that you have described using Power Automate. However, you might consider having Power Automate find the data that you want in your Excel table. Then insert that data into a formatted email. Here is a link to documentation on formatting emails.

The primary issue that you have is that Power Automate will only deal with Excel tables - it is not range aware. In addition, there is no way to copy/paste anything including formatting. You'll need to access the data that you want, insert it into an email and format the email.
Verified answer

ScottShearer 25,331 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

@MarkDan

I don't believe that you can do exactly what you want in the way that you have described using Power Automate. However, you might consider having Power Automate find the data that you want in your Excel table. Then insert that data into a formatted email. Here is a link to documentation on formatting emails.

The primary issue that you have is that Power Automate will only deal with Excel tables - it is not range aware. In addition, there is no way to copy/paste anything including formatting. You'll need to access the data that you want, insert it into an email and format the email.
MarkDan 17 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks for the tips once again 🙂