Using Power Apps to view and update items in Azure SQL. Any update function fails with Bad gateway 502 error. My research says I cannot just submit a form, but that I can use PATCH and each individual field with code as follows (tedious but simple enough). Am I missing something? I do not see anything in the server log.
Patch(
Student,
LookUp(Student, Student_TAF_Key = Gallery1.Selected.Student_TAF_Key),
{
Student_Media: Text(editform_UserDetails.LastSubmit.Student_Media) // Make sure to convert to the appropriate data type
// Include other fields as needed
}
)

Report
All responses (
Answers (