Error in Power Apps and SQL

(1) Share

Report

Posted on by ShadrackKip

I am building an application that patches records from Power Apps to SQL server, however I am having trouble with some screens. I have 4 screens that had the same error, and I fixed it by changing some settings in SQL to allow write rights to SQL.

I cannot remember the settings well. I would appreciate any help with this. I have attached the screenshot of the error message which is "The function Patch has some invalid arguments"

Categories:

Connectors

Connecting to Data

Mobile App

Screenshot 2024-0...

All responses (2)

Answers (0)

Suggested answer

MichaelFP 1,827 Super User 2025 Season 1 on at

Like (0)

Report
Error in Power Apps and SQL

Based on what you said, you need to include this table to have write access for the user used in the SQL connection. For this you can run the following T-SQL to give access for the user on your table

GRANT INSERT, UPDATE, DELETE ON table_name TO user_or_role;
Nandit 1,563 Super User 2025 Season 1 on at

Like (1)

Report

Error in Power Apps and SQL

Hi ShadrackKip,

This error message is not enough for me to make some suggestions. It would help if you could share the full Patch function here (obviously hiding anything that's confidential). That way it will be easier to assist you resolve this.

Kind regards,

Nandit