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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Update a specific fiel...
Power Automate
Answered

Update a specific field in SQL table

(0) ShareShare
ReportReport
Posted on by 422

Hello all,

 

i want to update a specific field base on some SQL update syntax , i don't want to update whole row just a field. how can i achieve it ?

For Example my SQL update Syntax is 

update Table1 set Column1=REPLACE(Column2,'AAA','BBB')

So immediately after get row from sql i want to update field. I believe it can be achieve using  Execute SQL query Action , but what to write in query text and formal parameter ?

If there is any other way to make it please advise

Categories:
I have the same question (0)
  • Verified answer
    ArchitectMadhan Profile Picture
    1,584 on at

    @SachinG31 , There is no easy way to execute SQL query directly from Flow, Instead you can create a Stored Procedure in SQL Server and call it from Power Automate. Step by step process for that is given in the below link.

    https://www.mssqltips.com/sqlservertip/6857/call-sql-server-stored-procedure-from-power-apps/

     

    Please accept it as solution and give thumbs up, if it works for you.

  • SachinG31 Profile Picture
    422 on at

    Hello @ArchitectMadhan ,

     

    Sorry for the late revert , As advised i have created a stored procedure and adding action for the same to update field.

    Its working good for me , Thank you so much  

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the March Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Haque Profile Picture

Haque 570

#2
Valantis Profile Picture

Valantis 405

#3
11manish Profile Picture

11manish 350

Last 30 days Overall leaderboard