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

Hackney, Jim 1 Reputation point
2021-04-20T15:35:09.607+00:00

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?

Azure Logic Apps
Azure Logic Apps
An Azure service that automates the access and use of data across clouds without writing code.
1,824 questions
No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Pramod Valavala 14,546 Reputation points Microsoft Employee
    2021-04-21T17:12:49.007+00:00

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