Unanswered

Error details: Input parameter 'item/DesiredDeliveryDate' is required to be of type 'String/date'. The runtime value '""' to be converted doesn't have the expected format 'String/date'.

(0) Share

Report

Posted on by Piyush__

I facing this issues where I'm trying to update excel data into a SharePoint list. I have number of date columns in the excel, which when I'm trying to update using the update items showing this error, can someone help me with the solutions. Error -

OpenApiOperationParameterTypeConversionFailed

The 'inputs. Parameters' of workflow operation 'Update item' of type 'OpenApiConnection' is not valid. Error details: Input parameter 'item/DesiredDeliveryDate' is required to be of type 'String/date'. The runtime value '""' to be converted doesn't have the expected format 'String/date'.

Expression I'm using -

if(equals(item()?['Desired Delivery Date'],''),null, item()?['Desired Delivery Date'])

Categories:

General topics

I have the same question (0)

All responses (3)

Answers (0)

Gdarmon Outlook 372 on at

Like (0)

Report
Copy link

Link copied!

Hi,
It looks like you’re encountering an error while trying to update Excel data into a SharePoint list. The error message suggests that the input parameter ‘item/DesiredDeliveryDate’ is required to be of type ‘String/date’, but the runtime value ‘“”’ doesn’t have the expected format ‘String/date’.
Based on the error message, it seems like the issue is with the format of the ‘Desired Delivery Date’ column in your Excel sheet. You may need to ensure that the date values in this column are formatted as strings or dates.
Regarding the expression you’re using, it looks like you’re checking if the ‘Desired Delivery Date’ column is empty and returning null if it is. However, this may not be sufficient to resolve the error you’re encountering.
To help you better, could you please provide more details about the specific steps you’re taking to update the SharePoint list from Excel? This will help me understand the issue better and provide more targeted guidance.

Gill

Was this reply helpful? Yes No
Piyush__ 10 on at

Like (0)

Report
Copy link

Link copied!

I have one Excel File which getting the data from another SharePoint List, in which the desired delivery date I have made the data type using locale as
Following Steps I have taken:
1. I'm passing this excel in Power Automate as list of rows with Date Time Format - ISO 8601
2. Then I have added Apply to each - passing --> outputs('List_rows_present_in_a_table')?['body/value']
3. Then I get the items from SharePoint List which I have to update using Get Items with Filter Query --> UniqueID0 eq UniqueID
4. Then I put the condition - length(outputs('Get_items')?['body/value']) > 0. If it is true it will update the existing line otherwise it creates the new line
5. In True, I have added apply to each with output from previous step as (SharePoint List):
outputs('Get_items')?['body/value']
6. Followed by update items, with ID = UniqueID0 and same expressions for different columns. Similar to this -
if(equals(item()?['Desired Delivery Date'],''),null, item()?['Desired Delivery Date'])
7. If False, create items (SharePoint List) with same expressions in different columns

My regional settings in power automate and SharePoint site is :

Was this reply helpful? Yes No
nosir 2 on at

Like (0)

Report
Copy link

Link copied!

Was this solved? I am currently have the same issue.

Was this reply helpful? Yes No