resolving two decimal point for create csv table action

[Anonymous]

Hi,

In a flow, I am using below actions:

1. Get items from a list

2. create csv table using values from above action with custom headers

3. Create a file in sharepoint with .csv extension and data coming from action 2.

Now I have two number fields: debit and credit and I want to make sure that they show only two decimal places but it does not seem to be working ootb. So I want 3.457 to resolve as 3.46 as an example. Can someone please help me with the formula i can use to limit to 2 decimal places.

thanks.

[Anonymous]

yeah for some reason its failing still for amount 17.575, not sure why and works for 9.775 and resolves as 9.78 @DeepakS 

[DeepakS]

Hi @Anonymous Can you share the expression that you using?

[Anonymous]

Sure, see below

if(contains(string(item()?['Amount']),'.'),if(contains('56789',
substring(string(item()?['Amount']),
add(length(split(string(item()?['Amount']),'.')[0]),3),1)),
substring(string(add(item()?['Amount'],0.01)),0,
add(length(split(string(item()?['Amount']),'.')[0]),3)),
substring(string(item()?['Amount']),0,
add(length(split(string(item()?['Amount']),'.')[0]),3))),string(item()?['Amount']))

[Anonymous]

@yashag2255  thanks for sharing. It is unclear from the screenshot what actions you are using and the expressions as well, can you please help me with the expression that I can use in my use case.

[v-bacao-msft]

Hi @Anonymous ,

Has your issue been resolved? According to the newly added Format Number function, you can refer to the following functions to achieve your needs.

• Initialization variables are used to store data that needs to be presented in a CSV table.
• Iterate over the items and use the Format Number action to format the value of the Number field.
• Then append the fields that need to be displayed in the CSV table to the array variables.
• Finally, configure the CSV table with variables.

Image reference:

Hope this helps.

Best Regards,

[Anonymous · Accepted solution]

Thanks to all for helping and sharing your ideas @v-bacao-msft  @DeepakS  @yashag2255  @edgonzales . 

After spending some time and research, I ended up getting the solution, used formula below as an expression and it worked great. Below expression limits to two decimal points and rounds up great as well.

formatNumber(item()?['Amount'],'N','en-US')