Unanswered

patch form not updating all fields in SharePoint

(0) Share

Report

Posted on by holland1994

I am using the following formula to submit a form and then patch attachments. However, several fields are not being populated on the submit, or are being cleared by the second patch function. How do I correct?

Set(varRecord,If(
Form1.Mode = FormMode.New,
Patch('GPFS Continuous Improvement', Defaults('GPFS Continuous Improvement'), Form1.Updates),
Patch('GPFS Continuous Improvement',Gallery1.Selected, Form1.Updates)
)); If(!IsBlank(varRecord),
Notify("Your request has been submitted! (ID: "& varRecord.ID &")", NotificationType.Success),
Notify("Your request was Not submitted", NotificationType.Error)
);

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

RandyHayes 76,297 Super User 2024 Season 1 on at

Like (0)

Report

@holland1994

When you say Form...are you referring to an EditForm? If so, then you should be using the SubmitForm function on your form rather than patching.

In your case, your submit should be :

SubmitForm(Form1)

In the OnSuccess of Form1 you should have:

Set(varRecord, Self.LastSubmit); Notify("Your request has been submitted! (ID: "& varRecord.ID &")", NotificationType.Success)

In the OnFailure of Form1 you should have:

Notify("Your request was Not submitted", NotificationType.Error)

Also, the Item property of your Form1 should be : Gallery1.Selected

I hope this is helpful for you.

Was this reply helpful? Yes No
RandyHayes 76,297 Super User 2024 Season 1 on at

Like (0)

Report

@holland1994

Were you able to work through your issue or do you still need help?

Was this reply helpful? Yes No