Answered

Formatting HTML Table with Compose

(0) Share

Report

Posted on by AlineStoll

Hi all,

I'm using Power Automate to send some tables through email from PBI. My table has 4 columns and I would like to format third column to comma style and last column to percentage:

I'm using the compose with the following code:

Could someone please help me with it? I'm new in Power Automate and I am totally lost 😞

Categories:

General topics

I have the same question (0)

All responses (16)

Answers (3)

Mister_Shaik 1,008 on at

Like (0)

Report
Hi @AlineStoll ,

I'm assuming that you're passing your values to the compose action to build the table rows and append to a string or variable, in that case you a formatNumber expression to get your desired output.

Thousands separator or comma formatting:- formatNumber(#ValueHere, '###,###,###.##')
Percentage: formatNumber(#ValueHere, '00.00%')
Below is an example input and the result,
formatNumber(96845325, '###,###,###.##') 96,845,325
formatNumber(0.685523, '###,###,###.##') 68.55

You can refer below blog for a detailed guide on how this works and different ways of formatting,
https://mistershaik.com/number-formatting-in-power-automate-and-power-apps/

Hope this helps 🙂

Kind Regards,
Shaik Sha
________________________________________________________________________
If I have answered your question, please mark the post as Solved.
If you like my response, please give it a Thumbs Up.

Was this reply helpful? Yes No
Verified answer

AlineStoll 40 on at

Like (1)

Report

Hi Shaik,

Thank you very much for your help, but I was not successful doing it.
I am extracting my data from Power BI, maybe I am not doing something correct, let me explain to you my step to step:

Step 1: From PBI, I initialize a row number variable

Step 2: I initialized an HTML table

Step 3: I append to string variable

Step 4: I format number

Step 5: I sent to email

When I save show no errors, but when I run, the email is not sent to me. Could you please help me?

Thank you

Was this reply helpful? Yes No
AlineStoll 40 on at

Like (0)

Report

Maybe, I am doing the append to the HTML table incorrectly. Do you know how should I do it from PBI?

Was this reply helpful? Yes No
AlineStoll 40 on at

Like (0)

Report

Actually, now I am running and shows the following message:

Was this reply helpful? Yes No
AlineStoll 40 on at

Like (0)

Report

{
  "type": "object",
  "properties": {
    "rows": {
      "type": "array",
      "items": {
        "type": "object",
        "properties": {
          "entity": {
            "type": "object",
            "properties": {
              "Power BI values": {
                "title": "Power BI data",
                "type": "array",
                "items": {
                  "type": "object",
                  "properties": {
                    "SalesRep": {
                      "title": "Power BI data SalesRep",
                      "type": "string"
                    },
                    "MTD Bids #": {
                      "title": "Power BI data MTD Bids #",
                      "type": "number"
                    },
                    "MTD Bids $": {
                      "title": "Power BI data MTD Bids $",
                      "type": "number"
                    },
                    "MTD Bids C1": {
                      "title": "Power BI data MTD Bids C1",
                      "type": "number"
                    }
                  },
                  "required": []
                }
              }
            },
            "required": [
              "Power BI values"
            ]
          }
        },
        "required": [
          "entity"
        ]
      }
    }
  },
  "required": [
    "rows"
  ]
}

Was this reply helpful? Yes No
Verified answer

Mister_Shaik 1,008 on at

Like (0)

Report
Hi @AlineStoll ,

You need to do the number formatting inside the "Append to string variable" action, on the number fields that you have.

If you're planning to convert the "MTD Bids $" to a thousands separator format (e.g., $ 123,456,789.12), then the formula would look something like this,

formatNumber(items('Apply_to_each')?['MTD Bids $'],'$ ###,###,###.##')

You can change the expression based on the inputs and the format you want.

Also, if you're planning to send large amounts of emails every day, then I'd suggest you to use the Outlook send email action rather than the Mail connector, as it has low threshold for throttling, below is the throttling limits for Mail actions,

Kind Regards,
Shaik Sha
________________________________________________________________________
If I have answered your question, please mark the post as Solved.
If you like my response, please give it a Thumbs Up.

Was this reply helpful? Yes No
AlineStoll 40 on at

Like (0)

Report

Thank you @Mister_Shaik , helped me a lot. I just have an additional question:

I need to attach three different HTML tables in the same email, but when I create the flow to develop second HTML, when I save it, and apply, when I come back Power Automate delete it. Do you know how can I fix it?

When I try to create Table HTML 2, the system deletes it.

Can you please help me? Thank you.

Was this reply helpful? Yes No
Mister_Shaik 1,008 on at

Like (1)

Report

Hi @AlineStoll ,

Can you clarify what you mean by delete?

After you generate the HTML Table - are you saving it to some location or sending it out in the email?

Can you please provide how the second HTML table is coming into picture, as I can only see one table being created in the flow screenshot

Kind Regards,
Shaik Sha

Was this reply helpful? Yes No
AlineStoll 40 on at

Like (0)

Report

Hi @Mister_Shaik ,

I did the following flow, but when I save and run, and come back again to the page, it disappear and I cannot attach the second table. Could you please help me?

Was this reply helpful? Yes No
AlineStoll 40 on at

Like (0)

Report

In reality @Mister_Shaik I don't know how to prepare the second HTML table. Is it correct?

Thanks

Was this reply helpful? Yes No