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.

Categories:

General topics

I have the same question (0)

All responses (2)

Answers (2)

Verified answer

Nived_Nambiar 18,129 Super User 2025 Season 2 on at

Like (1)

Report

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

Was this reply helpful? Yes No
Verified answer

gddowns 14 on at

Like (0)

Report

@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.

Was this reply helpful? Yes No