How to get only modified rows from SQL Server "When an item is modified (V2)"

[osama571]

Hi, 

I am using "When an item is modified (V2)" and when an item is modified in SQL table, I am getting all rows from the table as output, but I wanted to get only the modified rows from the table.

How can I do that?

Thanks in Advance 

[gabibalaban · Accepted solution]

@osama571 ,

Actually, the trigger "When an item is modified (V2)" returns only the modified item, is impossible that this trigger to return all table rows . Can you put a screenshot of your flow to understand better what you are trying to do ?

[osama571]

Hi @gabibalaban,

at start I am sending SQL query to update the rows in table (its should update only if the row is different)

and next step I should get the rows which are modified, but I am getting all the rows from the table which are 35 rows.

Here is my SQL code 

'''

update Table_name1 set Table_name1.[online]=a.Newstate from
(
select Table_name_View.[online] as Newstate from Table_name1
join Table_name_View on
Table_name1.Customer=Table_name_View.Customer and
Table_name1.name=Table_name_View.name
where Table_name1.[online]!=Table_name_View.[online]) a

'''

[gabibalaban]

There is no action in power automate called “When an item is modified”, only triggers. Most probably you renamed an existing “Get items” action.

Please check the outputs of the “Execute the SQL query” action to see if the server returns something useful, like primary key of the affected rows.

[osama571]

I didn't know that the "When an item is modified (V2)" return only the modified rows. After you told me that I just checked my SQL Server and I found a mistake in it. Where every time the rows getting replace even if data are still the same and I just fixed it now and I am getting now the expected output.

my Problem is solved Thank you