Unanswered

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'])

Categories:

Building flows

I have the same question (0)

All responses (15)

Answers (1)

ivan_apps 2,187 Moderator on at

Like (0)

Report

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.

Was this reply helpful? Yes No
SanmeshG 1,947 Moderator on at

Like (0)

Report

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

Was this reply helpful? Yes No
hstep on at

Like (0)

Report

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

Was this reply helpful? Yes No
hstep on at

Like (0)

Report

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

Was this reply helpful? Yes No
SanmeshG 1,947 Moderator on at

Like (0)

Report

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.

Was this reply helpful? Yes No
hstep on at

Like (0)

Report

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

Was this reply helpful? Yes No
CFernandes 8,402 Most Valuable Professional on at

Like (0)

Report

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

Was this reply helpful? Yes No
hstep on at

Like (0)

Report

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.

Was this reply helpful? Yes No
SanmeshG 1,947 Moderator on at

Like (0)

Report

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 ,

Was this reply helpful? Yes No
Verified answer

hstep on at

Like (0)

Report

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

Was this reply helpful? Yes No