News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics 365 | Integration, Dataverse... How to get E-Mails wit...

Microsoft Dynamics 365 | Integration, Dataverse...

Answered

How to get E-Mails without ActivityParty of type 'Contact'?

(0) Share

Report

Report

Posted on by alx.kpk

21

I'm trying to get all email records which have no relationship to a contact. Here is my current FetchXML:

It also returns records that have contacts as ActivityParty. Do I miss something here or is this a limitation of FetchXML?

All responses Img

All responses (3)

Answers Img

Answers (1)

alx.kpk 21 on at

Like (0)

Report

RE: How to get E-Mails without ActivityParty of type 'Contact'?

Sorry, I was wrong. I oversaw the meaning of entityname="ap" in the condition and didn't notice FetchXML Builder is not using this attribute. Query seems to work pretty fine. Thanks a lot!
alx.kpk 21 on at

Like (0)

Report

RE: How to get E-Mails without ActivityParty of type 'Contact'?

Thanks for the input. Unfortunately this FetchXML query returns 0 records.
Verified answer

a33ik 84,325 Most Valuable Professional on at

Like (1)

Report
RE: How to get E-Mails without ActivityParty of type 'Contact'?

Hello,

Check the following FetchXml:

Check this KB that explains how it works - docs.microsoft.com/.../use-fetchxml-left-outer-join-query-records-not-in

Helpful resources

News and Announcements

Announcing Category Subscriptions!

Quick Links

Leaderboard

#1

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

#2

Martin Dráb 230,370 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Get batch job history log from D365 FO to Power Automate

Product updates

Dynamics 365 release plans