Answered

Patch still saving even the list item are required.

(0) Share

Report

Posted on by a104230

Hi Everyone,

I'm currently having an issue with PowerApps patch function, I have SharePoint list, I have configured Columns to be required. However, when I'm patching please see Image 2, even the 2 column are null value, patch still saves. Please see image 3.

Patch still saving even the list item are required image 1.png

Patch still saving even the list item are required image 2.png

Patch still saving even the list item are required image 3.png

Categories:

Building Power Apps

All responses (5)

Answers (1)

Sort by

cha_cha 4,932 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!
Hello @a104230

Patch function does ignore those "Required" properties and what you can do is modify your code and put your patch inside an If function.

If( Or( IsBlank(TextInput1.Text), IsBlank(TextInput1_1.Text) ), Notify("Blank inputs") , //Patch Code here Notify("Saved") )
a104230 28 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks for this @cha_cha ! However, there are certain video blogs in YouTube that patch function does not push if the column is required and the control is Blank.
cha_cha 4,932 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!

Hello @a104230

I understand what you meant there however the validation in Patch only checks if the field exist in the Patch. For example, if your Patch says

Patch(SPListName, Defaults(SPListName),{'Vendor Name': TextInput1_1.Text}), this would be flagged cause a required column named "Title" is not present in your Patch.

In your given code, both Title and 'Vendor Name' are present so they satisfied the requirement that the required field is present. Technically, Patch still acknowledges that an empty input textbox is still a valid value that's why it gets added to SharePoint even though SharePoint doesn't recognize a text without characters as a valid entry. We cannot make changes to the innate behavior of the Patch function which is why a preliminary checking of input value is needed to workaround the limitations.
a104230 28 on at

Like
a
(0)

Report
Copy link

Link copied!

Good day @cha_cha , please see below article I have been trying to replicate.
https://www.matthewdevaney.com/power-apps-patch-function-error-handling/
Verified answer

cha_cha 4,932 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
Hello @a104230

Which part of the given link were you trying to replicate?

My initial provided code has the structure that you need to not Patch the data if either the Title or the Vendor is empty. You just have to add your patch code to the designated place indicated by the comment "//Patch code here"

Here's what I gave:

If( Or( IsBlank(TextInput1.Text), IsBlank(TextInput1_1.Text) ), Notify("Blank inputs") , //Patch Code here Notify("Saved") )

And here's how how you can do it:

If( Or( IsBlank(TextInput1.Text), IsBlank(TextInput1_1.Text) ), Notify("Blank inputs") , Patch( SPListName, Defaults(SPListName), { Title: TextInput1.Text, 'Vendor Name': TextInput1_1.Text } ); Notify("Saved"); )