I want to restrict a users ability to input certain data more than once. Is this possible?

(0) Share

Report

Posted on by QuestionTime

For example, I have an app that users to create an input that is sent to a SQL server. When a user inputs data one of the data inputs requires them to input their name. I want to make it so that once a user inputs data with a certain name, then that name can only be used once. If it is used again, then an error message will appear. Is this possible?

For example: Here is a situation where an input was made with the name 'Robert' at Daytona1. Then, another input was made after that also used 'Robert' at Daytona1. I want to make it so that the second input could not make an input with 'Robert'; an error message should pop-up instead. Is this possible? This condition should only apply to the name field.

Categories:

Building Power Apps

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

v-siky-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @QuestionTime ,

How did you create a new input?

If it was through the EditForm, just try to add some logic condition before submitform.

If(IsBlank(LookUp('Table Name', Name=TextInputName.Text).Name), SubmitForm(FormName), Notify("Name already exists!",NotificationType.Error))

Hope this helps.

Sik

Was this reply helpful? Yes No