How to customize an error message

[cooper33]

I have a list with a field where unique values are enforced. When I try to add a duplicate entry via PowerApps, I get this message: 

The requested operation is invalid. Server Response: The list item could not be added or updated because duplicate values were found in the following field(s) in the list: [User]. clientRequestId: ... serviceRequestId: ...

which I expect. Is there any way to customize the text of this message? Or would I be better off removing the unique value enforce on the SP side and do it all through PowerApps?

I am working with a User field

[emh]

Hello Cooper,

One way to customize the message is to do a LookUp before the record is added:

If(IsBlank(Lookup(YourSharePointList), UserID=User_Input_UserID), add record, display custom error message)

Hope this helps.

<< If this solves your issue, please flag this as such so others may also benefit. >>

[cooper33]

Thanks for the response. Can you provide any more detail around this part?

UserID=User_Input_UserID

What do these represent in the context of the SharePoint list and the DataCard/DataCardValue?

[emh · Accepted solution]

Hello Cooper,

UserID is the column name of the SharePoint list UserID

User_Input_UserID is DataCardValue#.Text

Does that help clarify?