You’re offline. This is a read only version of the page.
Announcements
Share
ReportI have a field called CustomerId where the email contact comes from.
There are cases where there is no contact in the email, that is, when I search for an email, he does not have the contact
related to CustomerId. therefore, I need to fetch directly from the Contact table related to customerId.
CustomerId is a Lookup and emailAddress1 is on Contact.
How to find this contact related to CustomerId in C#?
Hi Joelias,
We can use FetchXML to query records as mentioned here https://docs.microsoft.com/en-us/powerapps/developer/data-platform/use-fetchxml-construct-query.
We can also get the FetchXML query using advanced find as mentioned at https://www.linkedin.com/pulse/generate-fetchxml-condition-crm-advanced-find-using-query-kumar and https://stoneridgesoftware.com/going-beyond-advanced-find-views-and-the-xrmtoolbox-using-fetchxml-and-left-outer-joins/.
Please find more information at https://docs.microsoft.com/en-us/powerapps/developer/data-platform/use-fetchxml-left-outer-join-query-records-not-in#example-find-all-accounts-that-have-no-leads.
Best Regards,
Mobeen Mohsin
#1
André Arnaud de Cal...
293,296
Super User 2025 Season 1
#2
Martin Dráb
232,093
Most Valuable Professional
#3
nmaenpaa
101,156
Moderator
All responses (
Answers (
