Skip to main content

Notifications

Announcements

No record found.

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

Create lookup field from activity entity

Posted on by 110

Hello,

I have a problem where I should create lookup field to opportunity form and information should come from activities (phone calls and appointments). We would like to create just one field, but activity entity can't be a target record type as I understood correct?

So does anyone have any idea how I could choose either phone call or appointment record to this look up field? As I wrote we don't want create two different fields for those activities.

Best regards 

Tuomas 

  • Austin Shen Profile Picture
    Austin Shen on at
    RE: Create lookup field from activity entity

    Hello Tuomas,

    May I know activities (phone calls and appointments) here refers to, smmActivities or anything else?

    From my understanding, you may try to define initial activities for the opportunities. Would you mind sharing more details of your data model? If you are using custom tables for the activities, any chance to store phone calls and appointments to one table. Thank you.

    Best Regards,

    Austin Shen

  • erhan.keskin Profile Picture
    erhan.keskin 2,247 on at
    RE: Create lookup field from activity entity

    Hi,

    Unfortunately, the platform doesn't provide any ability like that.

    1. If the problem is to have two fields on the form, and it is not looking good to the end user, then create Phone Call and Appointment lookup fields and hide the one which doesn't have any value populated.
    2. If one field is a certain decision for a reason, then you can create a custom entity which has Phonecall and Appointment lookups, so you can locate this custom entity lookup on Opportunity instead. You can have web resources to show detail of the activities, so you can handle the values depending on the provided activity info on the custom entity.

    Regards,

  • Suggested answer
    a33ik Profile Picture
    a33ik 84,323 Most Valuable Professional on at
    RE: Create lookup field from activity entity

    Hello Tuomas,

    There is no platform possibility to do that at the moment.

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