web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Error Populating Looku...
Power Automate
Unanswered

Error Populating Lookup Field in Salesforce Create Record Connector

(0) ShareShare
ReportReport
Posted on by 2

I'm having trouble creating a record when trying to populate data into a field which is expecting a lookup data type in the Salesforce Create Record action. The error is: 

 

"Salesforce failed to complete task: Message: Related To ID: id value of incorrect type: P109302\r\nclientRequestId: 6f38d859-19f5-46bf-bbb0-db5bd2fb6b7e"

 

The data I'm trying to assign is (in string) "P109302".

 

The whole flow is actually trying to extract a Salesforce record based on a reference number in a subject of an email. This part works fine and extracts the correct record. I then want to create a task related to that record, using the Create Record action. It's this "related to" field which is of lookup data type. In my example, there are actually two fields which are expecting a lookup data type (the other is the user to whom the record is to be assigned).

 

I understand that I should be populating the "related to" field with a lookup data type, but I can't see a way to do this from the connector interface.

 

My questions: 1) Is it possible to do what I want from the flow create record connector (if so, how?); and

2) If not, is it possible to create an internal flow in Salesforce to populate the lookup field from another field in the record, externally assigned - if so, how would this be done?

Categories:
I have the same question (0)
  • v-yuazh-msft Profile Picture
    on at

    Hi @ RussellM83,

     

    Could you please share a screenshot of the configuration of your flow?

     

    Do you fill the value "P109302" in the "Related To ID" field of "create record" action?

     

    I have made a test on my side and I couldn't populate the lookup field in "create record"action, I'm afraid populate the lookup field is not supported in microsoft flow currently.

     

     

    Regards,
    Alice Zhang

  • ChrisLondon Profile Picture
    2 on at

    Hi Alice,

     

    Thanks for your response. It seems like you've hit the nail on the head that populating the lookup field in the "Create Record" action is not supported in Microsoft flow currently (Any idea if this is something on a to-do list somewhere?).

     

    In the meantime, I'll try to code up a workaround internally in Salesforce, so that I can populate a text field in the record from the flow connector, but get Salesforce to do the conversion to the lookup data type itself internally on each new record created with that text field populated.

     

    Regards,

     

    Chris

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 525 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 324 Moderator

#3
abm abm Profile Picture

abm abm 232 Most Valuable Professional

Last 30 days Overall leaderboard