cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
sherif77
Helper II
Helper II

OpenApiOperationParameterTypeConversionFailed

Hello,

 

I'm having a flow where Uploading data from Excel to SharePoint List.

 

I'm Using the following connectors to achieve the required action. Scheduled / Occurrence -> List rows present in a table - > Apply to each - > get Items - > Condition-> Create item or Update Item.

 

The Columns in my Spreadsheet include date type cells  (3 columns ) the dates are presented in this format 9-11-2019 ( MM-DD-YYYY) no time included.

 

I'm receiving this error while processing the flow and a message of Slow performance.

 

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

 

 

The Condition is   length(outputs('Get_items')?['body/value'])

kk.PNG

 

Capture.PNGRR.PNGSS..PNGZZ.PNGZZ2.PNG

 

 

3 REPLIES 3
edgonzales
Super User II
Super User II

@sherif77 

Hi there.  I think this may be as simple as Excel and SharePoint handling dates differently.  Date codes in Excel are a bit...weird, so to use them, we need to add the code to an expression before trying to pass it off as a date to anything else.  See the thread below for the expression:

 

Excel Date

 

Please keep us posted.

-Ed

 

If you liked this reply, please give it a thumbs up! If this reply has answered your question or resolved your challenge, please consider marking it as a Solution. This helps other users find it more easily via search.

thank you,

 

In the submission date for instance should it include the Submissions date Value or i would have to write any further expressions?

 

why is the flow telling me slow performance it took 12 hours for the previous run to finish, the spreadsheet actually includes 4500 row so is that the reason.

 

thank you for your help in advance,

Dear @edgonzales 

 

are you able to help by sharing the flow pictures with a little bit of illustration from your side.

 

Thank you in advance,

 

Regards, 

Sheirf

Helpful resources

Announcements
Process Advisor

Introducing Process Advisor

Check out the new Process Advisor community forum board!

MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Users online (17,155)