patching to SP list

(0) Share

Report

Posted on by Blue87

Greetings, I am trying to include a text input control in a edit form control using the patch function. I am able to write to the SP list however, when i select submit, the results are 2 records being submitted, one with the data from the edit form control, then another from the input control. I think my issue is using the semi colon but i am not quite sure. Any help is appreciated.

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (0)

Sort by

Suggested answer

CU25020938-0 71 on at

Like (0)

Report
Copy link

Link copied!

That's because you are creating two line items. The submitform creates an item, and you use the Patch to also create an item. You need to refer to the already created item in the Patch function.

Put this into the form OnSuccess property:

Patch(

'VHR_In Office Calendar (testing)',

LookUp(

'VHR_In Office Calendar (testing)',

ID = Self.LastSubmit.ID

),

{AdditionalNotes:AdditionalNotes.Text}

)

Or if you add a Text column in the SP list called Additional Notes and add that datacard to the form
you don't need an extra Patch at all.

Was this reply helpful? Yes No
Suggested answer

Pstork1 69,397 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
If you want to do a separate Patch to the record that is in the Edit form then you need to use a Lookup() or the LastSubmit property of the form to specify the record to be patched. Something like this

SubmitForm(InOfficeCalendar); Patch('VHR_In Office Calendar (testing)', InOfficeCalendar.LastSubmit, {AdditionalNotes: AdditionalNotes.Text}); Reset(AdditionalNotes);

Was this reply helpful? Yes No
Blue87 84 on at

Like (0)

Report
Copy link

Link copied!

thank you for your response, i received the below errors. could you explain a little on what the "ID = self.lastsubmit.ID" is used for? Thank you

Was this reply helpful? Yes No
CU25020938-0 71 on at

Like (0)

Report
Copy link

Link copied!

LastSubmit , capital letters matter and you can only use LastSubmit in the OnSuccess property of the form.

LastSubmit can access properties of the last submitted record that were created by SubmitForm(). E.G. Self.LastSubmit.Location will give you the text from the Location column.

Also, is there a reason you want to separately submit the additional notes? If you click on the form on the properties side window there is a button called Fields.

You can then select the additional notes field that is already on the SP list and simply add it to the form. Then you can disregard the Patch part, because the submitform will submit all fields:

Was this reply helpful? Yes No
Pstork1 69,397 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

@Kenobi said, "you can only use LastSubmit in the OnSuccess property of the form"

That is not true. LastSubmit can be used in a variety of places outside the OnSuccess. It is most commonly used in OnSuccess, but is a perfect solution here where the SubmitForm() is in the same action as the use of LastSubmit.

Was this reply helpful? Yes No
CU25020938-0 71 on at

Like (0)

Report
Copy link

Link copied!

Pstork1 yes that is true, i usually use it on the OnSuccess to make sure nothing gets messed up if for any reason the form wouldn't submit.

Was this reply helpful? Yes No