Hi there,
I am having difficulties patching my table using a gallery dropdown. My aim here is for people to be able to submit their audit incomplete and it is stored into the table like the example below. I the have a patch function where they can go back to their audit and complete it, updating each question "Pass_Fail" which is located within a gallery in image 2. However using the code below is only updating the first record it finds in the table with the call reference lookup, instead of patching every one of them.
ForAll(QuestionGal_edit.AllItems, Patch(Audit_answers, LookUp(Audit_answers, call_reference = reference_edit.Text), {call_reference: reference_edit.Text, call_type: Calltype_dropdown_edit.Selected.'Call Type', date_of_audit: Audit_Date_edit.SelectedDate, BU: BU_dropdown_edit.Selected.Value, advisor: Advisor_dropdown_edit.Selected.Advisor_name, Question: 'Question-text_edit'.Text, Pass_Fail: Pass_dropdown_edit.Selected.Value, Feedback: Feedback_dropdown_edit.Selected.Value, bulk_audit: Bulk_1.Text, Satisfaction: Satisfaction_1.Selected.Value}))
Does anyone have any advice/ideas on how to fix this?

