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

@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
MPA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Top Solution Authors
Users online (2,159)