Submit Percentage Values to SharePoint List Number Column with 2 Decimal Places

(0) Share

Report

Posted on by rameshmukka

1,113

Hello Power Users,

I have below form and I am calculating percentage dynamically and submitting to SharePoint list. In SharePoint list, I have column PercentageValue (number type, 2 decimals and show as percentage) and I have used below formula in Text field of Power Apps.

Value(Text(DataCardValue2.Text/DataCardValue3.Text*100,"[$-en]#.00"))

After I submit, the value I am expecting in SharePoint is like #.##% but what it shows is ####.00%. I have taken another text column PercentageText and used below formula in Power Apps. It does show the right value #.##. But I would like to have it number field with desired output format #.##%. Where am I doing wrong?

Text(DataCardValue2.Text/DataCardValue3.Text*100,"[$-en]#.00")

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

mdevaney 29,989 Moderator on at

Like (0)

Report

Re: Submit Percentage Values to SharePoint List Number Column with 2 Decimal Places

@RameshMukka
I don't think your formula is the issue here. Instead its a problem with your column settings in the SharePoint list. You must set the decimal places setting to '2' as opposed to 'Automatic'.

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

Was this reply helpful? Yes No
rameshmukka 1,113 on at

Like (0)

Report

Re: Submit Percentage Values to SharePoint List Number Column with 2 Decimal Places

I have actually put the same as I mentioned in my question, that is 2 decimal places. It didn't help me.

Was this reply helpful? Yes No