Sharepoint Look Up Column Issue

[Korinn1580]

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'.

[#2]

@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

[#3]

Did you solve the issue?

[#4]

@livia_cavalcante @Korinn1580 

SharePoint lookup column requires ID from the main/parent list to set the column value in dependent/child list.

Check related threads:

1. How do I fill a SharePoint Lookup Column in Power Automate? 
2. How to update LOOKUP column in SharePoint list 

---

Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.