Unanswered

Issue with PowerApps Edit form allowing special characters in number column

(0) Share

Report

Posted on by Mayankk1H

Hello PowerApps community,

I'm encountering an issue with an Edit form in PowerApps. I have a column named "Study Number" with a data type set to "Number." However, despite specifying the data type as a number, the form is allowing the entry of special characters such as the '%' symbol in the "Study Number" column.

Additionally, I'd like to mention that in the backend, in the Dataverse table, the "Study Number" column has a data type of "Single Line of Text."

Is there a way to restrict the input to only accept numeric values and prevent the entry of special characters like '%' in a number column within an Edit form, while considering the backend data type? Any insights or suggestions on how to resolve this issue would be greatly appreciated.

Thank you!

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

Sort by

AARON_C 2,235 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @Mayankk1H,

Have you set the Format property of the Text Input control to be 'Number'.

What do you meant by the data type is set to 'Number'?

Was this reply helpful? Yes No
WarrenBelz 155,463 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @Mayankk1H ,

This is a tricky one which I have encountered myself (so I will post from this). % is actually the only non-numeric character other than a decimal point the column will accept - I get around it with this OnChange

If( "%" in Text(Self.Text), Reset(Self) )

Was this reply helpful? Yes No