Name CSV file and add 'Date' column to the data in Power Automate app (sharepoint storage)

[insandur]

Hi,

I get a 'csv' file everyday with name 'Stockout report.csv' and i want to store everyday data in sharepoint with date in the file name eg. '1/16/2023.csv' and also want to add a date column to the data. 

[pratyashasamal]

Hi @insandur ,
You added a date column in Power Query using TODAY().
You can reffer to this document for more info on TODAY() : https://learn.microsoft.com/en-us/dax/today-function-dax

Thanks ,
Pratyasha Samal
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C

[insandur]

Hi Pratya,

Thanks for reply. I was asking how to add date column in Power automate.