Restrict user to enter specific values in the text input

(0) Share

Report

Posted on by Community Power Pla...

hi Expert

i was trying to build an apps

where the records shouldn't exceed 100% or 1 like table below

Employee	Allocation
A	0.35
b	0.5
C	1
A	1
A	0.5

i am trying to build an app where while entering the details monthly it will lookup the user sum it up and if its above than 100% or 1 than the field wont accept the record or else it will give a pop up message saying the value is not within the range.

Categories:

Building Power Apps

I have the same question (0)

All responses (8)

Answers (1)

v-jefferni on at

Like (1)

Report
Hi @Anonymous ,

There is no easy way to restrict text inputs to text boxes. As a workaround, you can add Labels below each Text Input box and set Text property. For example, Label below Jan input box is as follows:

If( Sum(Filter(YourDataSource, Name = User().FullName),Jan)+ JanInput > 1, "Allocation for Jan shouldn't exceed 100% or 1" )

You can also set Color of the Label to Red so that make them seem like warnings.

Hope this helps.

Best regards,

Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.

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

Like (0)

Report

hi Thank you
but am not getting any message when i walkaround your code

If(Sum(Filter(Forecast,Jan=Jan_DataCard1.DataField,EmployeeName=EmployeeName_DataCard2),Value(Jan))=1,true,false)
data source

Was this reply helpful? Yes No
v-jefferni on at

Like (0)

Report

Hi @Anonymous ,

Visible property only control the visibility of Controls, what do you have in Text property of the Label?

Besides, Sum function accepts text column as the second parameter, so no need to convert using Value function.

Best regards,

Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.

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

Like (0)

Report

hi
Thanks but this should only pop up if some one tries to enter the value >1, and its showing the same even its 1

Was this reply helpful? Yes No
Verified answer

v-jefferni on at

Like (0)

Report

Hi @Anonymous ,

The formula sums the January numbers for a specific employee in the list add add with the number typed-in in Jan Text input box then judge the result. I saw you have Jan number 1 for QA already in the list so you will get the total number >1 when input 1 in the text box. You can try and input 0 to see if it is right.

Hope this helps.

Best regards,

Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.

Was this reply helpful? Yes No
v-jefferni on at

Like (0)

Report

Hi @Anonymous ,

Have you solved this issue?

Best regards,

Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.

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

Like (0)

Report

Yeah but the suggested solution didnt workwout so had to create an new text input.

Was this reply helpful? Yes No
v-jefferni on at

Like (0)

Report

Hi @Anonymous ,

It's great! Would you please consider sharing the solution in detail so others in the community may get help from it? You can accept your reply to show this thread as solved.

Best regards,

Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.

Was this reply helpful? Yes No