In my Power apps customized Sharepoint form, there is a column that only accept unique values.
I've created a error message that shows OnFailure, if the user tries to save with a value that is already in the list: "The title xx is already taken".
But is there a way to get rid of the automatic error message that says "Network error when using Patch function: The requested operation is invalid."?
My costom error message, copy/pasted from Solved: Re: Show error message when entering duplicate val... - Power Platform Community (microsoft.com)
If(
IsError(
Patch(
test3;
Defaults(test3);
SharePointForm1.Updates
)
);
// On failure
Notify(
If(//check for duplicates
!IsBlank(
LookUp(
test3;
Title = DataCardValue1.Text
)
);
("The title "& DataCardValue1.Text &" is already taken"); //if there is a duplicate, show this message
"" //if there is not a duplicate but there is a different error, show this message
);
NotificationType.Error
);
// On success
Notify(
"";
NotificationType.Success
)
)
WarrenBelz
146,537
Most Valuable Professional
RandyHayes
76,287
Super User 2024 Season 1
Pstork1
65,908
Most Valuable Professional