Skip to main content
Community site session details

Community site session details

Session Id :
Power Apps - Building Power Apps
Unanswered

Patch working in Studio but not Published

(0) ShareShare
ReportReport
Posted on by 39

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!

Categories:

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 791 Most Valuable Professional

#2
MS.Ragavendar Profile Picture

MS.Ragavendar 410

#3
mmbr1606 Profile Picture

mmbr1606 275 Super User 2025 Season 1