Questions regarding Azure Logic App Get Row(v2) and Insert action

Question

I want to build a logic app that will be triggered whenever a new row is entered into a table of database A. Once triggered, I want the logic app to get that row and insert it into a table in database B.

My plan is to use "When an Item is Created(v2) as the trigger and the actions will include Get Row(v2) and Insert Row(v2).

The Get Row(v2) action asks for a Row Id which for the table is named BMA_DATA_FORM_ID. If I use the dynamic row id of the same name, will it automatically take the last row? If not, is there a way to ensure it takes the last row or should I instead use the Get Rows(V2) action where I have more control choices?

Also, When I insert the row using the Insert Row(v2) action, it asks for the BMA_DATA_FORM_ID. If I set this to dynamic, will it be using the data from the Get ROW(v2) action as its input?

Answer 1

@Hackney, Jim The Row ID here is the built-in field that identifies each row and not the application specific field. The trigger payload should have the Row ID that can be used for the Get Row action, which should return the application specific field's value which can be used in the Insert Row action.