Share via

Azure Logic app

Power BI Admin Ciel 0 Reputation points
2024-04-11T08:57:49.57+00:00
  1. created a flow in logic apps to insert multiple records into SQL table.
  2. The pipeline is executed successfully but the data is not inserted into SQL table.
  3. Below is the pipeline which i built using for each, so here i have multiple json data i need to insert all those into sql table.
    User's image
Azure SQL Database
Azure Logic Apps
Azure Logic Apps
An Azure service that automates the access and use of data across clouds without writing code.
SQL Server | Other

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. MayankBargali-MSFT 70,986 Reputation points Moderator
    2024-04-12T05:54:38.4033333+00:00

    @Power BI Admin Ciel Thanks for reaching out.

    As per your workflow screenshot, I can see your Insert row (v2) action is outside your for each 2 loop. This (Insert row (v2)) action should be inside your foreach 2 action so all the 16 iteration the insert row should be execute and inserted to the SQL DB.

    In your insert row V2 action make sure you are passing the value correctly as per your table schema.

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.