Answered

blank date field

(0) Share

Report

Posted on by 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'])

All responses (15)

Answers (1)

Emanshu 30 on at

Like (0)

Report

Re: blank date field

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.
JOAS_Niels 174 on at

Like (0)

Report

Re: blank date field

For others, see also:
https://powerusers.microsoft.com/t5/Building-Flows/Blank-Date-Field-from-a-Form-into-a-SharePoint-list-causing/td-p/2516743

Rebuilding the flow in classic designer, worked for me.
CFernandes 8,295 Most Valuable Professional on at

Like (0)

Report

Re: blank date field

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

Like (0)

Report

Re: blank date field

it didnt , but i was working in classic anyway , i just switched to new in the hopes it might help
CFernandes 8,295 Most Valuable Professional on at

Like (0)

Report

Re: blank date field

@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.
Verified answer

hstep on at

Like (0)

Report

Re: blank date field

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
SanmeshG 1,947 Super User 2025 Season 1 on at

Like (0)

Report

Re: blank date field

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.

Hi @hstep ,
hstep on at

Like (0)

Report

Re: blank date field

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.
CFernandes 8,295 Most Valuable Professional on at

Like (0)

Report

Re: blank date field

@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 on at

Like (0)

Report

Re: blank date field

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