Can't insert Date/time in format dd.MM.yyyy in SharePoint list

Like (0) Share

Report

Posted on 13 Jul 2023 10:20:13 by Kalakosha

Hi everyone!

I have a simple task. When a user receives an email, it is necessary to update the corresponding entries in the SharePoint list.

The SharePoint list contains a column ReportDay in the Date/Time format (only Date).

The problem is that I can't update the value of this column in the format dd.MM.yyyy. (for example 13.07.2023)

I can do it manually in the Sharepoint list. Through the application that I made in Power Apps- I can too. But via flow doesn't work.

Flow ends with an error:

Action 'Update_item' failed
The 'inputs.parameters' of workflow operation 'Update_item' of type 'OpenApiConnection' is not valid. Error details: Input parameter 'item/ReportDay' is required to be of type 'String/date'. The runtime value '"13.07.2023"' to be converted doesn't have the expected format 'String/date'.

Tried a lot of things.
The last thing I tried.

Created a variable Today, then substituted into Compose action with Expression

formatDateTime(variables('Today'),'dd.MM.yyyy')

, then substituted into Update item action

At the output get the folowing:

In the same time I can insert manualy date 13.07.2023 in ReportDay column in SharePoint list

What am I doing wrong?

Thanx in advance!

I have the same question (0)

All responses (5)

Answers (1)

tatmaninov 104 on 13 Jul 2023 at 10:41:41

Like (0)

Report

Re: Can't insert Date/time in format dd.MM.yyyy in SharePoint list

My guess is when you change the format in the flow you effectively change the date to a string and it is not recognised in the list anymore. I think you just need to change the formatting of your list under column settings to change the way the date is shown in the list.

Was this reply helpful? Yes No
Verified answer

ManishSolanki 15,089 Super User 2025 Season 2 on 13 Jul 2023 at 10:42:18

Like (0)

Report

Re: Can't insert Date/time in format dd.MM.yyyy in SharePoint list

Hi @kalakosha

Pls use the below expression for saving datetime column in SharePoint:
formatDateTime(variables('Today'),'yyyy-MM-dd')

If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.

Thanks

Was this reply helpful? Yes No
tatmaninov 104 on 13 Jul 2023 at 10:58:48

Like (0)

Report

Re: Can't insert Date/time in format dd.MM.yyyy in SharePoint list

Calculated column with these settings
Achieves this;

Was this reply helpful? Yes No
Kalakosha 62 on 13 Jul 2023 at 11:54:11

Like (0)

Report

Re: Can't insert Date/time in format dd.MM.yyyy in SharePoint list

Hi and thank you for you help!
Yes, your trick works.
But the date value in the SharePoint list instead of 13.07.2023 is displayed as 12.07.2023.
Although the flow tracking shows that the value is updated on 13.07.2023.
But on SharePoint list I see

Is this a regional setting for the SharePoint site?

Was this reply helpful? Yes No
ManishSolanki 15,089 Super User 2025 Season 2 on 13 Jul 2023 at 12:44:52

Like (0)

Report

Re: Can't insert Date/time in format dd.MM.yyyy in SharePoint list

Hi @kalakosha

Yes, you are right but internally SharePoint stores datetime field in 'yyyy-MM-dd' format.

If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.

Thanks

Was this reply helpful? Yes No