title: How do I update multiple db records using a gallery in PowerApps?
body: <p>I have an Audit app made in PowerApps which saves the answers to 18 questions to a database. I have another screen which allows users to edit the answers to those questions. I can display the previous answers and edit them but can't seem to update the original records in the db. It just displays the original records in the db. My code for the 'Save changes' button is below...</p>
  <p>Update(AuditCollection,First(Filter(AuditCollection,ID=Value(IDGal_1.Text))),{AuditID:IDAuditVar, Question:txtQuestion.Text, Answer:txtComplianceEdit1.Text,Action :txtActionsEdit1.Text,AddToActionPlan:tglActionPlanEdit.Value});</p>
  <p>I've also tried adding Collect('dbo.auditanswers',AuditCollection) on the end but this stores a further set of 18 questions although it does take in the new values.</p>
  <p><a href="https://i.stack.imgur.com/m5hYB.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/m5hYB.png" alt="EditAnswersScreen" /></a></p>