web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate Action 'Create_HTML_ta...

Power Automate

Answered

Action 'Create_HTML_table' failed error received when the action is running successfully

(1) Share

Report

Report

Posted on by bchager6

132

Hi all,

I built a Flow that's working perfectly but I'm receiving the below error message regarding failed attempts at creating an HTML table. The Create HTML table action is running successfully though.

I narrowed it down to this item in my Parse JSON step

},

"[Standard_Deviation_on_Tasks_per_Week]": {

"type": "number"

},

and am handling it with this:

formatNumber(coalesce(item()?['Standard_Deviation_on_Tasks_per_Week'],'0','N1'))

but still receive the error.

Action 'Create_HTML_table' failed: The execution of template action 'Create_HTML_table' failed. The column values could not be evaluated: 'The template language function 'formatNumber' expects its first parameter to be an integer or a decimal number. The provided value is of type 'String'.

Categories:

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Verified answer

Michael E. Gernaey 53,960 Moderator on at

Like (1)

Report
Copy link

Link copied!
Hi @bchager6

Sorry I just have to say it... If it was working perfectly, you wouldn't have an error or be here 😉

A few things.

1. You formatting of the expression is incorrect check this out (and there are other issues)

You wrote So lets break this apart You making it look like the '0' and the 'N1' are part of the coalesce which is incorrect formatNumber( coalesce(item()?['Standard_Deviation_on_Tasks_per_Week'],'0','N1') ) It should be written like thi formatNumber( coalesce(item()?['Standard_Deviation_on_Tasks_per_Week'],'0'),'N1' ) Next you have another issue. formatNumber expects a number, but in your coalesce, if the property is blank you are passing a string of '0' instead of 0 Which means you need to use the int expression function to convert it to an actual number, before formatNumber gets it or return 0. Either way if the property isn't an int then you need to do this formatNumber( int(coalesce(item()?['Standard_Deviation_on_Tasks_per_Week'],'0')),'N1' ) or maybe its a decimal or something.

If I have helped you, I would really appreciate if you please Mark my answer as Resolved/Answered, and give it a thumbs up, so it can help others

Cheers

Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey

Was this reply helpful? Yes No
bchager6 132 on at

Like (0)

Report
Copy link

Link copied!

@FLMike Thanks for the info!

Was this reply helpful? Yes No

Join the conversation