Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics 365 | Integration, Dataverse...
Suggested answer

retrieve lookup field and populate

Posted on by 2

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
    Talha Manzoor 29 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
    XM-22040801-0 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
    Leah Ju 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!

  • 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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans