Unanswered

Disable Percentage Autocorrection or Conditional Statement to Multiple Percentage

(0) Share

Report

Posted on by radiosonicfan

Hello,

Need some advice. Currently have a SharePoint text field and collecting percentages.
Some users are most user are entering numbers (with percentage sign) and when someone puts a % sign after the number the PowerApp is autocorrecting it.

Example: 80 = 80%; If someone types 80% within the app autocorrects to 0.80.

Is there a way to disable that feature?

or allow someone to enter a number or if they enter % sign afterwards it gets multiply by 100.

Is there a way to build a conditional statement to encourage uniform data entry?

If Number then Number or if Percentage then multiply by 100.

Trying to minimize data entry errors. Since users may be entering data differently I want to make sure all get saved in similar format.

Thanks.

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

logixcrm 71 on at

Like (0)

Report

HI radiosonicfan

How are the users entering data, are they using a canvas app or a SP form?

Was this reply helpful? Yes No
Pstork1 68,707 Most Valuable Professional on at

Like (0)

Report

I don't think there is a way to disable the feature, but you could use an isMatch() regular expression to detect when the % sign is added and multiply the result by 100.

Was this reply helpful? Yes No
Verified answer

v-xiaochen-msft on at

Like (0)

Report
Hi @radiosonicfan ,

In addition, you could try the onchange property of textinput control to set a variable .

Set onchange property of textinput control to:

If("%" in TextInput1.Text,Set(Var,Trim(Left(TextInput1.Text,Find("%",TextInput1.Text)-1))),TextInput1.Text)

Best Regards,

Wearsky

Was this reply helpful? Yes No