Skip to main content

Notifications

Announcements

No record found.

Customer experience | Sales, Customer Insights,...
Answered

Export Line Items by Opportunity? Is this possible to export all the line items properties associated to all deals?

Posted on by 30

Hi Team

Export Line Items by Opportunity? Is this possible to export all the line item properties associated with all deals?

Many thanks,

Jenny

  • Suggested answer
    Abdul Wahab Profile Picture
    Abdul Wahab 12,070 Super User 2024 Season 1 on at
    RE: Export Line Items by Opportunity? Is this possible to export all the line items properties associated to all deals?

    Hi JennyJOak,

    You are welcome.

  • JennyJOak Profile Picture
    JennyJOak 30 on at
    RE: Export Line Items by Opportunity? Is this possible to export all the line items properties associated to all deals?

    Thanks again Abdul Wahab

    Helpful as always. =) have a good day

  • Verified answer
    Abdul Wahab Profile Picture
    Abdul Wahab 12,070 Super User 2024 Season 1 on at
    RE: Export Line Items by Opportunity? Is this possible to export all the line items properties associated to all deals?

    Hi JennyJOak,

    I am wondering about my understanding. Is this what you are looking for?

    pastedimage1667578274997v1.png

    pastedimage1667578290828v2.png

    If I answer your question then please mark it as verified.

    Let me know if I can provide you with more details.

    Thanks
    Regards,

    Abdul Wahab
    Power Platform & Customer Engagement Developer/Lead/Solution Architecture/Project Manager
    Direct/WhatsApp:+923323281237
    E-mail: abdulwahabubit@outlook.com
    Skype: abdul.wahabubit
    Linkedin: www.linkedin.com/.../

  • JennyJOak Profile Picture
    JennyJOak 30 on at
    RE: Export Line Items by Opportunity? Is this possible to export all the line items properties associated to all deals?

    Hi Abdul Wahab , all your reponse has been very helpful. I'm now to trying to make association to the contacts. I can't seem to get all the columns I want for all the line items associated to account and to contacts. Is there a view that you would suggest to get all the information?

    Thanks!

  • Suggested answer
    Abdul Wahab Profile Picture
    Abdul Wahab 12,070 Super User 2024 Season 1 on at
    RE: Export Line Items by Opportunity? Is this possible to export all the line items properties associated to all deals?

    Hi JennyJOak,

    You are welcome.

    Thanks
    Regards,

    Abdul Wahab
    Power Platform & Customer Engagement Developer/Lead/Solution Architecture/Project Manager
    Direct/WhatsApp:+923323281237
    E-mail: abdulwahabubit@outlook.com
    Skype: abdul.wahabubit
    Linkedin: www.linkedin.com/.../

  • JennyJOak Profile Picture
    JennyJOak 30 on at
    RE: Export Line Items by Opportunity? Is this possible to export all the line items properties associated to all deals?

    Thank you Abdul Wahab ! You're a star :) Marked as verified!

  • Verified answer
    Abdul Wahab Profile Picture
    Abdul Wahab 12,070 Super User 2024 Season 1 on at
    RE: Export Line Items by Opportunity? Is this possible to export all the line items properties associated to all deals?

    Hi JennyJOak,

    The quickest and easiest way. Past it '&pagetype=AdvancedFind#31006891' just after the appid pastedimage1666853636993v1.png

    your new URL should be similar: test.crm6.dynamics.com/main.aspx&pagetype=AdvancedFind#31006891

    Select opportunity line from there:

    pastedimage1666853766908v2.png

    Here is the button to export

    pastedimage1666853814170v3.png

    If I answer your question then please mark it as verified.

    Let me know if I can provide you with more details.

    Thanks
    Regards,

    Abdul Wahab
    Power Platform & Customer Engagement Developer/Lead/Solution Architecture/Project Manager
    Direct/WhatsApp:+923323281237
    E-mail: abdulwahabubit@outlook.com
    Skype: abdul.wahabubit
    Linkedin: www.linkedin.com/.../

  • JennyJOak Profile Picture
    JennyJOak 30 on at
    RE: Export Line Items by Opportunity? Is this possible to export all the line items properties associated to all deals?

    Hi Abdul Wahab ,

    Thank you for your response. This can be really useful and definitely answers my question! Where can I find the advanced find functionality? I'm in Dynamics 365 custom view and can't seem to find this functionality.

    Many thanks,

    Jenny

  • Verified answer
    Abdul Wahab Profile Picture
    Abdul Wahab 12,070 Super User 2024 Season 1 on at
    RE: Export Line Items by Opportunity? Is this possible to export all the line items properties associated to all deals?

    Hi JennyJOak,

    This is possible. Find the Opportunity Line table in the advanced find. Run the export. User export button to export lines with opportunity column.

    If I answer your question then please mark it as verified.

    Let me know if I can provide you with more details.

    Thanks
    Regards,

    Abdul Wahab
    Power Platform & Customer Engagement Developer/Lead/Solution Architecture/Project Manager
    Direct/WhatsApp:+923323281237
    E-mail: abdulwahabubit@outlook.com
    Skype: abdul.wahabubit
    Linkedin: www.linkedin.com/.../

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans