cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
vig_2909
Frequent Visitor

How to create charts using microsoft power automate ( Data feed from sharepoint)? Chart has to be embedded in the mail body

How to create charts using microsoft power automate ( Data feed from sharepoint)? Chart has to be embedded in the mail body

4 REPLIES 4
DamoBird365
Microsoft
Microsoft

Hi @vig_2909 

 

If you are looking to create pie, bar or line charts, it's possible to do this via office scripts if you load the data into Excel.  Take a look at this guide Awesome! Create Charts via Office Scripts - DamoBird365

 

If you have any questions, please let me know.

 

Damien

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Cheers,
Damien


P.S. take a look at my new blog here and like & subscribe to my YouTube Channel thanks 😉

vig_2909
Frequent Visitor

Hey Damein 

Thanks for replying

I am not able to get the image or chart and table in flow.

 

 

 

 

 

 

 

Hi @vig_2909 

 

You'll have to give me a bit more detail, I do not understand.

 

Damien

@DamoBird365 

Thanks a lot for taking the time to reply 

Board noDate C1 C2C3C4C5C6C7C8C9C10C11C12C13C14C15C16C17C18D1D2D3Occurance Occurance WeightatgeEqpRework Index RI=(P/Q)*100Inspected ByOccur without C9 & C14Occur  weightagewithout C9 & C14Inspected quantityAssembly contribution to rework indexDiffernece SUMOccuarnce with PWD C9Pwd contribution to reworkOccuarnce with fab C14Fab contribution to reworkSum2SUM3Vendor TargetAssembly DPMOPowder coating DPMOFabrication DPMOTARGET2

SYBJ9697/8/20210.000.000.000.000.000.000.000.000.000.004.001.000.002.000.000.000.003.004.002.000.0016.0010.0010.00100.00Tamil1019.008.0010.0080.0020.00100.000.000.002.0020.00100.00100.00S370.0026666.670.006666.6720000.00
SYCE4547/8/20210.000.000.000.000.000.001.000.000.001.003.002.000.003.002.002.000.000.005.000.000.0019.0016.0019.1683.51Tony667.0013.0019.1667.8515.6683.510.000.003.0015.6683.5183.51Simser70.0022616.560.005219.2120000.00
SYNJ6137/14/20210.000.000.000.000.000.000.000.002.000.006.001.001.000.003.001.000.000.002.005.000.0021.0020.006.00333.33SVB651.0016.006.00266.6766.67333.334.0066.670.000.00333.33333.33Neuro70.0088888.8922222.220.0020000.00
SYBJ9707/15/20210.000.000.000.000.000.000.000.001.001.001.000.000.001.001.000.000.002.001.002.000.0010.009.0010.0090.00Tamil632.006.0010.0060.0030.0090.002.0020.001.0010.0090.0090.00S370.0020000.006666.673333.3320000.00

 

This is a sample table.

I have a filter based on the process owner ( which I have done with the code). After filtering is not able to set the table range dynamically.

 

In Addition after filtering, i have to sum up all the column values before capturing the image.

Summed up the value of 3 columns should be shown in the stacked column chart. The chart should have 3-month data.

 

Is it possible to do in scripts?

 

Run Script damenin doubt_pages-to-jpg-0001.jpg

Run Script damenin doubt_pages-to-jpg-0002.jpg

Run Script damenin doubt_pages-to-jpg-0003.jpg

   

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (5,780)