cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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
Highlighted
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.

Highlighted

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,

Highlighted

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
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

Top Solution Authors
Top Kudoed Authors
Users online (8,710)