Answered

Sharepoint list form set error

(0) Share

Report

Posted on by StevieC

137

I am editing a form for a sharepoint list in PowerApps. I want to add additional validation to my form but i cant work out how to stop the form being able to be saved?

At the moment i have set the Text property of the error message like this:

If("For Sale" in DataCardValue2.Text, "dont use for sale", Parent.Error).

This works - the error shows if they use For Sale and also shows the standard error if the field is empty (its a required field), but the user can still save the form in the first instance.

cheers

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

Sort by

Drrickryp Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @StevieC

Put the condition in the Display mode of the button and set it's default to disabled.

Was this reply helpful? Yes No
yashag2255 24,769 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @StevieC

This is because even though the error message shows, there is no restriction on the submit of this form. You can configure this by disabling the Submit button if the "For Sale" keyword exist in your input control.

Submit Button -> DisplayMode -> If("For Sale" in DataCardValue2.Text, DisplayMode.Disabled, DisplayMode.Edit)

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Was this reply helpful? Yes No
StevieC 137 on at

Like
a
(0)

Report
Copy link

Link copied!

Unfortunately its not that simple as this is a SharePoint form edited in PowerApps, so the save button isnt part of the form (not sure how this works!)

Was this reply helpful? Yes No
StevieC 137 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi - see my response above - cheers

Was this reply helpful? Yes No
Verified answer

yashag2255 24,769 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

@StevieC

I see what you are trying to say. In that case, you can update the OnSave property of the SharePoint Integration to below expression:

If("For Sale" in DataCardValue2.Text, Notify("Error Message", NotificationType.Error), SubmitForm(SharePointForm1))

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Was this reply helpful? Yes No
StevieC 137 on at

Like
a
(0)

Report
Copy link

Link copied!

That's the ticket! 🙂 Thanks for your help

Was this reply helpful? Yes No