
Announcements
I have a workflow that parses an XML file and appends data to an existing online excel file. This is working perfectly except for the date field. I need to field to be in the UK format of dd/mm/yyyy and so, I set the date field in Excel to this date format. The Power Automate parses the XML file and extracts the date as a string. I confirmed the sting is correct and I can see the flow executing successfully and using the UK date format.
However, when I check the excel, I see the date in for US format of mm/dd/yyyy. I have to manually correct the dates on the excel. The very weird thing is that the automatically entered date format start to work fine after that and is shown as the UK format. This issue always happens at the start of a new month and works fine afterwards.
Does anyone have any clue why this might be happening?
Thanks,
John