Skip to main content
Community site session details

Community site session details

Session Id :
Power Pages - Power Apps Portals
Answered

I want to view a list according to a record in another list

(0) ShareShare
ReportReport
Posted on by 56

So I have a list form (salary) view in a webpage and another list form(employee) in another webpage,so we i want when i select a record from employee it redirect me to the otherwebpage (salary) and filter the list view according to this employee.

  • Hani B. Profile Picture
    56 on at
    Re: I want to view a list according to a record in another list

    @OliverRodrigues  Best of the best Oliver thanks again

  • oliver.rodrigues Profile Picture
    9,342 Most Valuable Professional on at
    Re: I want to view a list according to a record in another list

    Hi, do you mean an editable subgrid? or edit individually each record?

     

    the easiest way here is editing each record individually, you need to create an Entity Form for the Employee entity, and set it up in your subgrid actions 

     

    if you have an Entity List --> https://docs.microsoft.com/en-us/powerapps/maker/portals/configure/entity-lists

    if you have an entity form/web form with a subgrid --> https://docs.microsoft.com/en-us/powerapps/maker/portals/configure/configure-web-form-subgrid

     

    hope this helps 

  • Hani B. Profile Picture
    56 on at
    Re: I want to view a list according to a record in another list

    @OliverRodriguessorry but how can i edit the fields in this subgrid view (employee),I only read and i want to edit?

  • Hani B. Profile Picture
    56 on at
    Re: I want to view a list according to a record in another list

    @OliverRodriguesIt worked ,Thanks!

  • Hani B. Profile Picture
    56 on at
    Re: I want to view a list according to a record in another list

    Yes I created a relation but it is empty ,shall i but a value in all this relation field ?! because i have alot of records and it's very hard to manually give each related field a record.

  • oliver.rodrigues Profile Picture
    9,342 Most Valuable Professional on at
    Re: I want to view a list according to a record in another list

    Hi

     

    Have you created a relationship between Salary and Employee entities? 

     

  • Hani B. Profile Picture
    56 on at
    Re: I want to view a list according to a record in another list

    @OliverRodriguescan you tell me the steps?

  • Hani B. Profile Picture
    56 on at
    Re: I want to view a list according to a record in another list

    what is related record or how i can do this? when i create a form and select sub grid and check related records i can't see the records i want.

  • Verified answer
    oliver.rodrigues Profile Picture
    9,342 Most Valuable Professional on at
    Re: I want to view a list according to a record in another list

    Hi

     

    You can achieve this by having one entity list and a details web page/entity with a subgrid to the employee entity, try the following:

    • Create a CDS form for the Salary entity with only a sub-grid with related employee records (if you want you can add a few more relevant fields from the salary entity as well)
    • Create a Portals Entity Form associated with the above CDS form
    • Now in your second Web Page, instead of associating to another entity list, associate with the new Entity Form
    • Back in your first Entity List, in the entity list actions, add a details action pointing to that Web Page

    this should give you a filtered list of employee based on the selected salary record

     

    ------------

    If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

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

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork 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 > Power Pages

#1
Lucas001 Profile Picture

Lucas001 60 Super User 2025 Season 1

#2
Fubar Profile Picture

Fubar 55 Super User 2025 Season 1

#3
surya narayanan Profile Picture

surya narayanan 35