Answered

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)

Sort by

logixcrm 71 on at

Like
a
(0)

Report
Copy link

Link copied!

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 69,623 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

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 Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
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