Number formatting for HTML in power automate with power BI input

(0) Share

Report

Posted on by gujralh

Hello,

I'm looking for some help on below issue,

When I am doing number format by selecting the input from power BI values directly, flow is giving below error. And when am using the same after "Run a query against a dataset" , Number formatting done without an error.

So please help me how can I do the number formatting by using below inputs -

"inputs": {

"from": "@triggerBody()?['entity']?['Power BI values']",

"select": {

"Decimal": "@item()?['LTE_KPI_Cells_Daily[D_ACC%(C)]']",

"DecimalFormat": "@formatNumber(Float(item()?['LTE_KPI_Cells_Daily[D_ACC%(C)]']),'0.00')"

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (2)

SudeepGhatakNZ 14,394 Most Valuable Professional on at

Like (1)

Report
@gujralh

Try this expression

formatNumber(coalesce(float(item()?['LTE_KPI_Cells_Daily[D_ACC%(C)]']), 0),'0.00')

Was this reply helpful? Yes No
gujralh 29 on at

Like (0)

Report

Thanks @SudeepGhatakNZ
I tried the same but getting the error with this too.

Additional info - when am trying the flow without formatting, it is getting success but I need to do the formatting as well

Was this reply helpful? Yes No
Verified answer

SudeepGhatakNZ 14,394 Most Valuable Professional on at

Like (1)

Report
@gujralh ,

Is there a value that is either string or null?

Try this expression

formatNumber(float(coalesce(item()?['LTE_KPI_Cells_Daily[D_ACC%(C)]'], 0)), '0.00')

Was this reply helpful? Yes No
Verified answer

gujralh 29 on at

Like (2)

Report

Thanks @SudeepGhatakNZ , I got it. There were blank values coming for power BI values when using
item()?['LTE_KPI_Cells_Daily[D_ACC%(C)]']. After changing to "item()?['D_ACC%(C)']" and doing formatting, it is getting success with all conversion method.

Thanks once again for helping in identifying the issue.

"inputs": {
        "from": "@triggerBody()?['entity']?['Power BI values']",
        "select": {
            "Decimal": "@item()?['D_ACC%(C)']",
            "DecimalFormat": "@formatNumber(float(coalesce(item()?['D_ACC%(C)'], 0)), '0.00')",
            "DecimalFormat2": "@formatNumber(float(item()?['D_ACC%(C)']), '0.00')"

Was this reply helpful? Yes No