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
Super User
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
Super User
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

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
2022 Release Wave 1 760x460.png

2022 Release Wave 1 Plan

Power Platform release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.

User Group Leader Meeting January 768x460.png

Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Top Solution Authors
Top Kudoed Authors
Users online (3,217)