Data format from function not retained during writing - Bug?

[zwornik80]

Hi

I have two columns with date. First column "Planned delivery" is already populated and has format "dd/mm/yyyy". Second columns "Today date" is created by flow and should reflect current date. To create column "Today date" I have used following expression in "compose": 

formatDateTime(utcNow(),'dd-MM-yyyy')

Below is output from "compose" after flow run:

As you can see above it has "dd-mm-yyyy" format. But the format in populated column "Today date" is different i.e. mm/dd/yyyy:

 Both columns are formatted as "Date and Time" with the same settings (Display Format: Standard etc...)

Can anybody suggest why this is happening?

[ChristianAbata]

hi @zwornik80  this is because you need to change your sharepoint column view see

https://www.c-sharpcorner.com/blogs/sharepoint-how-to-change-date-format-on-a-site-or-list

[zwornik80]

Hi @ChristianAbata 

I have changed my Regional Settings to "English (United Kingdom)" long time ago - to make desired date format. I have several other columns with dates, and all are OK, probable because were entered manually, not from flow calculation. I suspect it is another bug in MS Flow. 

[mequan]

Hi zwornik80,

May I know if your data source is sharepoint? If yes, you may need change share point column time format. You need select as English(Canadian).

Please check more information from https://sharepointmaven.com/change-date-format-sharepoint/ .

Thanks

[zwornik80]

@mequan My data source is SharePoint List. I have changed language to "English (Canadian)" and again only "Today date" was displayed incorrectly i.e. "2020/12/08" ("yyyy/dd/mm"). Other date columns had this OK i.e. "yyyy/mm/dd". 

[mequan]

Hi Zwornik80, If you use sharepoing as a data source, then data column in sp list will follow column configuration. For flow, we only send data time to sp list, we may not define sp column data format.  But you may try configure it as https://www.c-sharpcorner.com/blogs/sharepoint-how-to-change-date-format-on-a-site-or-list or configure the sp column type as text, then it will show data format as flow shows. Thanks

[zwornik80]

@mequan My column "Today date" must be in "Date and Time" format because I am using it in formula (in another column) to check if "Today date" exceeded "Planned date" (also found in SharePoint List). Link that You have provided seem to expire (page not found). 

[mequan]

Hi zwornik80,

Because flow may not change format on sp data and time column, so you need do changes on sharepoint side.

Please review following documents.

1. https://www.sharepointdiary.com/2018/06/change-date-format-in-sharepoint-online-using-powershell.htm...

2. https://www.c-sharpcorner.com/blogs/sharepoint-how-to-change-date-format-on-a-site-or-list

Thanks