Add Bullet Points to collections from power apps and send it via outlook

[Afroj7]

Hi, 

I have created a flow which triggers when a button in power apps clicked and then power apps will send five different collections to power automate which I will be sending as an email in power automate after formatting it.

The flow I created is 

 Like this I have created HTML table for four collections and combined them with compose using this formula :

concat('Hi,<br><br>','Project Name: ', trim(replace(variables('Table5HTML'), '<th>ProjectName</th>', '')),'<br><br>','General Discussion',replace(variables('Table1HTML'), '<th>Title</th>', ''), '<br><br>','Cab Request',replace(replace(variables('Table2HTML'), '<th>Description</th>', ''), '<th>Title</th>', ''), '<br><br>','Deployment',replace(replace(variables('Table3HTML'), '<th>Description3</th>', ''), '<th>Title3</th>', ''), '<br><br>','Risk Any',replace(variables('Table4HTML'), '<th>Title4</th>', '')).

The output of this flow looks like this :

General Points:

General Points 1

General Points 2

Cab Request:

sample Desc: Cab 1

Sample desc: 2  Cab 2

Deployment:

sample demo: Deployemnt 1

sample demo 2: Deployment 2

Risk Any:

 Risk1

risk 2

But I want the records to be formatted with bullet points like this :

General Discussion

• General Points 1
• General Points 2

Cab Request

• sample Desc: Cab 1
• Sample desc: 2  Cab 2

Deployment

• sample demo: Deployemnt 1
• sample demo 2: Deployment 2

Risk Any

• Risk1
• risk 2

Is it possible to add bullet points in the flow. Please help me with this.

[SudeepGhatakNZ]

You should just enclose the Sub headings inside a <li> tag. Wouldn't that work?

[Afroj7]

Hi @SudeepGhatakNZ ,

I tried with <li> tag in the replace function like this concat(
'Hi,<br><br>',
'Project Name:', replace(variables('Table5HTML'), '<th>ProjectName</th>', ''), '<br><br>',
'General Discussion<br>',
'<ul>',
replace(replace(variables('Table1HTML'), '<th>Title</th>', ''), '<tr>', '<li>'),
'</li>',
'</ul><br><br>',
'Cab Request<br>',
'<ul>',
replace(replace(variables('Table2HTML'), '<th>Description</th>', ''), '<th>Title</th>', ''), '<li>',
'</li>',
'</ul><br><br>',
'Deployment<br>',
'<ul>',
replace(replace(variables('Table3HTML'), '<th>Description3</th>', ''), '<th>Title3</th>', ''), '<li>',
'</li>',
'</ul><br><br>',
'Risk Any<br>',
'<ul>',
replace(variables('Table4HTML'), '<th>Title4</th>', ''), '<li>',
'</li>',
'</ul>'
)

but the result is just replacing the table row with bullet point.

Am I placing the tag in wrong side please guide so that the <th> will be removed and bullet points be applied to each row 

[SudeepGhatakNZ]

If you share the trigger inputs, I will try at my end.

[Afroj7]

Hi @SudeepGhatakNZ ,

I am sending the collections from power apps to power automate and below is the screenshot for the same:

and am taking four text boxes as parameters in the flow  

and for creating HTML tables for 4 collections am using this formula inside the create html table action : 

json(triggerBody()['text']). I hope this information will help solve my problem. Thank you for your continues support and suggestions

[SudeepGhatakNZ]

Thanks.  I get that.

What I need is the trigger body value which you can get from an executed flow run, so that I have the data to work with 

[Afroj7]

Here it is :

{

    "schema": {

        "type": "object",

        "properties": {

            "text": {

                "title": "Input",

                "type": "string",

                "x-ms-dynamically-added": true,

                "description": "Please enter your input",

                "x-ms-content-hint": "TEXT"

            },

            "text_1": {

                "title": "Input 1",

                "type": "string",

                "x-ms-dynamically-added": true,

                "description": "Please enter your input",

                "x-ms-content-hint": "TEXT"

            },

            "text_2": {

                "title": "Input 2",

                "type": "string",

                "x-ms-dynamically-added": true,

                "description": "Please enter your input",

                "x-ms-content-hint": "TEXT"

            },

            "text_3": {

                "title": "Input 3",

                "type": "string",

                "x-ms-dynamically-added": true,

                "description": "Please enter your input",

                "x-ms-content-hint": "TEXT"

            },

            "text_4": {

                "title": "Input 4",

                "type": "string",

                "x-ms-dynamically-added": true,

                "description": "Please enter your input",

                "x-ms-content-hint": "TEXT"

            }

        },

        "required": [

            "text",

            "text_1",

            "text_2",

            "text_3",

            "text_4"

        ]

    }

}

