Store power query value in csv(sharepoint) in Power Automate

[insandur]

i am trying to get the power query value in csv file storing it in sharepoint, but everday the value just replaces the old one in csv and i want it to append the value and get all the values daily to show the trend.

Output:

Expected output:

[lbendlin]

"Update file"  means overwrite its contents. The flow does what you asked it to do.

If you meant to say "Append" - that may not even be possible with CSV files.  You can sort of do this with Excel files and table ranges, but it will be excruciatingly slow.