cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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

 

7 REPLIES 7
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

 

 

Helpful resources

Announcements
Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

New Super Users

Meet the Power Automate Super Users!

Many congratulations to the Season 1 2021 Flownaut Crew!

Microsoft Ignite

Microsoft Power Platform: 2021 Release Wave 1 Plan

Power Platform release plan for the 2021 release wave 1 describes all new features releasing from April through September 2021.

MPA Community Blog

Power Automate Community Blog

Check out the community blog page where you can find valuable learning material from community and product team members!

Users online (42,716)