cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Djccwl
Frequent Visitor

Adding a date when adding a row in excel table

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 

2 REPLIES 2
Hardesh15
Super User
Super User

@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

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? 

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (4,401)