Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics 365 | Integration, Dataverse...
Suggested answer

retrieve lookup field and populate

(0) ShareShare
ReportReport
Posted on by 4

Hi,

I want to copy lookup field and populate in another table to either lookup field or text field.

Can I populate retrieved lookup field and populate to lookup field.

Thanks.

  • Talha Manzoor Profile Picture
    31 on at
    RE: retrieve lookup field and populate

    you can find solution from here filter lookup based on Id

    talhamanzoor2.blogspot.com/.../how-to-set-lookup-field-to-another.html

  • Suggested answer
    XM-22040801-0 Profile Picture
    11 on at
    RE: retrieve lookup field and populate

    Hi,

    You can do it with mapping (depending of the relation between your both entities): learn.microsoft.com/.../map-entity-fields

    Or you can use JS by register a js function on form load. Example : community.dynamics.com/.../auto-populate-related-entity-record-in-lookup-field-in-d365-using-js

  • Leah Ju Profile Picture
    Microsoft Employee on at
    RE: retrieve lookup field and populate

    Hi Partner,

    The easy way to do this is you can do it through workflow.

    For complex ones, you need to implement it via js code, depending on your actual scenario.

    https://carldesouza.com/how-to-set-a-lookup-field-to-another-lookup-field-on-a-dynamics-365-power-apps-form-using-javascript/ 

    Can you describe it in detail?

    Is there a relationship between the two tables where the fields exist, better with screenshots!

  • Expertopinionsa12 Profile Picture
    51 on at
    RE: retrieve lookup field and populate

    Hey there!

    So, you want to copy a lookup field from one table and populate it in another table, right? And you're wondering if you can populate the retrieved lookup field into another lookup field or a text field, correct?

    Well, the good news is that you can totally do that! The exact steps may vary depending on the software or platform you're using for your database, but I can give you a general idea of how it can be done.

    First of all, you'll need to get the value of the lookup field from the source table. Once you have that value, you can decide whether you want to populate it into another lookup field or a text field in the destination table.

    If you want to populate it into another lookup field, you should make sure that the destination lookup field is set up to accept values from the source table. That way, you can simply assign the retrieved value to the destination lookup field.

    While I've given you a general idea of the process we follow at triotech systems, the specific steps and syntax will depend on the database system or software you're using. You might want to refer to the documentation or reach out to the platform's support resources for more detailed instructions.

    I hope this helps! Let me know if you have any more questions.

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

Ramesh Kumar – Community Spotlight

We are honored to recognize Ramesh Kumar as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Microsoft Dynamics 365 | Integration, Dataverse, and general topics

#1
Adis Profile Picture

Adis 136 Super User 2025 Season 1

#2
Sohail Ahmed Profile Picture

Sohail Ahmed 81

#3
Jonas "Jones" Melgaard Profile Picture

Jonas "Jones" Melgaard 77 Super User 2025 Season 1

Product updates

Dynamics 365 release plans