Forum Discussion

arturdomanski's avatar
arturdomanski
Copper Contributor
Nov 01, 2024

Issues with populated by Power Automate Date and Time column in excel

Good day.

I created a Power Automate flow that takes a date and time and populates them into an Excel spreadsheet. However, once imported, the date and time are recognized by Excel as text, not as date and time values. This persists until I select the cell, place my cursor in the formula bar, and press Enter. Only then are they recognized as date and time. I am using formatDateTime in Power Automate to export the date and time.

Any help would be appreciated.

No RepliesBe the first to reply

Resources