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

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Pages / Filter values on conse...
Power Pages
Answered

Filter values on consecutive fields within the same Entity Form - PowerApps Portal

(0) ShareShare
ReportReport
Posted on by 5

Hello,

 

I need to filter the values of consecutive fields in the same entity form created on PowerApps Portal as follows:

I have a field called Customer which allows me to select amongst the list of my existing customers (working fine).

Then I have a second field called Contracts, which lists all existing contracts. I would like only to display the Contracts assigned to the Customer previously selected. How to achieve this?

 

I'm still getting introduced to PowerApps Portals and CDM...

 

Thanks in advance and Best Regards,

 

TC

Categories:
I have the same question (0)
  • tiagodanielff Profile Picture
    5 on at

    Many thanks @OOlashyn .

     

    In fact, I wanted to edit the form and get the filters up there. Although, I didn't know that I would have to use the "Switch to Classic". Your solution has solved my problem.

     

    Thanks and Best Regards,

     

    Tiago Carvalho

  • Verified answer
    OOlashyn Profile Picture
    3,496 Most Valuable Professional on at

    Hi @tiagodanielff ,

     

    Do you want to perform filtering when you create a record or when you edit a record?

     

    If you want to make filtering on creation you can check up my blog post where I describe how can you filter lookups dynamically. It requires some knowledge about JavaScript and liquid.

     

    If you want to filter lookup when you edit an record it is much easier - go to your CDS form, open it in an editor, switch to classic mode ( by clicking "Switch to classic" button), find your dependant field and open it properties (either by double-clicking on it or by selecting field and pressing Change Properties button on top). In a Display tab scroll to the section called Related Records Filtering. There you can define by which field you would like to filter too.

    For example, I have an entity called Categorization. This entity has a field called Parent - which is a lookup to another categorization. On the Contact entity, I have two fields - Primary Categorization and Secondary Categorization - both are lookups to Categorization entity. When users select Primary Categorization I would like to show only Secondary Categorization that contains selected Primary as a Parent. You can see my filter condition in the attached screenshot.

     

    Hope this will help.

    Related Record Filtering.png

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Pages

#1
Fubar Profile Picture

Fubar 55 Super User 2025 Season 2

#2
Lucas001 Profile Picture

Lucas001 25 Super User 2025 Season 2

#3
Jerald Felix Profile Picture

Jerald Felix 23

Last 30 days Overall leaderboard