blank date field

[hstep]

Hi all, having an issue on update sharepoint where this error occurs  : OpenApiOperationParameterTypeConversionFailed. The 'inputs.parameters' of workflow operation 'Update_item' of type 'OpenApiConnection' is not valid. Error details: Input parameter 'item/DateRetired' is required to be of type 'String/date'. The runtime value '""' to be converted doesn't have the expected format 'String/date'.

now ive done the usual formula but it isnt working - 

if(empty(item()?['Installed Date']),null, item()?['Installed Date'])

i have two columns throwing the error - installed date and retired date , currently changed them to text fields in sharepoint to get it working but not ideal

and tried other variations including a compose action and looked on here , but null doesnt seem to work regardless 

i basically copied a flow by reza : https://www.youtube.com/watch?v=uEZI_b1Gs-k

UPDATE: ok it seems to have fixed itself by me doing the following - switch to new designer, change the sharepoint column from date to single line of text , then change it back to date and then this formula has worked ( it didnt previously ) : 

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

[ivan_apps]

What data source are you connecting against? SharePoint? Excel?

For troubleshooting try to put a utcNow() instead of null and see if it works.  My guess is that your empty() isn't correct and it's going to the Installed Date value, which is "" - an empty string.

You can try to replace your if condition with:

equals(item()?['Installed Date'], '')

and see if that will then go to the null value.

[SanmeshG]

HI @hstep  ,

I think you have two date columns in your list. The error message says DateRetired is required to be of type string , so it seems that the problem is not with column Installed Date but its with DateRetired.

So you can consider checking the formula that you have used for DateRetired. Also I think you should ensure that the Date column is not a required column in the list (This will throw a Patch Item is missing a required property error).

If this helps , please give this a thumbs up and mark this as a solution.

Thanks,

Sanmesh

[hstep]

no it doesnt sadly , i did try that, its sending to sharepoint from an excel . 

[hstep]

hi yes sorry i should of mentioned im having it on two columns , both throwing the same issue

[SanmeshG]

Hi @hstep ,

Is it possible for you to share the screenshots of your flow?

I am a bit confused as there is no conversion formula written in the expression as per the issue/question posted.

[hstep]

updated post - what converstion would you need ? a date/time? 

[CFernandes]

@hstep - Are you using New Designer - Please switch to the Classic Designer, it should provide you with more details about the error 

I had the same problem last week and switching to classic designer helped me identify and fix the problem...My problem being a syntax error with the SharePoint list

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

P.S. take a look at my blog here and like & subscribe to my YouTube Channel thanks.

[hstep]

i wasnt but ive switched to new in the hope of fixing the issue - i mean its pretty clear what the issue is , but i dont know what will work to fix it. everything says null should be accepted. 

[SanmeshG]

Hi @hstep  ,

Have you enabled the ISO 8601 format in the list rows from excel action?

Its possible that you are reading it as a serial number and that's what is causing an issue.

[hstep · Accepted solution]

yes, it seems to have fixed if i changed the columsn to text then back to date in sharepoint , so must of been a bug or something

[CFernandes]

@hstep - Perfect, I am glad that you managed to find and fix the problem(Did switching to Classic provide more context of the Error and helped you with troubleshooting?) I am asking because the new Editor does provide correct on error OpenApiOperationParameterTypeConversionFailed.

[hstep]

it didnt , but i was working in classic anyway , i just switched to new in the hopes it might help

[CFernandes]

@hstep - Thank you! Was just curious if it was only me that got more error details in Classic Editor

[JOAS_Niels]

For others, see also:

https://powerusers.microsoft.com/t5/Building-Flows/Blank-Date-Field-from-a-Form-into-a-SharePoint-li...

Rebuilding the flow in classic designer, worked for me.

[Emanshu]

This also just worked for me, same exact situation where I had a formula that worked time over time and then when making edits in the new designer it started throwing this error. 

I fortunately was able to delete out the individual date transformations, save the flow then paste them back in and it worked.