cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Charles-v-D
Helper V
Helper V

Have Flow automatically add an Excel graph into an E-mail as picture

Hi all,

 

I have a daily flow running to inform my management op progress. Data resides in Excel and I'm able to build a nice HTML table inside a flow action "send e-mail". The excel file also contains a graph. Is there a way to also "paste" this picture into the same send e-mail action?

 

Any feedback is welcome!

 

Regards

Charles

 

8 REPLIES 8
RobElliott
Super User
Super User

@Charles-v-D the only way of achieving this would be by using the Microsoft Graph API. There's some info at

https://docs.microsoft.com/en-us/graph/api/resources/excel?view=graph-rest-1.0

Rob
Los Gallardos
If I've answered your question or solved your problem, please mark this question as answered. This helps others who have the same question find a solution quickly via the forum search. If you liked my response, please consider giving it a thumbs up. Thanks.

Hi @RobElliott ,

thanks for the pointer. Will investigate. Might have to come back to you as I'm pretty novice on this....

 

Regards

Charles

 

Hi
Let me see if I understood your requirements. You want to convert your "Create HTML table" output into an image and attach it when invoking 'Send an email', right?
If so, guess that means presenting it as a pdf is not valid workaround, but just in case, here you are some nice tricks from John Liu's Flow blog.
http://johnliu.net/blog/2017/10/generate-any-pdf-documents-from-html-with-flow
Hope this helps


Each time you click on any of our inspiring answers 'Thumb up' icon...
...an ewok scapes from the stormtroopers.

Be grateful, Thumbs up! Save the Galaxy for free!


Escribo sobre Power Automate en:
https://medium.com/anyone-can-automate/

Proud to be a Flownaut!



Hi @efialttes ,

 

I'm not trying to add a graph as attachment... I would like to embed the graph (picture) inside the body of the e-mail action....

Any chance this is possible?

 

Regards

Charles

 

Hi again

Haven't tried it myself, but the latests posts on this thread seem to be promising

This week I am unfortunately busy, but if a have the chance to test it, I will share the results here

Hope this helps

 



Each time you click on any of our inspiring answers 'Thumb up' icon...
...an ewok scapes from the stormtroopers.

Be grateful, Thumbs up! Save the Galaxy for free!


Escribo sobre Power Automate en:
https://medium.com/anyone-can-automate/

Proud to be a Flownaut!



Hi @Charles-v-D ,

 

I am trying to achieve something similar, want to send out emails with project dashboards created in excel. By any chance have you figured out to solution to do so in PowerAutomate. It would be of great help.

 

Thanks.

@Shradds  no I have not been able to resolve this.

 

Regards

charles

 

 

Hi, after a year did anybody find a solution for this?

 

I'm trying to recreate the same thing.

Helpful resources

Announcements
MPA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

PowerPlatform 768x460.png

Microsoft Learn

Check out our new Discover Your Career Path blog post series and get all the details.

Users online (1,084)