web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Pages Filter values on conse...

Power Pages

Answered

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

(0) Share

Report

Report

Posted on by tiagodanielff

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:

Power Apps portals

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Verified answer

OOlashyn 3,496 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
tiagodanielff 5 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No

Join the conversation

Helpful resources

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Subscribe to this forum!

Stay up to date on forum activity by subscribing.

Leaderboard > Power Pages

#1

#2

Lucas001 21 Super User 2026 Season 1

#3

Last 30 days Overall leaderboard

Featured topics

Solution to LinkedIn Authentication in Power Apps Portals

Welcome to the Power Pages forum!

Product updates

Microsoft Power Platform Community release plans