So i have 2 separate lists my product list has a product code but no price and my price list has the listed price but no product code this is a hassle because I'm attempting to make labels in my storefront and need both information in a excel doc however when i export both lists they end up mismatched (i also have multiple product lists separated into categories of products but just one big price list) anyone have any ideas on how to get the data to match up I've been racking my brains about this for weeks it seems so simple
Hi Rippermaster,
As yoummentioned, “i have 2 separate lists my product list has a product code but no price and my price list has the listed price but no product code”
Which means you are using Product and Price List entities?
Because I did not find a price field in the price list entity, but I found price list item has price.
Maybe you can provide screenshot of them in the crm, which can meke me help you easily.
Regards,
Leah Ju
Please mark as verified if the answer is helpful. Welcome to join hot discussions in Dynamics 365 Forums.
You can create an advanced find view from pricelist items and pull in the product data that way (since there is a 1 to many relationship between product and pricelist items). From there you can export the list to excel. Example screenshot below. Is this what you're trying to do?
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.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Rishabh Kanaskar 235
MVP-Daniyal Khaleel 175
Tom_Gioielli 156 Super User 2025 Season 2