Unanswered

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

I have the same question (0)

All responses (4)

Answers (0)

Suggested answer

SpongYe 5,603 Super User 2025 Season 2 on at

Like (1)

Report
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})

Was this reply helpful? Yes No
WarrenBelz 153,040 Most Valuable Professional on at

Like (2)

Report
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

Was this reply helpful? Yes No
JP-24071314-0 10 on at

Like (1)

Report

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:

Was this reply helpful? Yes No
WarrenBelz 153,040 Most Valuable Professional on at

Like (2)

Report

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

Was this reply helpful? Yes No