Answered

Patching a collection with LastSubmit Blank value not working

(0) Share

Report

Posted on by ramzez

312

I am displaying a collection (colAssessments) in a gallery and whenever a form is submitted, I am patching the collection to keep the gallery up to date. I have the following in the form.OnSuccess:

Patch(colAssessments, LookUp(colAssessments, AssessmentID = frmAssessment.LastSubmit.AssessmentID), frmAssessment.LastSubmit);

If an existing record is edited in the form and a textbox is emptied with text in it, the database is updated but the collection is not. When I look what the LastSubmit includes, it doesn't include the Blank value at all.

I have formula-level error management turned on.

How can I patch a blank value with the LastSubmit?

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

Akser 1,546 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @ramzez,

Is there a specific reason why you don't use Update / UpdateIf?

Was this reply helpful? Yes No
ramzez 312 on at

Like
a
(1)

Report
Copy link

Link copied!
No other reason than I've never had the need to use them.

I changed Patch to Update and it works, thank you!
Update(colAssessments, LookUp(colAssessments, AssessmentID = frmAssessment.LastSubmit.AssessmentID), frmAssessment.LastSubmit);

LastSubmit still doesn't contain the Blank value but Update updates with the Blank value and Patch doesn't.
Why does Update work in this case but Patch doesn't?

Was this reply helpful? Yes No