Answered

Trying to format a number within an "Append to Array" action

(0) Share

Report

Posted on by Gilles12

150

Hello. I am stuck trying to format an amount in an array to will be populated in repetitive rows of a word template. This formating works well for columns in the header (non repetitive), but for the repetitive rows it does not work either in the "Append to Array" action (first image),

or if I insert a Compose action to do the formatting before (second image with error message at the top).

Thanks if ever you have an idea or the solution...

Categories:

General topics

All responses (3)

Answers (1)

Sort by

Verified answer

Matthy79 4,188 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

You have to use expressions (next to dynamic content) to use formatnumber. If you just type the formula that way it will be recognized as normal text and this breaks the json.

And it will be much better to use a select action instead of „apply to each“ and append to array.
Gilles12 150 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks, yes sorry I did not mention that I tried with an expression as well initially, similarly to what I have done for the total invoice in the footer. But for the line items I was still getting the error message (see image), and I don't understand why it fails in the template population, while the normal columns (in green) are recognized, so why it does not accept expressions (the flow works well without)... I will try with the Select action, thanks for the heads up!
Gilles12 150 on at

Like
a
(1)

Report
Copy link

Link copied!

The Select action worked very well, thank you very much!