web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Service | Customer Service, Contact Center, Fie...
Suggested Answer

Price List Products

(3) ShareShare
ReportReport
Posted on by 8
Hi! Is there a way that when you select a price list in the work order form then when I search for the New Work Order products, only the products under that price list will show? Currently, when you select the price list, all products still appear.
Please help
I have the same question (0)
  • Suggested answer
    PerezAguiar Profile Picture
    Microsoft Employee on at
    Hey!
     
    I couldn't find anything on this but definitively sounds like a nice feature:  If you have a price list associated, only the products under the price list should be allowed.  You can search if this has been a suggestion to Microsoft's engineering on https://experience.dynamics.com/ideas/search-ideas/?q=work%20order%20price%20list and if it hasn't been suggested, you can provide this feedback!
     
    Regards,
  • Suggested answer
    Muhammad Shahzad Shafique Profile Picture
    2,373 Most Valuable Professional on at
    Hi! By default, the Work Order Product lookup shows all products. To filter it by the selected Price List:
    Use a custom JavaScript on the Work Order Product form or a Power Automate + custom view:
    • In JavaScript, on Price List change, filter the Product lookup using addCustomFilter.
    • Alternatively, create a custom view that filters products by price list and apply it dynamically.
    There’s no OOB feature to auto-filter by price list — customization is required.
     
  • CU14081115-2 Profile Picture
    2 on at
    Yes, the reply was helpful and provided a clear solution. It explained that the default behavior of the Work Order Product lookup is to show all products, and that there's no out-of-the-box (OOB) feature to automatically filter this list by the selected Price List. The reply then offered two viable customization methods to achieve the desired filtering
      
  • Suggested answer
    Nour Abuzaid Profile Picture
    197 on at

    Hi @tin007

    Yes — what you want is possible, but Dynamics 365 doesn’t do it out-of-the-box for Work Order Products. You’ll need to add a small customization to make the Product lookup filter dynamically based on the selected Price List on the Work Order.

     

    Here’s how you can implement it:
     

    1. Add a JavaScript to Filter the Product Lookup

    You’ll use the addCustomFilter method in your JavaScript to filter by the selected Price List.
     

    2. Alternative: Custom View

    If you don’t want JS, you could:
    a. Create a custom view of Products filtered by the Price List.
    b. Use code or a plugin to set that view as default when a Price List is chosen.

     

    3. Limitations

    a. You must make sure the Work Order form and Work Order Product form both have the Price List accessible so the filter works.

    b. This filter only affects the lookup search — users could still technically bypass it by creating products without a matching price list unless you enforce it with a plugin or business rule.


    references
    https://www.inogic.com/blog/2022/05/add-products-experience-with-mandatory-and-optional-price-list/?utm_source=chatgpt.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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Leaderboard > Service | Customer Service, Contact Center, Field Service, Guides

#1
Tom_Gioielli Profile Picture

Tom_Gioielli 22 Super User 2026 Season 1

#1
Suriyanarayanan V Profile Picture

Suriyanarayanan V 22

#3
Encore Business Solutions Profile Picture

Encore Business Sol... 14

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans