Answered

How to manage Approvals MS Flow

(0) Share

Report

Posted on by Community Power Pla...

Hello,

In a list SharePoint item type Number, it appears correctly in SP list, ex: 400. Whilst in Approvals message it goes 400.000, how to remove the last 3 zeros?

All responses (7)

Answers (1)

Community Power Pla... on at

Like (0)

Report

Re: How to manage Approvals MS Flow

Hello @ScottShearer,
Community Power Pla... on at

Like (0)

Report

Re: How to manage Approvals MS Flow

Hello @v-yamao-msft,

Still doesn't work, for all the column of type calculated Number, i added :

but still doesn't work !

These changes are made in SharePoint not Flow right ?

Thanks
Community Power Pla... on at

Like (0)

Report

Re: How to manage Approvals MS Flow

Hello @v-yamao-msft,

Still doesn't work.
All the columns of type 'CalculatedNumber', i put in the code in the end :

but still doesn't work !
These changes are made in SharePoint not Flow right ?

Thanks
Verified answer

v-yamao-msft on at

Like (1)

Report
Re: How to manage Approvals MS Flow

Hi @Anonymous,

It seems that you are using SharePoint Calculated columns.

To remove zero after the number, please try the following way.

In the SharePoint list, column NumberCalculated is of type Calculated column. Without using a code to format the value, it will be displayed as 700.0000000 in the email body. To remove the 0 after the number, I have tried using the following code to get only the number before the ‘.’.

first(split(triggerBody()?['NumberCalulated'],'.'))

Please take a try with it.

Best regards,

Mabel
ScottShearer 25,208 Most Valuable Professional on at

Like (0)

Report

Re: How to manage Approvals MS Flow

@Anonymous:

Can you post a screen shot of the Column definiton from SharePoint please. I still can't seem to replicate your issue using a number column.

Scott
Community Power Pla... on at

Like (0)

Report

Re: How to manage Approvals MS Flow

This is the message for Approvals.
The real number in the SP list is 700. Only in the approval message appear the rest of the zeros.
So how i can remove the zeros after the 700 ?
ScottShearer 25,208 Most Valuable Professional on at

Like (0)

Report

Re: How to manage Approvals MS Flow

@Anonymous:

I am having trouble replicating your issue. Can you please post a screenshot of your column definition/configuration screen and of the Approval action?

Scott