Unanswered

Formatting date column in sharepoint list

(0) Share

Report

Posted on by Lagloire

Hello

I built a flow where i extracted datas from pdf with AI Builder model and fill a sharepooint list. I'm getting since the begining with date extracted from pdf or email body. Error message (The 'inputs.parameters' of workflow operation 'Create_item_in_the_minute' of type 'OpenApiConnection' is not valid. Error details: Input parameter 'item/field_3' is required to be of type 'String/date'. The runtime value '"31/01/2023"' to be converted doesn't have the expected format 'String/date'.) below in the sharepoint list.

Any help to solve this?

Categories:

Building flows

I have the same question (0)

All responses (9)

Answers (0)

Sundeep_Malik 6,484 on at

Like (0)

Report

Hey @Lagloire

Whats the data type of this field in your sharepoint list?
String or Date?

Was this reply helpful? Yes No
Lagloire 86 on at

Like (0)

Report

extrated date from pdf or email body is written like 01/01/2023 (french format)

Was this reply helpful? Yes No
Lagloire 86 on at

Like (0)

Report

it is as you can see on below image:

Was this reply helpful? Yes No
Sundeep_Malik 6,484 on at

Like (0)

Report

@Lagloire
Is there a possibility you can change the data type of this SP column to string/text instead of date and time???
Probably this issue comes while getting data from AI Builder.

Was this reply helpful? Yes No
Lagloire 86 on at

Like (0)

Report

Do you mean to change the type of information in this column from "Date and Time" to "Single or Multiple lines of text"?
O can you tell me how to make this change?

Was this reply helpful? Yes No
Sundeep_Malik 6,484 on at

Like (0)

Report

@Lagloire
Yup I mean that only, change it to single line of text. [Not working with SharePoint these days so forgot the exact term]

Was this reply helpful? Yes No
Chriddle 8,436 Super User 2025 Season 2 on at

Like (0)

Report
Maybe it's better to keep the list column type (e.g. for sorting).
If so, convert your date string ('31/03/2023') to an ISO formatted date string (e.g. '2023-01-31').
This is accepted as a sharepoint date value.

Assuming that outputs('Compose') is your date string:
concat(outputs('Compose') split(outputs('Compose'), '/')[2], '-', split(outputs('Compose'), '/')[1], '-', split(outputs('Compose'), '/')[0] )

Was this reply helpful? Yes No
Lagloire 86 on at

Like (0)

Report

Hi
Exact, in the compose action, i'm concatenating the date as you said and in SP date column formating it like :
formatDateTime(parseDateTime(outputs('Answer_date')), 'dd/MM/yyyy', 'en-GB').

You suggested to convert date string ('31/03/2023') to an ISO formatted date string (e.g. '2023-01-31').
I want to have the date in this format '31/03/2023', so do you think like i may be possible to have it in the format as i want?
Regards

Was this reply helpful? Yes No
Chriddle 8,436 Super User 2025 Season 2 on at

Like (0)

Report

If you follow my suggestion and keep "Date" as your list column type, your Sharepoint list has date values.
How these values are displayed is handled by the Sharepoint configuration in the site settings.

Was this reply helpful? Yes No