web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

Welcome to the Power Platform Communities
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Copy Excel Range as Im...
Power Automate
Unanswered

Copy Excel Range as Image and Send in email body

(1) ShareShare
ReportReport
Posted on by andrea4 2

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)
  • Ed Gonzales Profile Picture
    Ed Gonzales 4,531 Most Valuable Professional on at

    @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 Profile Picture
    VictorIvanidze 13,079 on at

    Hi @andrea4 

    I doubt you can do this using flow. 

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

  • Community Power Platform Member Profile Picture
    Community Power Pla... Microsoft Employee on at

    Hi Andrea4,

     

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

     

    Thank you,

  • Yutao Huang Profile Picture
    Yutao Huang Microsoft Employee on at

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

  • pwintwaiphyu Profile Picture
    pwintwaiphyu 6 on at

    Hi Meleu,

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

     

    Thank you

  • vimukthi7262 Profile Picture
    vimukthi7262 5 on at

    Hi all,

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

     

  • Community Power Platform Member Profile Picture
    Community Power Pla... Microsoft Employee on at

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

  • Yutao Huang Profile Picture
    Yutao Huang Microsoft Employee on at

    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!

  • jrnieby20 Profile Picture
    jrnieby20 2 on at

    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:

    jrnieby20_0-1677103758425.png

    How it should look like:

    jrnieby20_1-1677103831380.png


    Can you please help me with this?

     

     

  • Yutao Huang Profile Picture
    Yutao Huang Microsoft Employee on at

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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the February Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
David_MA Profile Picture

David_MA 250 Super User 2026 Season 1

#2
Expiscornovus Profile Picture

Expiscornovus 222 Most Valuable Professional

#3
Haque Profile Picture

Haque 174

Last 30 days Overall leaderboard

Featured topics

Share your ideas and struggles with building Power Automate flows!
Survey: Power Automate mobile app
How to Ask for Help with Your Power Automate Workflow
Flows are not visible for users who sign in with their personal accounts
Start and wait for an approval action
Restore a deleted flow
List of actions cheat sheet for Power Automate Desktop
Question for everyone : How are you using Create Text GPT in AI Builder?
Welcome to the Power Automate forum!

Product updates

Microsoft Power Platform Community release plans