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

[hmedhat]

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.

[OliverRodrigues · Accepted solution]

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.

[hmedhat]

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.

[hmedhat]

@OliverRodriguescan you tell me the steps?

[OliverRodrigues]

Hi

Have you created a relationship between Salary and Employee entities? 

[hmedhat]

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.

[hmedhat]

@OliverRodriguesIt worked ,Thanks!

[hmedhat]

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

[OliverRodrigues]

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 

[hmedhat]

@OliverRodrigues  Best of the best Oliver thanks again