making a csv file everyday but on day 2 there is not only the new data but also the data from day 1 in the csv

Maebe Xander 0

so for my final i need to make a csv with data from a sensor and every day at 0:00 the data should be put in that csv file the problem that is occuring is that whenever the second day is there that the data from day 1 is also in the csv from day 2 even tho we only want the data that the sensor has sent to us on that day below you see my logic app and how everything is set up right now User's image

User's image

Aki Nishikawa 1,305 Reputation points Microsoft Employee

2024-06-15T06:16:37.96+00:00

Hello @Maebe Xander , Sorry to be so direct, but could you please check if you can retrieve all data emitted on the last day using your SQL statement running on your Logic App? I suppose you can retrieve data filtered by where-clause in the SQL statement, but if all data in the target table are retrieved, you should modify the statement.
Maebe Xander 0 Reputation points

2024-06-15T08:15:47.1066667+00:00

hello @Aki Nishikawa euhm im not sure what your asking her but if your aksing if iam getting all the data in my sql statment then yes that statment is just reading all the data in the database instead of only the new data since the last run

Share via

making a csv file everyday but on day 2 there is not only the new data but also the data from day 1 in the csv