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
Solved! Go to Solution.
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. >>
Thanks for the response. Can you provide any more detail around this part?
What do these represent in the context of the SharePoint list and the DataCard/DataCardValue?
Fill out a quick form to claim your user group badge now!
Find out where you can attend!
Features releasing from October 2019 through March 2020
The largest Power BI, Power Platform, and Data conference in New Zealand