I've created a custom form using powerapps based on a SharePoint list.
When submitting the form, mandatory fields are automatically validated, an error appears when submitting.
However, this doesn't work for columns requiring unique values. No error appears, and the form stays open. Is this a know "defect"?
Is it possible to implement this validation manually?
Thanks!
Solved! Go to Solution.
I believe its possible. My suggestion is to use lookup for the values inside the field to find match inside your source list. And if it finds matching record, than perform action. E.g. disable the submit button and inform you via sum pop-up on page.
Btw. I have tried to replicate that issue and if the value was not unique the submittion wasn't completed so it failed, however its not highlited the issue.
I believe its possible. My suggestion is to use lookup for the values inside the field to find match inside your source list. And if it finds matching record, than perform action. E.g. disable the submit button and inform you via sum pop-up on page.
Btw. I have tried to replicate that issue and if the value was not unique the submittion wasn't completed so it failed, however its not highlited the issue.
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.
User | Count |
---|---|
194 | |
45 | |
45 | |
39 | |
35 |
User | Count |
---|---|
267 | |
83 | |
81 | |
73 | |
70 |