Answered

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

(0) Share

Report

Posted on 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!

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (1)

Sort by

tatmaninov 104 on at

Like (0)

Report
Copy link

Link copied!

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

Manish Solanki 15,167 Moderator on at

Like (0)

Report
Copy link

Link copied!

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 at

Like (0)

Report
Copy link

Link copied!

Calculated column with these settings
Achieves this;

Was this reply helpful? Yes No
Kalakosha 62 on at

Like (0)

Report
Copy link

Link copied!

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
Manish Solanki 15,167 Moderator on at

Like (0)

Report
Copy link

Link copied!

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