Unique Value Fields in PowerApps

[Anonymous]

Hello Expert!

I have created a sharePoint customized form in PowerApps, I have three fields, I want that if user entered one value in first field then this value can not be entered into 2nd field.

For Example: Lets user enter 12345 in DataCard-1 and then he enter same value(12345) in DataCard-2, so in this case I want to user restrict to fil duplicate value in datacard-2, Is this possible??

Here is my 3 fields:

Please Suggest, I want above three field should be unique with each other
@powerapp 

[JR-BejeweledOne · Accepted solution]

Add a label to each of the data cards and set the text something like, This must be unique and cannot match BP Number or Invoice Number.   Each label text would refer to the other 2 fields.

Then in the visible property for your error message labels:  

If(
    !IsBlank(DataCardValueX) && DataCardValueX = DataCardValueZ || DataCardValueY, true,
    false
)

If(
   !IsBlank(DataCardValueY) && DataCardValueY = DataCardValueX || DataCardValueZ, true,
   false
)
    

If(
    !IsBlank(DataCardValueZ) && DataCardValueZ = DataCardValueY || DataCardValueX, true,
     false
)

  This will cause the error to appear if the value in any of the data cards equals the value in either of the other 2.

[Anonymous]

Thanks for your reply Sir!

But in this form will be saved only user will get an error ,I guess right?

I want to stop form to be saved if value is duplicate.

[JR-BejeweledOne]

Are you using the default SharePoint submit action or did you add a submit button?

[JR-BejeweledOne]

Try this, you won't need the additional labels in each data card with this method.   First in your app onStart, create and set varResetBPNum, varResetInvoiceNum, varResetSFContract all to false.

In your DataCardValue reset property for each field, add the matching Reset variable.  

Select 'SharePoint Integration' from the Tree View and Click on 'Advanced' in the right hand pane.   In your OnSave property, replacing X, Y, Z with your values.:

If(
    !IsBlank(DataCardValueX) && DataCardValueX = DataCardValueZ || DataCardValueY, !SubmitForm(SharePointForm1), Notify("Value must be Unique", NotificationType.Error); Set(varResetX, true); Set(varResetX, false),
    !IsBlank(DataCardValueY) && DataCardValueY = DataCardValueX || DataCardValueZ, !SubmitForm(SharePointForm1),Notify("Value must be Unique", NotificationType.Error); Set(varResetY, true); Set(varResetY, false),
    !IsBlank(DataCardValueZ) && DataCardValueZ = DataCardValueY || DataCardValueX, !SubmitForm(SharePointForm1),Notify("Value must be Unique", NotificationType.Error); Set(varResetZ, true); Set(varResetZ, false),
     SubmitForm(SharePointForm1)
)

This will prevent the item from saving and will reset the text box.  If it's a new form it should reset it to blank and if it's an item being edited it will reset it to it's saved value