Date Time format problem in Sharepoint List

(0) Share

Report

Posted on by ZowieS

124

Hi,

I've been stuck for awhile now and the different solutions dons't seems to work for me.

I have a "Date and Time" column in SharePoint:

2020-05-27 18_04_16-Microsoft Store.png

And when it's approved or denied the result looks like this:

2020-05-27 18_04_30-Frånvaro - Ledighet - All Items.png

(The time "02:00" is something that I don't set. The code for the input is:

utcNow('MM/dd/yyyy')

)

I want to add the actual time in 24h format but I only get this error:

2020-05-27 18_08_20-Run History _ Power Automate.png

OpenApiOperationParameterTypeConversionFailed. The 'inputs.parameters' of workflow operation 'ESM_-_Update_item:_Approved' of type 'OpenApiConnection' is not valid. Error details: Input parameter 'item/ApprovalDate' is required to be of type 'String/date-time'. The runtime value '"27-05-2020T16:04:56"' to be converted doesn't have the expected format 'String/date-time'.

I have tried these expressions:

convertTimeZone(utcNow(),'UTC','W. Europe Standard Time','dd-MM-yyyyTHH:hh:mm')

convertTimeZone(utcNow(),'UTC','W. Europe Standard Time','dd/MM/yyyyTHH:hh:mm')

utcNow('dd-MM-yyyyTHH:hh:mm')

utcNow('dd/MM/yyyyTHH:hh:mm')

Anyone have any idé?

Thank you!

All responses (7)

Answers (1)

GE_AC 2 on at

Like (0)

Report

Re: Date Time format problem in Sharepoint List

Does the time zone take into account the summer time?
ZowieS 124 on at

Like (0)

Report

Re: Date Time format problem in Sharepoint List

@ScottShearer wrote:
@ZowieS
You can update the column value using the expression utcNow() with no additional formatting.
If your issue is that you want the time displayed in a 24 hour format, you need to make a change to the SharePoint site settings.
Go to the site settings page and then click on Regional information under the Site Settings group. At the bottom, change the time format to 24 hour. This will impact the entire site - not just this list.
Hi,

Yes, the Sharepoint Site has that time format and Locate is "Sweden".
ZowieS 124 on at

Like (0)

Report

Re: Date Time format problem in Sharepoint List

@rohentz wrote:
Hi @ZowieS how are you?

Just a doubt, are you using Approvals?

If so, did you try to use the "Completion date" attribute?

Sample:

Please let me know if you have doubts or concerns about the solution provided.

Regards.

Rodrigo Hentz
Microsoft Support Engineer

Hi,

Ah, Thank you!
I missed that and that solved the problem 😁
ZowieS 124 on at

Like (0)

Report
Re: Date Time format problem in Sharepoint List

@efialttes wrote:
Hi!
When udating your Sharepoint item, did you also tried with the following expression as DateTime column input?

utcNow()

Thanx!

Hi,

Ah, It might just be that simple 😅
But I haven't tested that since it worked with the approval date.

Thank you!
ScottShearer 25,228 Most Valuable Professional on at

Like (2)

Report

Re: Date Time format problem in Sharepoint List

@ZowieS

You can update the column value using the expression utcNow() with no additional formatting.

If your issue is that you want the time displayed in a 24 hour format, you need to make a change to the SharePoint site settings.

Go to the site settings page and then click on Regional information under the Site Settings group. At the bottom, change the time format to 24 hour. This will impact the entire site - not just this list.
Verified answer

Rodrigo Hentz on at

Like (1)

Report

Re: Date Time format problem in Sharepoint List

Hi @ZowieS how are you?

Just a doubt, are you using Approvals?

If so, did you try to use the "Completion date" attribute?

Sample:

Please let me know if you have doubts or concerns about the solution provided.

Regards.

Rodrigo Hentz
Microsoft Support Engineer
efialttes 14,756 on at

Like (1)

Report
Re: Date Time format problem in Sharepoint List

Hi!

When udating your Sharepoint item, did you also tried with the following expression as DateTime column input?

utcNow()

Thanx!