You’re offline. This is a read only version of the page.
2
Hello,
Im relatively new in creating desktop flows but have encountered an issue when writing dates back to excel with a great deal of inconsitencies
I have a flow which looks at a HTML table and then writes it back to excel.( Below is the variable value which reads correctly, dd/MM/yyyy ).
When it writes back to excel, it is doing so in a different format ( mm/dd/yyyy) for some of the dates. There are thousands of rows its writing back but this is an example of a correct and incorrect output into excel ( Row 2 is the example of the variable shown above )
Coincidentally, the dates that are incorrect in the excel output file ( 2nd row )are all aligned right with a space in the cells ( columns D,E and F ) while the correct date formats ( 1st row ) are aligned left. Not sure if this is coincidentally but seems quite odd behaviour.
The values are date formatted and not text value
I have researched for possible fixes. Checked OS setting, excel formatted cells/columns and tried troubleshooting the flow but have not had any success.
Any assistance would greatly be appreciated
Share
Report
All responses (
Answers (
