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

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

View solution in original post

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
PA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.

Users online (1,468)