Skip to main content

Notifications

Power Automate - Building Flows
Unanswered

OpenApiOperationParameter conversion failed error

(0) ShareShare
ReportReport
Posted on by 40
      
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.

  • AE-12082315-0 Profile Picture
    AE-12082315-0 40 on at
    OpenApiOperationParameter conversion failed error
    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.
  • creativeopinion Profile Picture
    creativeopinion 10,064 on at
    OpenApiOperationParameter conversion failed error
    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. 
  • AE-12082315-0 Profile Picture
    AE-12082315-0 40 on at
    OpenApiOperationParameter conversion failed error
     this is the error I keep getting.
  • creativeopinion Profile Picture
    creativeopinion 10,064 on at
    OpenApiOperationParameter conversion failed error
    @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:

    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,475

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,767

Leaderboard