cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper IV
Helper IV

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

 

7 REPLIES 7
Highlighted
Super User III
Super User III

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

Highlighted

Hi @RobElliott ,

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

 

Regards

Charles

 

Highlighted

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!



Highlighted

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

 

Highlighted

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!



Highlighted

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.

Highlighted

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

 

Regards

charles

 

 

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

Users online (12,063)