Need help to automate below step.
300 users add file with extension (*.csv) in a shared folder.
End of the day I download the entire folder and extract file (as folder gets downloaded in .zip format)
After extracting, I run command I'm CMD : "COPY *.CSV COLLATED.CSV"
This helps me to merge all 300 file in one go.
I'm looking forward If we can use flow or Power BI to automate this and New collated file on same folder of SharePoint.