Unanswered

OpenApiOperationParameter conversion failed error

(0) Share

Report

Posted on by AE-12082315-0

Hello,

I have created a flow that takes entries from an Excel sheet and automatically adds it to a share point list. The flow currently adds the entries to the share point list but when it finishes running it keeps giving me the following error:

OpenApiO perationParameter TypeConversionFailed. The 'inputs parameters of workflow operation 'Create_item' of type 'OpenApiConnection' is not valid. Error details: Input parameter

'item/Equipment' is required to be of type 'Number/double'. The runtime value '*' to be converted doesn't have the expected format 'Number/double.

The “Equipment” field in the share point list and Excel sheets is a currency.

I basically just want to figure out why I keep getting this error and resolve it. Thank you.

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (0)

Sort by

creativeopinion 10,508 Moderator on at

Like (0)

Report
Copy link

Link copied!

@AE-12082315-0 It's hard to offer any specific recommendations without seeing your full flow and the logic behind it. If you are using the new designer, toggle it off and click each action to expand it. Upload a screenshot of your flow in edit mode.

However, your error indicates that you are trying to update a SP list field (Equipment) with a value that isn't in the format required.

In the meantime, you might be interested in these YT Tutorials:

✌️TWO WAYS to Get Data from Excel into a SharePoint List

There are two ways to get your data from Excel into a SharePoint List:
1️⃣ Copy and paste
2️⃣ Automatically with a Power Automate flow

In this video tutorial I will show you how to get your Excel data into a SharePoint List using the two methods listed above. I’ll cover how to format your data for complex columns such as a multi-choice and multi-person columns.

IN THIS VIDEO:
✓ How to copy and paste data from Excel into a SharePoint List
✓ How to format Excel data for multi-choice columns in a SharePoint List
✓ How to import data from Excel into a SharePoint List with a Power Automate Flow
✓ How to use the Select action in Power Automate
✓ How to use the Create Item action in Power Automate
✓ Enabling the Concurrency Control to Optimize Flow Performance

Hope this helps!

Consider giving me a ❤️ if you liked my response!

👉 Level up your Power Automate skills by checking out my tutorials on YouTube
👉 Tips and Tricks on TikTok and Instagram

Was this reply helpful? Yes No
AE-12082315-0 44 on at

Like (0)

Report
Copy link

Link copied!

this is the error I keep getting.

Was this reply helpful? Yes No
creativeopinion 10,508 Moderator on at

Like (0)

Report
Copy link

Link copied!

it's really hard to understand the logic behind the flow with the screenshots you've shared. I can't tell if the Equipment field is required as it doesn't appear in your Create Item screenshot. If it is, you will need to ensure you have a value in there.

It looks like you have two separate apply to each actions which could be your problem. However, as mentioned above it's hard to follow the logic of your flow without seeing a full screenshot. Ensure New Designer and click each action to expand it. Upload a screenshot of your full flow in edit mode.

Was this reply helpful? Yes No
AE-12082315-0 44 on at

Like (0)

Report
Copy link

Link copied!

I updated the post with my latest flow. All I need to know is how to rewrite the function for “organization “ field which is “currency “ type. On the “create item” step. Thank you.

Was this reply helpful? Yes No