Unanswered

Power flow automation to update a look up field in SalesForce

(1) Share

Report

Posted on by myccit

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!

Categories:

Using connectors

I have the same question (0)

All responses (5)

Answers (0)

kogiaone 2 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
myccit 6 on at

Like (0)

Report
Copy link

Link copied!

I haven't worked on the issue in a while, so nothing yet. Any luck on your end? Thanks!

Was this reply helpful? Yes No
myccit 6 on at

Like (0)

Report
Copy link

Link copied!

Thank you for the suggestion! I will give it a try and see. Thanks!

Was this reply helpful? Yes No
ccb_101 31 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No