Sharepoint custom form with unique values

[bart_vermeersch]

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!

[Anonymous · Accepted solution]

Hi @bart_vermeersch

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.

[jaina]

hello @bart_vermeersch , can you share how you resolve this issue?