Forum Discussion

KeithMontana's avatar
KeithMontana
Copper Contributor
Jun 24, 2021

'OpenApiConnection' is not valid

Hi everyone, 

 

I am new to power automate, l am trying to migrate data from a SQL table to a SharePoint list using power automate, one of the fields keeps throwing an openApiconnection error. it is a lookup field in SharePoint however in Microsoft flow it's expecting a lookup ID of the field. how do l go round solving it, please.....

 

The 'inputs.parameters' of workflow operation 'Create_item' of type 'OpenApiConnection' is not valid. Error details: Input parameter 'item/Project/Id' is required to be of type 'Integer/int64'. The runtime value '"743: Carefirst replacement / Eclipse - Phase 1: Adults"' to be converted doesn't have the expected format 'Integer/int64'.

power automate
sharepoint
SharePoint Online
SQL
  • MaxPower45255's avatar
    MaxPower45255
    Copper Contributor
    Mar 28, 2022

    KeithMontana 

    I know this is late in the game. But it sounds like you passed a value ['"743: Carefirst replacement / Eclipse - Phase 1: Adults"' ] which is a string, and is not of the proper datatype for your Integer input parameter. It looks like 743 is the ID of your record and is all you need to get pass to the flow.


    Good luck!

     

Resources