You’re offline. This is a read only version of the page.
2
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:
Hi,
Pls click "Create item" action and show me values passed in the input parameter.
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.
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.
#1
Michael E. Gernaey
566
Super User 2025 Season 1
#2
David_MA
516
Super User 2025 Season 1
#3
stampcoin
492
Share
Report
All responses (
Answers (
