Unanswered

Limit range typed into number field

(0) Share

Report

Posted on by ghutchinsMicron

152

Beginner question... A SharePoint list form has a 'number' input field, i need to limit the range that can be input into this field 0 - 100. Think that I need to add a function to the 'OnChange' action for the datacardvaluexx field??? ... but not sure of the context. I am sure it is a simple statement, but it eludes me. Is there any help for me out there?

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (1)

LaurensM 12,516 Moderator on at

Like (0)

Report

@ghutchinsMicron You can do this in SharePoint itself.
Edit the number field in the SharePoint list, go to more options and set a max value.

I hope this helps!

Was this reply helpful? Yes No
ghutchinsMicron 152 on at

Like (0)

Report

@LaurensM I am aware that this can be done in SharePoint. Want to do it in the app so that the error pops up right then and there if the user inputs 101. Dont want to wait until the form is saved to find out the number input was not correct.

Was this reply helpful? Yes No
Verified answer

LaurensM 12,516 Moderator on at

Like (1)

Report
@ghutchinsMicron with a form the error would show up when they try to submit.
If you want to show it directly after filling in a number, please try this code on the OnChange of the field:

If( Value(Self.Text) > 100, Notify( "Value cannot be more than 100", NotificationType.Error ); Reset(Self) )

I hope this helps!

Was this reply helpful? Yes No
ghutchinsMicron 152 on at

Like (0)

Report

Yes... that is what I was requesting. Thanks

Was this reply helpful? Yes No
rajeevkumar0 10 on at

Like (0)

Report

Hello Lauren, I am stuck in one condition. i have 02 forms one is for users who enter the required quantity and 2nd is the view form that I want to apply the condition that users can not increase the quantity based on the required quantity however they can issue less quantity.

Required Quantity-DataCardValue32
Issued Quantity- DataCardValue58

Please help me

Was this reply helpful? Yes No
rajeevkumar0 10 on at

Like (0)

Report

Please help

Was this reply helpful? Yes No
rajeevkumar0 10 on at

Like (0)

Report

It has been resolved by applying the below formula on data card value on change properties.

If(
    Value(DataCardValue32.Text) <= Value(DataCardValue58.Text),
    Notify(
        "Value cannot be more than user requested QTY ",
        NotificationType.Error
    );
    Reset(Self)
)

Was this reply helpful? Yes No