Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Customer experience | Sales, Customer Insights,... / Attribute type "P...
Customer experience | Sales, Customer Insights,...
Unanswered

Attribute type "PartyList" - "To"is not supported in Fetchxml Query.

(0) ShareShare
ReportReport
Posted on by Hari Pathivada 70

I was building a custom Fetchxml report for an MS CRM Online instance, as usual, I use Advanced Find to build my query,

When I pasted it into the working area, an error popped up: 

The attribute type "PartyList" is not supported. Remove attribute "To" from the query, and try again.

Please help me

  • Hari Pathivada Profile Picture
    Hari Pathivada 70 on at
    RE: Attribute type "PartyList" - "To"is not supported in Fetchxml Query.

    Hi All,

    Any one please help me on this.

    Thanks & Regards,

    Hari Pathivada

  • Hari Pathivada Profile Picture
    Hari Pathivada 70 on at
    RE: Attribute type "PartyList" - "To"is not supported in Fetchxml Query.

    Hi Roy,

    Thanks for your Replying,

    Where we need to modifications in below code:

    <?xml version="1.0"?>

    <fetch distinct="false" mapping="logical" output-format="xml-platform" version="1.0">

    <entity name="email">

    <attribute name="activityid"/>

    <attribute name="to"/>

    <attribute name="ownerid"/>

    <attribute name="createdon"/>

    <attribute name="submittedby"/>

    <order descending="false" attribute="ownerid"/>

    <filter type="and">

    <condition attribute="directioncode" value="0" operator="eq"/>

    </filter>

    <link-entity name="incident" alias="a_6d277637522c4af6af2b72fe068c500a" link-type="outer" visible="false" to="regardingobjectid" from="incidentid">

    <attribute name="csft_channel"/>

    <attribute name="csft_zeestatus"/>

    <attribute name="csft_finalreplydate"/>

    <attribute name="csft_trackingstartedon"/>

    <attribute name="ticketnumber"/>

    </link-entity>

    </entity>

    </fetch>

    Thanks & Regards,

    Hari Pathivada

  • LuHao Profile Picture
    LuHao 40,872 on at
    RE: Attribute type "PartyList" - "To"is not supported in Fetchxml Query.

    Hi partner,

    I hope the following links are helpful:

    1. https://community.dynamics.com/crm/f/microsoft-dynamics-crm-forum/294096/how-to-retrieve-emails-based-on-contact-guid-or-email-id-using-fetch-xml
    2. https://community.dynamics.com/crm/f/microsoft-dynamics-crm-forum/251341/how-to-fetch-party-id-in-fetch-xml-for-ssrs-report
    3. https://technologyblog.rsmus.com/microsoft-dynamics/dynamics-365-customer-engagement/using-fetchxml-access-user-information-resources-party-list-field-service-activity/
    4. http://vikramxrm.blogspot.com/2012/06/contact-filtered-lookup-based-on-party.html
    5. https://crmbusiness.wordpress.com/2016/12/14/crm-2016-activityparty-and-activityparty-lists/
  • Hari Pathivada Profile Picture
    Hari Pathivada 70 on at
    RE: Attribute type "PartyList" - "To"is not supported in Fetchxml Query.

    Hi All,

    Please help me anyone on the above scenario.

    Thanks & Regards,

    Hari Pathivada

  • Hari Pathivada Profile Picture
    Hari Pathivada 70 on at
    RE: Attribute type "PartyList" - "To"is not supported in Fetchxml Query.

    Hi Hao,

    Thanks for your Replying !!

    Above links are not working for my Email Activity Entity.

    Please suggest me any other ways.

    Thanks & Regards,

    Hari Pathivada

  • LuHao Profile Picture
    LuHao 40,872 on at
    RE: Attribute type "PartyList" - "To"is not supported in Fetchxml Query.

    Hi partner,

    Please refer to these three posts:

    1. https://www.inogic.com/blog/2015/09/using-lookupset-in-ssrs-reports-to-show-activity-parties-related-to-an-activity-in-dynamics-crm/
    2. http://jackyincrm.blogspot.com/2016/05/ms-crm-ssrs-fetchxml-party-list-not.html
    3. https://community.dynamics.com/crm/f/microsoft-dynamics-crm-forum/111254/attibute-type-party-list-not-supported-in-fetchxml-report-on-appointment-form
  • Hari Pathivada Profile Picture
    Hari Pathivada 70 on at
    RE: Attribute type "PartyList" - "To"is not supported in Fetchxml Query.

    Anyone please suggest me about this question.

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,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans