Hi there,
I created a power flow to retrieve information from Salesforce and then update a field using the "update version (v3)" connector. To update the email address requires updating the owner’s field, which is a lookup field. I get the following error "Salesforce failed to complete the task: Message: Owner ID: id value of incorrect type" or if I use the dynamic field that I retrieved before from the same form I get an error message that the field cannot be blank. Does anyone have any success updating a lookup field in Salesforce using the "update version (v3)" connector? Thanks!
Hello,
Whilst I'm not using Update record (v3) like yourself, I also ran into this error using Create record. When creating a Salesforce record, one of the fields I was trying to populate via Power Automate was also a search field in salesforce. If I entered any text I was getting a "id value of incorrect type:"
Some fields in salesforce can only accept certain ID types/values. The ID value can be found in the URL. So I had to go into Salesforce record and complete the search manually for that field. Once the search returned a value, I saved the record and then I clicked on that value and the URL displayed the ID I needed.
The final result in my Create record in Power Automate looked like the below
Hope that helps.
This article gave me the clue that I needed to use some specific ID rather than typing in the name myself.
https://developer.salesforce.com/forums/?id=9062I000000QzBOQA0
Thank you for the suggestion! I will give it a try and see. Thanks!
I haven't worked on the issue in a while, so nothing yet. Any luck on your end? Thanks!
Good day, Try to pass the owner id in a parse json action and check what type of data it is, it looks like its the syntax type. If you managed to get it right please share how you solved the issue.
Kind regards.
Hi, Did you get it to work?
I want to update a field on an opportunity object in salesforce, from power automate, but find the lookup to be a bit unclear how to do....
I have the opportunity number, eg: OP-0012778