Hello,
I'm not sure if this is a Power Automate or an Excel issue but I thought I would try here first.
we have an online system for referrals which uses Microsoft Forms.
Since the recent update to Microsoft Forms took away the automatic update feature to its associated spreadsheet, I have set up a flow to transfer the data from the forms into an Excel spreadsheet when a form is filled in.
this is working well and is transferring the data to the spreadsheet.
However there is a issue with the 'Client Date of Birth' field.
We are in the UK and all the date fields are set up with the 'dd/MM/yyyy' date format.
I have also used 'FormatDateTime' to set the date format to 'dd/MM/yyyy'
However when the data is transferred to the spreadsheet, if the 'day' part of the date of birth is between 1 and 12, Excel then swaps the date round.
This date was inputted as 08/03/1996.
I have another flow which transfers the form data into a pdf. This transfers the date correctly:
I have checked every regional setting on the browser, Sharepoint, Excel, Forms, Windows and they are all set to UK.
The column on the spreadsheet is set to UK date in the format dd/MM/yyyy.
If the day number is bigger than 12, then it stays as the correct format.
Any ideas why this is being swapped?
Thanks
