Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Apps - Microsoft Dataverse
Answered

Dual Write handle the Customer Lookup

(0) ShareShare
ReportReport
Posted on by 11

The Customer Lookup is a Multi Entity lookup for Contact and Account.I have account and contact dual write setup.

Not i have a Customer lookup in a case and i am sync from F&0. The issue is on the case has a customer which maps to either a contact or account depending on case. the same in f&0 as there case has  a party id which can accommodate both.

 

When i create the sync the intital sync 

Categories:
  • Verified answer
    satishs Profile Picture
    11 on at
    Re: Dual Write handle the Customer Lookup

    I ended resolving this

     

    1) Creating a field in F&0 to store person and organization saperately.
    2) On the dataverse i created a Contact lookup and Account lookup.
    3) On Dual write i setup them to update each other using the Account Number as Alternate Key
    4) Wrote a plugin that on value set of either, update the Customer field,
    5) The Plugin does the reverse to set these two fields in the dataverse and sending the info to F&0

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

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Power Apps - Microsoft Dataverse

#1
stampcoin Profile Picture

stampcoin 17

#2
mmbr1606 Profile Picture

mmbr1606 15 Super User 2025 Season 1

#3
ankit_singhal Profile Picture

ankit_singhal 11 Super User 2025 Season 1

Overall leaderboard

Featured topics