I have a flow that is created upon adding a row to a table. In this, I want to select from 3 separate tables based on the row added to get some preliminary information to then create a new row in another table. For instance
1 When Row Added table A
2 Get values from table B based on a column from Table A (return 1 row)
3 Get Values from Table C based on a column in Table A (Many Rows)
4 Get Values from Table D based on a column in Table C (Return 1 row)
5 Get Values from Table E based on a column in Table C (Return 1 row)
6 Add New Row to Table F based on values from table A, B, C, D and E <
I do want a For Each in Table C to add multiple rows. But when I save the flow, it adds For Each for all selections BEFORE the Add New Row to Table F. I'm not getting any rows created.
If I take step 2, 4 and 5 out, it works fine.
