Skip to main content

Notifications

Finance | Project Operations, Human Resources, ...
Unanswered

Dataconnector how to merge to dyn365 files in excel

(0) ShareShare
ReportReport
Posted on by 10

Hi

I am new in use of dataconnector. BUT:

I have opened salesorderlines from Dyn365 in Excel

I also want som data from Salesorderheader.

When I add the new table (salesorderheader) field : Salesordernumber Excel returns all the numbers, not only those in salesorderlines.

How shall I create links / keys or whatewer ?

Regards

Peter

  • Komi Siabi Profile Picture
    Komi Siabi 12,759 Most Valuable Professional on at
    RE: Dataconnector how to merge to dyn365 files in excel

    Hello,

    When you say "Return all the numbers". Could you please elaborate?

    Do you mean all records in the sales order lines is loaded in excel ? You can add a screenshot to better illustrate.

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

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,969 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 230,842 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans