Skip to main content

Notifications

Power Automate - Using Connectors
Answered

Create A Flow That Inserts Date and Time in Excel

(0) ShareShare
ReportReport
Posted on by

I need to create a flow that will insert a date and time stamp in excel when someone enters information in a certain cell. 

 

I have a form that gets filled out. 

The answers get pulled into a excel spreadsheet.

The spreadsheet has a couple of blank columns. 

When one of the columns gets information entered in (manually), I would like a date and time stamp to fill in a separate column. 

 

I tried using a now or today formula but it will not fill down correctly when a new form answer is submitted. 

 

 

  • Verified answer
    v-bacao-msft Profile Picture
    v-bacao-msft on at
    Re: Create A Flow That Inserts Date and Time in Excel

     

    Hi @halleyk ,

     

    Could you share a screenshot of your Flow configuration?

    If you want to insert today's date into the specified column, you can use the utcNow() function.

    Like:

    179.PNG

     

    Best Regards,

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,422

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,711

Leaderboard

Featured topics