Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Customer experience | Sales, Customer Insights,... / Importing Opportunity ...
Customer experience | Sales, Customer Insights,...
Suggested answer

Importing Opportunity Products

(1) ShareShare
ReportReport
Posted on by David_Evans 29
Hello,
 
I'm trying to import a single opportunity product into D365 Sales.
I've exported an existing Opportunity Product and copied the values onto the Import Template for Opportunity products as taken from the Templates for data Import from the Data Management section of the Power Platform Environment Settings, but whatever I do i get the error 'The source data is not in the required format'
 
When expand the error line I get this 
Categories:
Dynamics 365 Sales
  • David_Evans Profile Picture
    David_Evans 29 on at
    Importing Opportunity Products
    Hi Tom,
    Thanks for the reply. I've attached the (renamed) file I was trying to import.
    It's not easy to problem solve this because the error messages are somewhat brief, so any tips are welcome.
    David
    TestLoadOf Opport...
  • Suggested answer
    Tom_Gioielli Profile Picture
    Tom_Gioielli 371 on at
    Importing Opportunity Products
    The error you mention on the import and the screenshot are actually two separate items. The screenshot issue is from the import error tool. There is no separate form to open to review the import errors, you can only view them in the subgrid.
     
    The import error is indicating that something in your import is incorrect and you are receiving an error in the format for a field. Do you have an example of the import row and the fields you are importing into? It could be a mismatched option set, a date and time format that is not allowed, or something like your [Amount] field having a currency symbol in the import file instead of just being a number (10.00 vs $10.00).

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…

Vahid Ghafarpour – Community Spotlight

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

Congratulations to the January Top 10 leaders!

Check out the January community rock stars...

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,286 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,064 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans