Skip to main content

Notifications

Announcements

No record found.

Dynamics 365 Community / Forums / Sales forum / Filter Views on select...
Sales forum
Unanswered

Filter Views on selected BPF

Posted on by 130

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
    RvdW1990 130 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
    Community Member Microsoft Employee 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
    Ram Prakash 2,285 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

Helpful resources

Quick Links

Dynamics 365 Community Update – Sep 9th

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,263 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,112 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans