SQL Get Rows One to Many

(0) Share

Report

Posted on by loraDallas

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.

Categories:

General topics

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

CU-18081211-6 9,270 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi @loraDallas ,

Use the following:

Table Name: Table B

Filter Query: A_PK eq @{triggerBody()?['A_PK']} (or triggerBody()?['A_PK']) if you use dynamic content - expression )

Select Query: Status

Hope it helps !

Was this reply helpful? Yes No
loraDallas 42 on at

Like (0)

Report
Copy link

Link copied!

Thanks gabibalaban. I was using the dynamic expression from the trigger but didn't try adding the eq A_PK manually. I was afraid it wouldn't work, but it did. Thanks for your help.

Was this reply helpful? Yes No