Unanswered

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?

Categories:

Using flows

I have the same question (0)

All responses (7)

Answers (1)

ScottShearer 25,270 Most Valuable Professional on at

Like (0)

Report

@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

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

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 ?

Was this reply helpful? Yes No
ScottShearer 25,270 Most Valuable Professional on at

Like (0)

Report

@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

Was this reply helpful? Yes No
Verified answer

v-yamao-msft on at

Like (1)

Report
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

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

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

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

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

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Hello @ScottShearer,

Was this reply helpful? Yes No