Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics 365 | Integration, Dataverse...
Unanswered

Customer entity record creation based on Contact's child account of contact's account

(0) ShareShare
ReportReport
Posted on by 160

Hi All,

I would like to know if the below requirement can be achieved through OOB or requires code.

Current functionality, which I have achieved with workflow:

Whenever a Phone call activity is created for a contact and the "school" field in the contact's account is marked as "Yes", then a custom entity (OMWI) record will be created.

Expected functionality:

A Phone call activity has been created for a contact and the "school" field in the contact's account is marked as "No". But, if any of the child accounts (Parent is marked as "No") is marked as "Yes", then a custom entity (OMWI) record needs to be created.

Thanks in advance for your help/advise.

Regards,

Praveen.

  • LuHao Profile Picture
    LuHao 40,876 on at
    RE: Customer entity record creation based on Contact's child account of contact's account

    Hi Praveen,

    The most appropriate way for this requirement is to use plugin. If you would use the OOTB method, it is also possible.

    Let me talk about using OOTB workflow.

    Trigger: Account's "school" field changes.

    Condition: 1) Account's "school" field is "Yes". 2) Parent Account's Contact has a Phone call activity. 3) Parent Account' "school" field is "No".

    Action: Create a custom entity (OMWI) record.

    The second condition cannot be set directly, so we have to create two custom fields and two additional workflows. The other settings are simple.

    Create a two-option field "Contact has Phone call" on the Contact, and then create a workflow for the Phone call activity. Triggered when a Phone call activity is created, the condition is that the "Contact has Phone call" is No, and the action is to update "Contact has Phone call" to Yes.

    Create a two-option field "Account has Phone call" on the Account, and then create a workflow for Contact. Triggered when "Contact has Phone call" changes, the action is to update its (Company Name) Account's "Account has Phone call" to Yes.

    Using these two custom fields and two additional workflows we can determine if Parent Account's Contact has a Phone call activity and put the result on the parent account.

    Finally, back to the original workflow. The second condition can be set to Parent Account's "Account has Phone call" field is "Yes".

    In this way, the workflow that implements your request is complete.

  • Nagaraj_Matta Profile Picture
    Nagaraj_Matta 55 on at
    RE: Customer entity record creation based on Contact's child account of contact's account

    Hi Praveen Greetings !

    Let me understand your scenario once.

    So how contact and account related ( through OOB Company Name lookup field on contact)?

    so when you mention child accounts are they child accounts of Parent Account ( i.e, Comapany Name).

    or else have you created any custom relation between account and contact?

    One basic thing is we can update the field value of parent record through ( 1:N) but we can't update the child records field through update step in Workflow .

    Thanks,

    Nagaraju

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

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Tip: Become a User Group leader!

Join the ranks of valued community UG leaders

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,494 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,305 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans