Would it be possible to share the schema details of the table? One more thing, the exact error message Power Apps shows when we try to patch?
One part is good that the reading of data works but patching does not, I suspect the following areas:
Suspected Area-1: The designated table might have a required column I consider primary key also or non-nullable fields that must be included in patch statement. If you only patch {iPadNum:2} but other required columns are missing, the patch will fail.
Suspected Area-2: The column iPadNum must be numeric and match the data type you’re patching. Are we passing string if it expects int?
Suspected Area-3: Again, as we can read data but write fails, the connection might have read permission but not insert/update permission on the table!
Suspected Area-4: Sometimes Azure SQL tables require fully qualified names, for example, if table name is TestingTable is in the default schema dbo, the fully qualified name would be: dbo.TestingTable.
Meanwhile, a common approach to patching Azure SQL table is to include all required fields and the primary key (if updating), for example:
Patch(
TestingTable,
Defaults(TestingTable),
{
iPadNum: 2,
-- Let's include other required columns here with appropriate values
}
)
I am sure some clues I tried to give. If these clues help to resolve the issue brought you by here, please don't forget to check the box Does this answer your question? At the same time, I am pretty sure you have liked the response!
