Hi there,
I have set up a survey using PowerApps where the responses are automatically input to a sharepoint list using the Patch function - this function works when in the app, but once its published the responses no longer go into the sharepoint list
The survey requires the students taking it to fill out certain sections multiple times if they have more than one teacher they want to provide feedback for, so there are two points where I have used the Patch function
The first Patch is this: (this button is only selected when the student wants to go back to review another teacher, if they're only reviewing one teacher this button will not be selected)
Patch(FeedbackResponses, Defaults(FeedbackResponses); {Title: AnsLevel.Selected.Value, Subjects: AnsSubject.Selected.Value, Teachers: AnsTeacher.Selected.Value, Support: DrpSupport.Selected.Value, Organised: DrpOrganised.Selected.Value, Effective: DrpEffective.Selected.Value, Productive: DrpProductive.Selected.Value, Instructions: DrpInstructions.Selected.Value, Feedback: DrpFeedback.Selected.Value, Environment: DrpEnvironment.Selected.Value, Returned: DrpReturned.Selected.Value, Assessments: DrpAssessments.Selected.Value, Work: DrpWork.Selected.Value, Comments: AnsComments.Text});
Reset(AnsLevel); Reset(AnsSubject); Reset(AnsTeacher); Reset(DrpSupport); Reset(DrpOrganised); Reset(DrpEffective); Reset(DrpProductive); Reset(DrpInstructions); Reset(DrpFeedback); Reset(DrpEnvironment); Reset(DrpReturned); Reset(DrpAssessments); Reset(DrpWork); Reset(AnsComments);
Navigate('Teachers/Subjects')
Once they have completed the feedback for their teachers, they have one more question, and then when they click the exit button there is this second patch:
Patch(FeedbackResponses, Defaults(FeedbackResponses); {Title: AnsLevel.Selected.Value, Subjects: AnsSubject.Selected.Value, Teachers: AnsTeacher.Selected.Value, Support: DrpSupport.Selected.Value, Organised: DrpOrganised.Selected.Value, Effective: DrpEffective.Selected.Value, Productive: DrpProductive.Selected.Value, Instructions: DrpInstructions.Selected.Value, Feedback: DrpFeedback.Selected.Value, Environment: DrpEnvironment.Selected.Value, Returned: DrpReturned.Selected.Value, Assessments: DrpAssessments.Selected.Value, Work: DrpWork.Selected.Value, Comments: AnsComments.Text, Plans: AnsPlans.Selected.Value});
Reset(AnsLevel); Reset(AnsSubject); Reset(AnsTeacher); Reset(DrpSupport); Reset(DrpOrganised); Reset(DrpEffective); Reset(DrpProductive); Reset(DrpInstructions); Reset(DrpFeedback); Reset(DrpEnvironment); Reset(DrpReturned); Reset(DrpAssessments); Reset(DrpWork); Reset(AnsComments); Reset(AnsPlans);
Exit(true)
Not sure where I'm going wrong as like I said it works fine when in the studio, so any help would be much appreciated!
WarrenBelz
791
Most Valuable Professional
MS.Ragavendar
410
mmbr1606
275
Super User 2025 Season 1