Unanswered

Error during transfer of data from excel to sharepoint list due to dates

(0) Share

Report

Posted on by James_Lewis

Hi,

I am trying to take what's in an excel file and drop this into a sharepoint list so that the list mimics the excel file.

My flow looks like:

Daily trigger -> List rows present in a table -> For each 1 (Create Item)

When trying to do this it works fine until I add in columns that contain dates and then I get the following error:

Action 'Create_item' failed: The 'inputs.parameters' of workflow operation 'Create_item' of type 'OpenApiConnection' is not valid. Error details: Input parameter 'item/field_11' is required to be of type 'String/date-time'. The runtime value '""' to be converted doesn't have the expected format 'String/date-time'.

This is, I'm assuming, that some of the cells in the excel are blank whereas PA is expecting there to be a date, is there a way around this?

Thank you!

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (0)

Manish Solanki 15,167 Moderator on at

Like (0)

Report
Copy link

Link copied!
Hi @James_Lewis

You need to use if() function to handle blank or empty values:

if(empty(item()?['columnname']),null,item()?['columnname'])

replace the column name with the actual on in the above expression

If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.

Was this reply helpful? Yes No
James_Lewis 2 on at

Like (0)

Report
Copy link

Link copied!

Hi Manish,
Thanks for your prompt response. I have added this expression into all available date fields but this still didn't fix the error:
Action 'Create_item' failed: The 'inputs.parameters' of workflow operation 'Create_item' of type 'OpenApiConnection' is not valid. Error details: Input parameter 'item/field_11' is required to be of type 'String/date-time'. The runtime value '""' to be converted doesn't have the expected format 'String/date-time'.

I have shared a screenshot of the flow. The item failing is the create item.

Was this reply helpful? Yes No
Manish Solanki 15,167 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi,

Pls click "Create item" action and show me values passed in the input parameter.

Was this reply helpful? Yes No