Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Customer experience | Sales, Customer Insights,...
Unanswered

Filter Views on selected BPF

(0) ShareShare
ReportReport
Posted on by 135

Hi Community,

We have two different BPF's on Opportunity. We want to create a View that only shows the Opportunities with BPF #1. How can I manage this in my advanced filtering?

Hope you can help!

  • RvdW1990 Profile Picture
    135 on at
    RE: Filter Views on selected BPF

    Dear Leah,

    Unfortunately this cannot work to create a View on the entity Opportunity.

    Kind regards,

    Renée

  • Community Member Profile Picture
    on at
    RE: Filter Views on selected BPF

    Hi ReneevanderWalt,

    The record and related BPF is 1:N relationship, there is one BPF named 'Opportunity Sales Process' in Opportunity entity:

    pastedimage1635412562687v2.png

    The 'Opportunity ' and 'Opportunity Sales Process' is 1:N relationship:

    pastedimage1635412483681v1.png

    so you want to filter parent records based on condition of child records:

    1.Filter child records(Opportunity Sales Process), opportunity can be shown as lookup field:

    pastedimage1635412698873v3.png

    pastedimage1635412749123v4.png

    2.Report:

    Use Report Wizard in Dynamics 365 Customer Engagement (on-premises) | Microsoft Docs

    pastedimage1635413181367v10.png

    (1)Select entities:

    pastedimage1635412796449v5.png

    (2)Condition:

    pastedimage1635412861482v7.png

    (3)Select columns:

    pastedimage1635412928389v8.png

    (4)Run the report:

    pastedimage1635413103148v9.png

  • Ram Prakash Profile Picture
    2,287 on at
    RE: Filter Views on selected BPF

    Hello,

    Unfortunately there is no way to filter based on BPF. Lets wait for others reply too

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

Ramesh Kumar – Community Spotlight

We are honored to recognize Ramesh Kumar as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Customer experience | Sales, Customer Insights, CRM

#1
Holly Huffman Profile Picture

Holly Huffman 103

#2
Muhammad Shahzad Shafique Profile Picture

Muhammad Shahzad Sh... 96 Most Valuable Professional

#3
Gerardo Rentería García Profile Picture

Gerardo Rentería Ga... 51 Most Valuable Professional

Product updates

Dynamics 365 release plans