HI All,
I am adding data from an email into an excel sheet.
When an email is flagged in a specific folder the data from a table in the body of the email is added to an excel sheet along with the received time of the email.
I have initialised a string variable ('Date') for the received time and used the following expression when adding to an excel cell :
formatDateTime(variables('Date'),'dd/MM/yyyy')
If there is only one concurrence of the flow I get the correct date format dd/mm/yyyy, if it is running more than once concurrently I get the incorrect date format mm/dd/yyyy.
Is this a bug? I am using the received time dynamic content from the trigger so cannot see how the input data could be inconsistent.
