Update a specific field in SQL table

(0) Share

Report

Posted on by SachinG31

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:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

ArchitectMadhan 1,584 on at

Like (1)

Report

@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.

Was this reply helpful? Yes No
SachinG31 422 on at

Like (0)

Report

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

Was this reply helpful? Yes No