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

[Charles-v-D]

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

[RobElliott]

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

[Charles-v-D]

Hi @RobElliott ,

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

Regards

Charles

[efialttes]

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

[Charles-v-D]

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

[efialttes]

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

[Shradds]

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.

[Charles-v-D]

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

Regards

charles