Sharepoint Look Up Column Issue

%3CLINGO-SUB%20id%3D%22lingo-sub-2837691%22%20slang%3D%22en-US%22%3ESharepoint%20Look%20Up%20Column%20Issue%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2837691%22%20slang%3D%22en-US%22%3E%3CP%3EHi%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20trying%20to%20update%20using%20power%20automate%20to%20add%20items%20to%20a%20already%20existing%20sharepoint%20list%20but%20I%20keep%20getting%20the%20below%20message%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20'inputs.parameters'%20of%20workflow%20operation%20'Create_item'%20of%20type%20'OpenApiConnection'%20is%20not%20valid.%20Error%20details%3A%20Input%20parameter%20'item%2FCategory%2FId'%20is%20required%20to%20be%20of%20type%20'Integer%2Fint64'.%20The%20runtime%20value%20'%2201%20Emergency%20Lighting.%20%22'%20to%20be%20converted%20doesn't%20have%20the%20expected%20format%20'Integer%2Fint64'.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2837691%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3E2010%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EAdmin%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EApp%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EDeveloper%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFiles%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EHybrid%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMicrosoft%20Lists%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Server%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor

Hi

 

I am trying to update using power automate to add items to a already existing sharepoint list but I keep getting the below message

 

The 'inputs.parameters' of workflow operation 'Create_item' of type 'OpenApiConnection' is not valid. Error details: Input parameter 'item/Category/Id' is required to be of type 'Integer/int64'. The runtime value '"01 Emergency Lighting. "' to be converted doesn't have the expected format 'Integer/int64'.

1 Reply

@Korinn1580 it would be beast if you post a screenshot of the flow so we can see what is causing the problem.

 

Rob
Los Gallardos
Microsoft Power Automate Community Super User