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:

Building Power Apps

All responses (4)

Answers (0)

Sort by

Suggested answer

SpongYe 5,909 Super User 2026 Season 2 on at

Like
a
(1)

Report
Copy link

Link copied!
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})
WarrenBelz 156,528 Most Valuable Professional on at

Like
a
(2)

Report
Copy link

Link copied!
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
JP-24071314-0 10 on at

Like
a
(1)

Report
Copy link

Link copied!

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 156,528 Most Valuable Professional on at

Like
a
(2)

Report
Copy link

Link copied!

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