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.
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:
Best Regards,