web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Add Bullet Points to c...
Power Automate
Answered

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

(0) ShareShare
ReportReport
Posted on by

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 

Afroj7_0-1693361981409.pngAfroj7_1-1693362141382.png

 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.

Categories:
  • SudeepGhatakNZ Profile Picture
    14,396 Most Valuable Professional on at

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

     

     

  • Afroj7 Profile Picture
    on at

    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 Profile Picture
    14,396 Most Valuable Professional on at

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

     

     

  • Afroj7 Profile Picture
    on at

    Hi @SudeepGhatakNZ ,

     

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

    Afroj7_0-1693382155480.png

    and am taking four text boxes as parameters in the flow  

    Afroj7_1-1693382298611.png

    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 Profile Picture
    14,396 Most Valuable Professional on at

    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 Profile Picture
    on at

    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 Profile Picture
    on at
      "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 Profile Picture
    14,396 Most Valuable Professional on at

    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 Profile Picture
    on at

    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!

  • Verified answer
    SudeepGhatakNZ Profile Picture
    14,396 Most Valuable Professional on at

    See this

     

    SudeepGhatakNZ_0-1693453992899.png

     

    SudeepGhatakNZ_2-1693454131385.png

     

     

     

    SudeepGhatakNZ_1-1693454020694.png

     

    Expression is : 

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

     

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Leaderboard > Power Automate

#1
Mohsin Ali Profile Picture

Mohsin Ali 377

#2
11manish Profile Picture

11manish 302 Super User 2026 Season 2

#3
Henil Profile Picture

Henil 130

Last 30 days Overall leaderboard