For a selected row/sharepoint: Inputparameter 'item/Date' is required to be of type String/date

(1) Share

Report

Posted on by doublenico79

Hello,

I have an excel document with a few columns including a date and time column.

For a selected line (my trigger) my flow will feed a word template while creating a sharepoint list and sending an email.

In the email, no worries, I have the "date and time" field.
But it blocks in the recording in the sharepoint list with the following message:

The 'inputs.parameters' of workflow operation 'Update_file_properties_2' of type 'OpenApiConnection' is not valid. Error details: Input parameter 'item/Date' is required to be of type 'String/date'. The runtime value '"30/7/24 12:00 AM"' to be converted doesn't have the expected format 'String/date'.

After browsing the web, I see that in "lists rows", it is possible to select in DateTime Format "iso 8601" but in the trigger "For a selected row", I do not have this option...and I loop on this error.

A huge thank you for your help

Categories:

Business Process Flows

I have the same question (0)

All responses (3)

Answers (0)

abc 123 784 Moderator on at

Like (0)

Report

For a selected row/sharepoint: Inputparameter 'item/Date' is required to be of type String/date

It probably wants the date in this format: 2007-04-05T14:30Z

Was this reply helpful? Yes No
doublenico79 43 on at

Like (0)

Report

For a selected row/sharepoint: Inputparameter 'item/Date' is required to be of type String/date

Thanks but how can i do it?

Was this reply helpful? Yes No
abc 123 784 Moderator on at

Like (0)

Report

For a selected row/sharepoint: Inputparameter 'item/Date' is required to be of type String/date

The Text() function has presets. Try the UTC.

Text function - Power Platform | Microsoft Learn

If not, there are a host of date functions that will help you dissect a date, and then you can put it into the desired format.

Day, Month, Year, Hour, Minute, Second, and Weekday functions - Power Platform | Microsoft Learn

Was this reply helpful? Yes No