[Afroj7]

  "body": {

        "text": "[{\"Title\":\"good points 1\"},{\"Title\":\"Good Points 2\"},{\"Title\":\"Good Points 3\"}]",

        "text_1": "[{\"Description\":\"\",\"Title\":\"\"}]",

        "text_2": "[]",

        "text_3": "[{\"Title4\":\"Title for risk\"},{\"Title4\":\"title for risk 2\"},{\"Title4\":\"title for risk 3\"}]",

        "text_4": "afroj Projet"

    }

[SudeepGhatakNZ]

How is the above text expected to render? Like  this?

Title:

• good points 1
• good points 2
• good points 3

Title 4:

• Title for risk
• Title for risk 2
• Title for risk 3

[Afroj7]

Hi @SudeepGhatakNZ ,

Yes exactly but the Title should be removed or replaced that's why am using this replace(replace(variables('Table1HTML'), '<th>Title</th>', ''). Rest should be same.

Thank you!

[SudeepGhatakNZ · Accepted solution]

See this

Expression is : 

replace(replace(body('Create_HTML_table'),'&lt;','<'),'&gt;','>')

[Afroj7]

The bullet points are coming but not as expected the result is like this 

[{"Title":"good points 1"},{"Title":"Good Points 2"},{"Title":"Good Points 3"}]

·  [{"Title":"good points 1"},{"Title":"Good Points 2"},{"Title":"Good Points 3"}]

·  [{"Title":"good points 1"},{"Title":"Good Points 2"},{"Title":"Good Points 3"}]

·  [{"Title":"good points 1"},{"Title":"Good Points 2"},{"Title":"Good Points 3"}]

I want to remove the top row as I don't want it and Title should be removed .Can you please tell me how can I format this.

Thank you.

[SudeepGhatakNZ]

What is the output of your Create HTML?

What is the output of the email?

[Afroj7]

The output of create HTML is : 

{

    "body": "<table><thead><tr><th>[{&quot;Title&quot;:&quot;good points 1&quot;},{&quot;Title&quot;:&quot;Good Points 2&quot;},{&quot;Title&quot;:&quot;Good Points 3&quot;}]</th></tr></thead><tbody><tr><td>&lt;li&gt;[{&quot;Title&quot;:&quot;good points 1&quot;},{&quot;Title&quot;:&quot;Good Points 2&quot;},{&quot;Title&quot;:&quot;Good Points 3&quot;}]&lt;/li&gt;</td></tr><tr><td>&lt;li&gt;[{&quot;Title&quot;:&quot;good points 1&quot;},{&quot;Title&quot;:&quot;Good Points 2&quot;},{&quot;Title&quot;:&quot;Good Points 3&quot;}]&lt;/li&gt;</td></tr><tr><td>&lt;li&gt;[{&quot;Title&quot;:&quot;good points 1&quot;},{&quot;Title&quot;:&quot;Good Points 2&quot;},{&quot;Title&quot;:&quot;Good Points 3&quot;}]&lt;/li&gt;</td></tr></tbody></table>"

}

The output of email is :

<p><br>
<table><thead><tr><th>[{&quot;Title&quot;:&quot;good points 1&quot;},{&quot;Title&quot;:&quot;Good Points 2&quot;},{&quot;Title&quot;:&quot;Good Points 3&quot;}]</th></tr></thead><tbody><tr><td><li>[{&quot;Title&quot;:&quot;good points 1&quot;},{&quot;Title&quot;:&quot;Good Points 2&quot;},{&quot;Title&quot;:&quot;Good Points 3&quot;}]</li></td></tr><tr><td><li>[{&quot;Title&quot;:&quot;good points 1&quot;},{&quot;Title&quot;:&quot;Good Points 2&quot;},{&quot;Title&quot;:&quot;Good Points 3&quot;}]</li></td></tr><tr><td><li>[{&quot;Title&quot;:&quot;good points 1&quot;},{&quot;Title&quot;:&quot;Good Points 2&quot;},{&quot;Title&quot;:&quot;Good Points 3&quot;}]</li></td></tr></tbody></table><br>
<br>
<br>
</p>

[Afroj7]

Hi @SudeepGhatakNZ ,

It's working now I had to re-check and I found while mapping the data in select action I was mapping the entire output of the compose action . Corrected it to map the respective column. 

Thanks for you help. Learnt a new thing with your help and suggestions.

Thank you 😊