I am encountering an error in my Patch function, stating that there are invalid arguments when trying to use the table (as shown in the attached image). Here are the potential solutions I have tried:
The code works in the production environment with a different SQL Server connection, but it does not work in the development environment. I have verified that there is no connection issue there.
The table is utilized in Power Automate, and the flow successfully fetches rows, confirming that the connection is functional.
I created a new connection and tested it, but the same error persists.
It was previously working without issues, but this error has suddenly appeared.
Do you have a Primary key in your SQL Table. Is error usually occurs when that's missing. I'd suggest adding that as that might take the error away.
Hope this helps.
Kind regards,
Nandit
If this answers your query, please mark this response as the answer.
If its helpful, please leave a like. Thanks!
Was this reply helpful?YesNo
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.
Share
Report
All responses (
Answers (
1,568
