web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Error in Power Apps an...

Power Apps

Suggested Answer

Error in Power Apps and SQL

(1) Share

Report

Report

Posted on by ShadrackKip

2

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"

Screenshot 2024-08-24 114043.png

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (0)

Sort by

Nandit 1,568 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!

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 2,001 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
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

Join the conversation