Answered

When using Add a row into a table, how do you insert a timestamp for when that row was added?

(0) Share

Report

Posted on by gddowns

I am looking to track when a file is added to a specific folder. I am able to add a row to an existing table in excel and add details related to the file added; however, I am unable to add the date and time for when the row was added. See current attributes below.

I was able to create a VBA macro that would do it for me but I can't reference a File with Power Automate that is a xlsm format. Does anyone know of a solution to my issue? Thank you.

All responses (2)

Answers (2)

Verified answer

gddowns 14 on at

Like (0)

Report

Re: When using Add a row into a table, how do you insert a timestamp for when that row was added?

@Nived_Nambiar

That worked exactly how I wanted it to. The only thing I changed was the date format as you suggested I may have needed to so that it was legible by Excel. Below was the final result. Thank you.
Verified answer

Nived_Nambiar 17,608 Super User 2025 Season 1 on at

Like (1)

Report

Re: When using Add a row into a table, how do you insert a timestamp for when that row was added?

Hi

you can use utcnow() function to add timestamp when the row was added just like below

utcnow() represents current time in utc format

if you want to convert the utc time to other time use below function there instead so to convert to specific timezone for current time.

https://zeitgeistcode.com/power-automate-convert-time-zone/

Thanks & Regards,
Nived N 🚀

LinkedIn: Nived N's LinkedIn
YouTube: Nived N's YouTube Channel

🔍 Found my answer helpful? Please consider marking it as the solution!
Your appreciation keeps me motivated. Thank you! 🙌

@gddowns