Error- Patch Function Not Saving

(1) Share

Report

Posted on by JP-24071314-0

Hello!

Currently building a checklist with a gallery consisting of text, dropdown inputs and textbox inputs, and trying to get each to save with the users input, with using data from a sharepoint list, However I'm currently facing this error:

Gallery Code:

Onselect:

ForAll(Gallery3_1.AllItems,
Collect(
    TestCol,
    {
        answersc: inpanswers.Selected,
        evidencesc: inpevd.Text
    }
)
)





Input Code:

Onchange:
Patch(TestCol, ThisItem, {answersc: Self.Selected.Value})
 
Patch(TestCol, ThisItem, {evidencesc: Self.Text })


Been stuck on this for a while so any help would be appreciated! :)

Categories:

General Questions

All responses (4)

Answers (0)

WarrenBelz 146,670 Most Valuable Professional on at

Like (2)

Report

Error- Patch Function Not Saving

Hi JP-24071314-0
You need to use whichever field is the unique identifier (no two records have the same value) in your table.
JP-24071314-0 10 on at

Like (1)

Report

Error- Patch Function Not Saving

Thank you @WarrenBelz! The explanation definitely helped, I do have ID as a column in the sharepoint list, but not in the record itself, how would I establish a unique ID for each entry/input in the collection?

thank you!!

edit: currently getting this error:
WarrenBelz 146,670 Most Valuable Professional on at

Like (2)

Report
Error- Patch Function Not Saving

Hi JP-24071314-0,
The first explanation suggests that the Items of the Gallery are not exactly the same as the fields in the Collection, so ThisItem does not exactly match the target record. The other errors suggest that answersc is a Choice column. Assuming that you have a unique identifier in the record (I will use ID as an example), this may work
Patch( TestCol, LookUp( TestCol, ID = ThisItem.ID ), {answersc: Self.Selected} )

Please click Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it a Like.
MVP (Business Applications) Visit my blog Practical Power Apps Buy me a coffee
Suggested answer

SpongYe 5,580 Super User 2025 Season 1 on at

Like (1)

Report
Error- Patch Function Not Saving

Hi,

Looks like your Patch is not correct.

When collection answersc you type is a record.

So when you patch it needs to match the same type.

Try this with the Patch:

Patch(TestCol, ThisItem, {answersc: Self.Selected})