I have two sql tables:
Table A: Unique A_PK
Table B: Foreign key A_PK with multiple entries
My flow starts with a trigger "When an item is modified" reading Table B returning A_PK. Then I want to get all rows from Table B where it equals A_PK from trigger. There could be up to 5 rows for the same A_PK from Table B. I tried using Sql "Get Rows" where I need the Status field from all rows where A_PK equals A_PK from trigger. This last part is where I need help with.
Once I get the Statuses from Table B, then I can evaluate and update Table A Status. That part I can do.
Thanks in advance.
