Field Validation , Greater than 0

Like (0) Share

Report

Posted on 10 Aug 2020 22:51:50 by PBala

Hi,

I have a field called " Quantity" (Part of a Collection) , Default Value is 0, I want user to enter value greater than 0 and if they miss, prompt message should appear "Enter value more than 1".

Since the default value is 0, I don't want this validation appear on form Load.

The back-end is SharePoint list.

Thanks in Advance.

Pbala

Categories:

Using Apps Using Formulas

I have the same question (0)

All responses (5)

Answers (1)

PowerAddict 7,314 Most Valuable Professional on 11 Aug 2020 at 16:52:26

Like (0)

Report

Re: Field Validation , Greater than 0

Glad I could help! Good luck with the rest of the app! Feel free to reach out in case of any questions!

Thanks!

Hardit Bhatia

Microsoft Business Applications MVP

Blog | Twitter | LinkedIn | Facebook | YouTube | Email

Was this reply helpful? Yes No
PBala 95 on 11 Aug 2020 at 16:31:57

Like (0)

Report

Re: Field Validation , Greater than 0

Thank you very much, your solution worked.

Was this reply helpful? Yes No
Verified answer

PowerAddict 7,314 Most Valuable Professional on 11 Aug 2020 at 01:50:52

Like (1)

Report
Re: Field Validation , Greater than 0

Have you tried this? Where you have the Patch function, add this:

If(Value(LineQuantity.Text)>0, Patch( ExpenseCollection, ThisItem, { ddlValue:Dropdown1.Selected.Item, LineCost: LineCost.Text, LineQuantity: Value(LineQuantity.Text), LineSize: LineSize.Text, LineTotal:Value(LineTotal.Text), ShowSaveButtons:false } ), Notify("Please enter a quantity greater than 0", NotificationType.Error) ) ;

Let me know if this works.

---
If you like this reply, please give kudos (Thumbs Up). And if this solves your problem, please mark this reply as a solution by selecting Accept as Solution. This makes it easier for others to find answers to similar questions.

Thanks!

Hardit Bhatia

Microsoft Business Applications MVP

Blog | Twitter | LinkedIn | Facebook | YouTube | Email

Was this reply helpful? Yes No
PBala 95 on 11 Aug 2020 at 01:11:45

Like (0)

Report

Re: Field Validation , Greater than 0

Thanks for the response.

Are you using Pqtch or SubmitForm for submission?

I am using Patch function to submit to the Collection.

Patch(
ExpenseCollection,
ThisItem,
{
ddlValue:Dropdown1.Selected.Item,
LineCost: LineCost.Text,
LineQuantity: Value(LineQuantity.Text),
LineSize: LineSize.Text,
LineTotal:Value(LineTotal.Text),
ShowSaveButtons:false

}
);

Also, are you saying that the validation should only happen if the user has replaced the default 0 with 0 or 1? And is the validation that the number entered by the user should be greater than 0 or 1?
Default Value is 0, I want the validation to occur if the user has not replaced the 0 with value greater than 0.
The validation number should be greater than 0.
I am not submitting the form to the SharePoint list, if the line item quantity is 0. I want to visually prompt the user that they need to add quantity value greater than 0.

Let me know so I can guide you with the best possible suggestion.

Thank you very much.

Was this reply helpful? Yes No
PowerAddict 7,314 Most Valuable Professional on 11 Aug 2020 at 00:20:09

Like (0)

Report

Re: Field Validation , Greater than 0

Are you using Pqtch or SubmitForm for submission?

Also, are you saying that the validation should only happen if the user has replaced the default 0 with 0 or 1? And is the validation that the number entered by the user should be greater than 0 or 1?

Let me know so I can guide you with the best possible suggestion.

---
If you like this reply, please give kudos. And if this solves your problem, please accept this reply as the solution.

Thanks!
Hardit Bhatia
Microsoft Business Applications MVP
https://thepoweraddict.com

Was this reply helpful? Yes No