I have data in collection trying to patch it with sql db where I want to patch only 2 columns in sql db

I have data in collection trying to patch it with sql db where I want to patch only 2 columns in sql db
Hi @umangd ,
It seems that there is a syntax issue with the Patch function.
If you want to create a record, the formula is like:
Patch( DataSource, Defaults(DataSource), {...})
If you want to update a record, the formula is like:
Patch( DataSource, theRecord, {...})
You could refer to the following link:
Patch function in Power Apps (contains video) - Power Platform | Microsoft Learn
Best Regards,
Habsburg Qian
If this post helps, then please consider Accept it as the solution to help the other members find it.