Answered

Field Validation , Greater than 0

(0) Share

Report

Posted on 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:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

PowerAddict 7,316 Most Valuable Professional on at

Like (0)

Report

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
PBala 95 on at

Like (0)

Report

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
Verified answer

PowerAddict 7,316 Most Valuable Professional on at

Like (1)

Report
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 at

Like (0)

Report

Thank you very much, your solution worked.

Was this reply helpful? Yes No
PowerAddict 7,316 Most Valuable Professional on at

Like (0)

Report

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