cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper II
Helper II

Field Validation , Greater than 0

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

 

 

PBala_0-1597099744280.png

 

1 ACCEPTED SOLUTION

Accepted Solutions
Super User II
Super User II

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

View solution in original post

5 REPLIES 5
Highlighted
Super User II
Super User II

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

Highlighted
Helper II
Helper II

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.

 

 

Super User II
Super User II

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

View solution in original post

Highlighted
Helper II
Helper II

Re: Field Validation , Greater than 0

Thank you very much, your solution worked.

Highlighted
Super User II
Super User II

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

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Watch Now

Experience what’s next for Power Apps

See the latest Power Apps innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (5,614)