Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Microsoft Dynamics CRM (Archived)

Saving Data to SQL SERVER

(0) ShareShare
ReportReport
Posted on by 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

  • Suggested answer
    Alex Fun Wei Jie Profile Picture
    33,626 on at
    RE: Saving Data to SQL SERVER

    Hi,

    Please post your question on powerapps forum.

    powerusers.microsoft.com/.../PowerApps1

  • CRM Beginner  Profile Picture
    795 on at
    RE: Saving Data to SQL SERVER

    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
    Mahendar Pal Profile Picture
    45,095 on at
    RE: Saving Data to SQL SERVER

    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
    795 on at
    RE: Saving Data to SQL SERVER

    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
    45,095 on at
    RE: Saving Data to SQL SERVER

    Hi,

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

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

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Adis Hodzic – Community Spotlight

We are honored to recognize Adis Hodzic as our May 2025 Community…

Leaderboard > Microsoft Dynamics CRM (Archived)

#1
Mohamed Amine Mahmoudi Profile Picture

Mohamed Amine Mahmoudi 83 Super User 2025 Season 1

#2
Community Member Profile Picture

Community Member 54

#3
Victor Onyebuchi Profile Picture

Victor Onyebuchi 6

Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans