Hi,
I am working on a project where I create an input form to track the engineering departments project hours. This is linked to a SQL Server table.
The issue arises when I click the submit button and I'm faced with either 'the requested operation is invalid, Server response failed' or 'network error when using patch function'. I have tried to use the code 'SubmitForm(Form_Hours)' where Form_Hours is the name of the form, however, I have also tried the patch function 'Patch(Hours, Defaults(Hours), {Milestone:milestone1.Text})' where milestone1 is the text input for the milestone card. The form also contains combo boxes and a component inputs so I just attempted to troubleshoot using the one input in the patch function.
It's possibly an issue with permissions/connection to database but I believe I have granted necessary permissions? The code was entered into onselect and the relevant tables appear as a datasource on power apps.
Any help regarding this issue would be greatly appreciated!
Thanks

Report
All responses (
Answers (