Skip to main content

Notifications

Announcements

No record found.

Dynamics 365 Community / Forums / Sales forum / Create an import for d...
Sales forum
Suggested answer

Create an import for data stored in design software.

Posted on by 14
Hi Guys;
 
I would like to move my quotation process over from my engineering design software onto the dynamics 365 CRM.
 
I have already configured the system to have the fields I require to produce the quotation and have setup excel exports from the engineering software.
 
I now need to be able to import the data from the excel files from the engineering software into the CRM.
 
The engineering software creates two different files namely. Quotelines.xls & Quoteheader.xls and I need to import one into the Quotes table in dynamics and the other into the quote lines.
 
Can someone please assist with how this can be done or maybe an app that can do this?
  • Suggested answer
    PerezAguiar Profile Picture
    PerezAguiar on at
    Create an import for data stored in design software.
    Hey!

    You can try using PowerAutomate.  Using an Excel connector, get each field from a file, and then using the Dataverse Connector, add a new row into the specific table (Quote/quoteLIne)
     
    Regards,

Helpful resources

Quick Links

Dynamics 365 Community Update – Sep 16th

Welcome to the next edition of the Community Platform Update. This is a weekly…

Announcing Our 2024 Season 2 Super Users!

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

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,339 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,177 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans