Insert data to Microsoft Azure

Hi everyone. I would like to ask about why the Microsoft Azure every time just get one to two data only? how to solve this problems? Because my flow is when the groov view detected “1” or “0” I need to store the data in database.



and I tried to change my flow to the following pic also cannot. They just send 2 data to Microsoft Azure SQL Database.(actually I want to send all the data)
image

TQVM.

Rather than having separate wires and separate insert statements for each piece of data, perhaps you could try getting the data one piece after another, building up your data set and then use just one insert statement.

For example you have your nodes set up like this:

Try something more like this:

This method could make it much more straightforward to send all the data at once.

3 Likes