Answered

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

(0) Share

Report

Posted on by 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

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

Verified answer

CU-18081211-6 9,272 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
osama571 6 on at

Like
a
(0)

Report
Copy link

Link copied!

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
'''

Was this reply helpful? Yes No
CU-18081211-6 9,272 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
osama571 6 on at

Like
a
(0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No