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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / How to filter the N-N ...
Power Apps
Unanswered

How to filter the N-N lookup panel

(0) ShareShare
ReportReport
Posted on by 122

I have a recruitment form for studies.  These studies have their own inclusion and exclusion criteria.  Study recruitments are for prospects and at the recruitment level, the selected criteria will vary.  So Studies have a 1:N relationship to Study Criteria and a 1:N relationship to Recruitment. Recruitment then has a N:N relationship to Study Criteria.  I don't necessarily love the subgrid experience for this, but I guess it's a start.  Anyway, when I have users select to add existing Study Criteria, by default it displays all of the criteria across all studies, but what I want is for the list of available criteria to filter by the study that is tied to the current recruitment form. In the gif below, I'm referring to the right-hand panel and the list of criteria that are showing up. Can I do this with client script?  I'm also all ears if someone wants to point me to a better PCF component that isn't a nightmare to learn how to setup.

 

Large GIF (1544x668).gif

I have the same question (0)
  • Jonathan Manrique Profile Picture
    2,687 on at

    Hi @mhomol 

     

    In the past I struggled with this situation and unfortunately there is no way to make a prefilter.

     

    The option that I could implement was that after adding it to the table, if it does not meet a filter condition, I delete it.

     

    If you manage to do it in the pre filter, share the solution

     

    If I have answered your question, please mark your post as Solved.
    If you like my response, please give it a Thumbs Up.
    You can accept more than one post as a solution

  • Ram Prakash Duraisamy Profile Picture
    5,704 Super User 2026 Season 1 on at

    Hi @mhomol 

     

    Please find my blog for the same

     

    https://microsoftcrmtechie.blogspot.com/search?q=N%3AN

     

    Please mark as Answer if it is helpful and provide Kudos


    Subscribe : https://www.youtube.com/channel/UCnGNN3hdlKBOr6PXotskNLA
    Follow me on Twitter : @rampprakashd
    Blog : https://microsoftcrmtechie.blogspot.com

  • mhomol Profile Picture
    122 on at

    Thank you for the link.  I'm reviewing the code now and trying to get it swapped for my entities.  In your code, is the entityLogicalName the name of the virtual table or the subgrid source table?

  • Ram Prakash Duraisamy Profile Picture
    5,704 Super User 2026 Season 1 on at

    It's Logical name for Subgrid 

  • mhomol Profile Picture
    122 on at

    Sorry to bother again, but I can't seem to figure out how to get to the Customize Command option.  It looks like I need to be in classic, but then is this from the form that has the subgrid?

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 Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 545 Most Valuable Professional

#2
Haque Profile Picture

Haque 314

#3
Kalathiya Profile Picture

Kalathiya 234 Super User 2026 Season 1

Last 30 days Overall leaderboard