Send Results from SP List with Chart

(0) Share

Report

Posted on by Yerlasdutco

118

Hi Folks,

Could you please help me with this implementation?!

I have PowerApps application, where User can pass the test and can receive the result for the 4 criteria (1-5). This result will save in SP list and Power Automate sends mail with this results like this:

Dear Nassen Yerlan,
Thank you for completing the We Lead Self-Assessment!
Please see your details below:

Assessment Role: 3
Align and Inspire: 5
Build Relationships: 2
Grow Capabilities: 4
Deliver Results: 3

Now I need to add to this text the chart, like this:

How can I implement it?

Categories:

General topics

I have the same question (0)

All responses (5)

Answers (1)

Verified answer

DamoBird365 8,942 Microsoft Employee on at

Like (3)

Report
Copy link

Link copied!

Hi @Yerlasdutco,

I've not tried this in live or across email clients but you could try SVG or alternatively create the charts as images using Excel.

For an SVG, you could create something like follows:

The sample SVG is:

<img src="data&colon;image/svg+xml,%3Csvg xmlns='http://www.w3.org/2000/svg' height='100' width='100' viewBox='0 0 20 20'%3E%3Ccircle r='10' cx='10' cy='10' fill='white' /%3E%3Ccircle r='5' cx='10' cy='10' fill='transparent' stroke='red' stroke-width='10' stroke-dasharray='calc(THENUMBER * 31.4 / 5) 31.4' transform='rotate(-90) translate(-20)' /%3E%3Ccircle r='5' cx='10' cy='10' fill='blue'/%3E%3Ctext x='8.5' y='11.5' font-size='0.3em' fill='yellow'%3ESOMETEXT%3C/text%3E%3C/svg%3E" />

and I have made this dynamic by replacing SOMETEXT and THENUMBER with dynamic values 1->5 from a compose. In my example my compose is a 4 and I can output the following:

You could colour code your rings and supply dynamic values as you see fit.

I found this site: SVG to Data URI encoder (heyallan.github.io) and SVG Pie Chart - Step 5: Clean Up the Code (codepen.io) useful when building a POC.

For the Excel version, if you can create the charts you require manually in excel, you can do the same with excel office scripts. Take a look here https://youtu.be/WUIOHm9-SRA

Damien

Was this reply helpful? Yes No
Yerlasdutco 118 on at

Like (0)

Report
Copy link

Link copied!

@DamoBird365

I tried it, but received this:
and there is my html

Was this reply helpful? Yes No
DamoBird365 8,942 Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Yerlasdutco

Your screenshot seems to show that Outlook blocked the image. Can you click on that warning and display the image?

Damien

Was this reply helpful? Yes No
rubenVdk 13 on at

Like (0)

Report
Copy link

Link copied!

Hi @Yerlasdutco
Did you figure this one out? I'm also stuck here.

Was this reply helpful? Yes No
Yerlasdutco 118 on at

Like (0)

Report
Copy link

Link copied!

Yes, solution from @DamoBird365 working well

Was this reply helpful? Yes No