Announcements
*** ChatGPT Response to question ***
Hi,
The issue arises because the Department column you're trying to patch into your SharePoint list 'KP Tracking Target' does not exist in that list. When you include a column in the recordToSubmit variable that is not present in the SharePoint list, Power Apps throws an error stating that the column does not exist.
Department
'KP Tracking Target'
recordToSubmit
Verify the SharePoint List Columns:
Update Your Code:
Here’s the corrected code assuming Department is not needed:
Set( recordToSubmit, { 'KPName': { Value: dc_KPName.Selected.Value }, 'KPDate': dc_Date.SelectedDate, 'KPValue': Value('dc_KP Result'.Text), 'KP_Id': KP_Id, OCDepartment: { Value: "OCD" }, Location: { Value: "Paris" }, 'PersoninCharge': { Claims: "i:0#.f|membership|" & varCurrentUser.Email, DisplayName: varCurrentUser.FullName, Email: varCurrentUser.Email } } ); Patch( 'KP Tracking Target', // SharePoint list name Defaults('KP Tracking Target'), recordToSubmit );
Add the Department Column (Optional):
Validate the Schema:
PersoninCharge
Patch
Monitor
Patch( 'KP Tracking Target', Defaults('KP Tracking Target'), { 'KPName': {Value: dc_KPName.Selected.Value}, 'KPDate': dc_Date.SelectedDate, 'KPValue': Value('dc_KP Result'.Text), 'KP_Id': KP_Id, OCDepartment: {Value: "OCD"}, Location: {Value: "Paris"}, 'PersoninCharge': { Claims: "i:0#.f|membership|" & Lower(varCurrentUser.Email), Department: "", DisplayName: varCurrentUser.FullName, Email: varCurrentUser.Email, JobTitle: "", Picture: "" } } )
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.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
11manish 221 Super User 2026 Season 2
WarrenBelz 188 Most Valuable Professional
Mohsin Ali 120