Hi
I have a Power Apps form built on Sharepoint list. I have applied "validation" (at least that is what I think it is) which shows when there is invalid data entry. (Icons, text, color etc) However it does not prevent this invalid data being submitted and saved back to the the original list despite being invalid. So effectively validation needs to be done twice? Once on the control and then again on commit (be it save or update)
Is there a way to build a custom function to do this? I'd rather put the 15 or so logic tests (e.g. first name has be at least two characters, last name has to be at least two characters, mobile has to be exactly 10 digits, start date must be within the last 14 days, etc) in a single function which returns a boolean than code these all in the OnSave property of the SharePointIntegration.
I've read too many validation Power app articles that only show validation but do not prevent incorrect data from being submitted.
Happy enough to read article recommendations.
To my mind validation is not just showing a user that the entry is incorrect but also stopping this incorrect data before it is committed to the list.
Cheers

Report
All responses (
Answers (