cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
PBala
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

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
PowerAddict
Super User
Super User

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

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.

 

 

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

Thank you very much, your solution worked.

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
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Difinity Conference 2022

Difinity Conference 2022

Register today for two amazing days of learning, featuring intensive learning sessions across multiple tracks, led by engaging and dynamic experts.

European SharePoint Conference

European SharePoint Conference

The European SharePoint Conference returns live and in-person November 28-December 1 with 4 Microsoft Keynotes, 9 Tutorials, and 120 Sessions.

Power Apps Ideas

Check out the New Ideas Site

We are excited to announce a new way to share your ideas for Power Apps!

Top Solution Authors
Top Kudoed Authors
Users online (3,099)