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:

Building Power Apps

Screenshot 2024-0...

I have the same question (0)

All responses (2)

Answers (0)

Nandit 1,568 Moderator on at

Like (1)

Report

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

Was this reply helpful? Yes No
Suggested answer

MichaelFP 1,847 Super User 2025 Season 2 on at

Like (0)

Report
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;

Was this reply helpful? Yes No