Forum Discussion
arturdomanski
Nov 01, 2024Copper Contributor
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