Copy Excel Range as Image and Send in email body

[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!!

[edgonzales]

@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.

[VictorIvanidze]

Hi @andrea4 

I doubt you can do this using flow. 

Consider creating an Excel macro or add-in to do that.

[meleu]

Hi Andrea4,

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

Thank you,

[Yutao]

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).