Hi @araujocamila,
Have you solved your problem?
Do you want to ensure that there are no duplicate users in a record?
Could you please share a bit more about the scenario, do you have a People picker to select user name?
Not sure why there is a button for each Combo Box, but I think if you only have one submit button, you could achieve your need by setting the OnSelect property of the submit button as below:
If(
ComboBox1.Selected.Email = ComboBox2.Selected.Email ||
ComboBox1.Selected.Email = ComboBox3.Selected.Email ||
ComboBox2.Selected.Email = ComboBox3.Selected.Email,
Notify("Please select different user!",Error)
)
Or I think you could consider the ErrorMessage control, set the Text of the Label corresponding to the ErrorMessage in your data card as below:
"Please select different user!"
Set the Visible of the ErrorMessage as below:
If(
ThisItem.columnA = ThisItem.columnB ||
ThisItem.columnA = ThisItem.columnC ||
ThisItem.columnB = ThisItem.columnC
),true,false)
Please write the above formula for each ErrorMessage Label.
And for the OnSelect property of the submit button as below:
If(
ErrorMessage27.Visible || ErrorMessage23.Visible || ErrorMessage24.Visible,
Notify(
"User exists, please note the error message!",
NotificationType.Warning
),
SubmitForm(EditForm1)
)
Hope this could help you at some degree.