web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics CRM (Archived) / Saving Data to SQL SERVER
Microsoft Dynamics CRM (Archived)

Saving Data to SQL SERVER

(0) ShareShare
ReportReport
Posted on by CRM Beginner 795

Hi,

I am working on PowerApps. I have 4 text fields in first screen and i have connected an Azure SQL service to connections and added a data source too. But, when i am using PATCH() to send data to SQL table, its throwing errors like "Patch has invalid arguments"..

I am not getting it. Can anyone help me out?

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Mahendar Pal Profile Picture
    Mahendar Pal 45,095 on at

    Hi,

    Please refer this KB for docs.microsoft.com/.../function-patch and make sure you are doing it correctly.

  • CRM Beginner Profile Picture
    CRM Beginner 795 on at

    Yes, i make it worked by adding a primary key in table. But, one doubt that is it not allowed to add local SQL SERVER in data source?

  • Suggested answer
    Mahendar Pal Profile Picture
    Mahendar Pal 45,095 on at

    You can do that but for that you need to use gateway, check this for more details:

    docs.microsoft.com/.../gateway-reference

    powerapps.microsoft.com/.../connect-to-your-on-premises-data-sources-using-on-premises-data-gateway-from-powerapps

  • CRM Beginner Profile Picture
    CRM Beginner 795 on at

    Yes, i have installed a gateway.. But, its still not visible under "Choose a on-premise gateway option" while adding a new connection to SQL Server. Do you have any idea , why its not visible there?

  • Suggested answer
    Alex Fun Wei Jie Profile Picture
    Alex Fun Wei Jie 33,628 on at

    Hi,

    Please post your question on powerapps forum.

    powerusers.microsoft.com/.../PowerApps1

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.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
SA-08121319-0 Profile Picture

SA-08121319-0 4

#1
Calum MacFarlane Profile Picture

Calum MacFarlane 4

#3
Alex Fun Wei Jie Profile Picture

Alex Fun Wei Jie 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans