Hi Experts, I spent three hours in this forum to find a solution for my problem, so I know questions concerning this have been posted quite often, but I could not find a solution for me. Please help.
My problem is that I want to read out an excel file and generate emails with the Information.
I use "List rows present in a table" to read from excel, format date as "ISO 8601" and also formated all excel cells of the required column as Date-Format.
But this action persist to read the date as Serial Number format. What can I do to read it correctly or convert it in a simple way to use it in the email to be created.
Thank you, but I think there must be a way to get ISO format from the excel directly, therefore this option can be choosen in the List Rows activity. Does it need a special way to be formated in the excel?
Your video was helpful for filtering, but I just want to put the date into mail, is there no possibilty to just change format of display of the date?
It is not just for filtering. But a way of showing how to convert the numeric date into a proper format.
Would you be able to read the cell value -> change the format as mentioned in video using a Compose statement -> then write it into your email?
I know this is late reply and you probably found a solution to all this, but I was also having the same problem as you are.
After doing some test I found the issue and it seems like it will entirely depend on what type of value is at the first cell of the column.
In your case, based on your attached Excel image, the very first cell of your "Deadline" column (R2) is empty which would result in the rest of the cells on that column to become serial number instead of ISO 8601. It must be in a date format; it cannot be anything else.
I don't know why it's like this but here's my solution based on your images.