Copy Excel Range as Image and Send in email body

(1) Share

Report

Posted on by andrea4

Hello,

we have a report in Excel that is generated automatically and saved in OneDrive.

We'd like to create a Flow to automatically copy a range from the Excel file, with its formatting, and paste it as picture within a email body.

Currently this is done manually opening the file, copying and pasting as image...

Is there a way to achieve this?

Thanks!!

Categories:

General topics

I have the same question (0)

All responses (14)

Answers (0)

Ed Gonzales 4,531 Most Valuable Professional on at

Like (0)

Report

@andrea4

Hi there. So I know this wasn't the original scope, but I wanted to share a possible alternative...

Rather than trying to automate a screen capture, perhaps consider pushing the report through a different method. Power BI, as an example, allows users to subscribe to reports and dashboards and get regular updates. Here's a link to that:

Subscribe yourself and others to reports and dashboards in the Power BI service

If your scope doesn't allow for that kind of flexibility, then maybe a UI Flow? Not sure...but my suggestion is to chase this upstream to see if you can change the reporting behavior a tiny bit to make it more accessible.

Keep us posted.

-Ed

If you liked this reply, please give it a thumbs up! If this reply has answered your question or resolved your challenge, please consider marking it as a Solution. This helps other users find it more easily via search.

Was this reply helpful? Yes No
VictorIvanidze 13,073 on at

Like (0)

Report

Hi @andrea4
I doubt you can do this using flow.
Consider creating an Excel macro or add-in to do that.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Hi Andrea4,

Did you find the solution? I have the same question as yours. 😞

Thank you,

Was this reply helpful? Yes No
Yutao Huang Microsoft Employee on at

Like (0)

Report

If you are interested, I have posted an solution to a similar question here: Re: Create flow from Excel and adding image/table - Power Platform Community (microsoft.com).

Was this reply helpful? Yes No
pwintwaiphyu 6 on at

Like (0)

Report

Hi Meleu,
did you find the solution? if yes, can you please share the way you did?

Thank you

Was this reply helpful? Yes No
vimukthi7262 5 on at

Like (0)

Report

Hi all,
Did you find the solution? I have the same question as yours.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (1)

Report

Unfortunately, no.
I end up attaching JPG in my email body instead.

Was this reply helpful? Yes No
Yutao Huang Microsoft Employee on at

Like (1)

Report

Hello @Anonymous , @vimukthi7262 , @pwintwaiphyu ,

I'm wondering if you have had a chance to try Office Scripts (with the "Run script" action of the "Excel Online (Business)" connector in Power Automate), as I explained in this post: Re: Create flow from Excel and adding image/table - Power Platform Community (microsoft.com). By using this approach, you should be able to copy the range as an image and include it in the email body to send out.

Feel free to reach out to me if you have any further questions!

Was this reply helpful? Yes No
jrnieby20 2 on at

Like (0)

Report

Hello @Yutao, I tried the script and had run it successfully. However, the converted image seems cannot wrap some text in a cell unlike how it is wrapped in the excel.

Result:

How it should look like:

Can you please help me with this?

Was this reply helpful? Yes No
Yutao Huang Microsoft Employee on at

Like (0)

Report

@jrnieby20 Sorry unfortunately this has been a known issue and we don't have a good solution yet 😢. I'll share any future update in this thread. ~~But for now, we'll probably have to work around it by manually adjusting the width of the cell or inserting line breaks.~~ Thanks for your patience!

[UPDATE]
Unfortunately, it turned out manually inserting line breaks is not a valid workaround. Apologize for the misinformation earlier.

Was this reply helpful? Yes No