Adding a date when adding a row in excel table

[Djccwl]

Hey everyone 

Ive got a flow set up where I add a row to an excel table every day and also another one for every week (based on data in another sheet that captures some NPS feedback). In the sheets that I add the row to u have a date column that I want to capture the date that the data is added but I cannot for the life of me work out how to set that? I was hoping that using an existing date +1 formula (or +7 for the weekly sheet) would work but it doesn’t seem to add anything automatically. 

Any guidance would be massively appreciated. 

cheers

dave 

[Hardesh15]

@Djccwl 

Create a Date column in excel sheet and use utcnow() in add row action. you can convert time based on your time zone.

Thanks

Hardesh

[Djccwl]

Thank you 🙂 

I just need the date added so if I have the excel field set to date only will that mean just the date will show?