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!

Categories:

Building flows

I have the same question (0)

All responses (7)

Answers (1)

efialttes 14,756 on at

Like (1)

Report
Hi!

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

utcNow()

Thanx!

Was this reply helpful? Yes No
Verified answer

Rodrigo Hentz on at

Like (1)

Report

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

Was this reply helpful? Yes No
ScottShearer 25,270 Most Valuable Professional on at

Like (2)

Report

@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.

Was this reply helpful? Yes No
ZowieS 124 on at

Like (0)

Report
@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!

Was this reply helpful? Yes No
ZowieS 124 on at

Like (0)

Report

@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 😁

Was this reply helpful? Yes No
ZowieS 124 on at

Like (0)

Report

@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".

Was this reply helpful? Yes No
GE_AC 2 on at

Like (0)

Report

Does the time zone take into account the summer time?

Was this reply helpful? Yes No