cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
osama571
New Member

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

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 

1 ACCEPTED SOLUTION

Accepted Solutions
gabibalaban
Dual Super User
Dual Super User

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

View solution in original post

4 REPLIES 4
gabibalaban
Dual Super User
Dual Super User

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

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

'''

 

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.

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 

Helpful resources

Announcements
Power Platform Call June 2022 768x460.png

Power Platform Community Call

Join us for the next call on August 17, 2022 at 8am PDT.

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Users online (3,447)