Use a table row select to filter a related table?

(0) Share

Report

Posted on by HerrM

Hi,

I am new to Power Pages and I am looking for a possibility to do the following thing:

I have to tables: "Project" and "Team". The Project Table has a "ProjectID" column that is related via a 1:n relation to the "Team" table. So it has to purpose to show which team is associated to which project.

Now I want to build a power page and do the following stuff:

- I want to select a row from the "Project" table

- I want a second table to show all teams associated to the ProjectID

What is the best way to achieve this using power pages?

Categories:

General topics

I have the same question (0)

All responses (3)

Answers (0)

Milansinh Raj 149 on at

Like (0)

Report

Hello @HerrM ,
I am not sure about the actual requirement but may be simpler way to do this is:
1. Design CRM Project Form where you need to put subgrid of team associated with current project.
2. In Portal Management:
a. Create Entity List, set Project entity in table, do needful configuration.
b. Create Web Page, set Project entity list here, do needful configuration.
c. Create Entity form, set Project entity in table, select a form where we put the Subgrid of teams,do needful configuration.
d. Navigate to entity list, options, advance settings -- Add Button - View Details - Set form which created on C.

Try to view this page in portal, it should show on Web Page:
1. list of Project
2. see option from action menu, click on view details
3. it should show pop up where we can see subgrid of teams.

Let me know if you get stuck in this.

Was this reply helpful? Yes No
HerrM 11 on at

Like (0)

Report

Hi @rajmilansinh ,

Thanks a lot for your reply.

I found a solution:
I can add columns from a referenced tables when configuring a View, but ONLY in the Power Apps Portal and not in the Power Pages Portal - even though, I am working on the same table.

Best regards

Was this reply helpful? Yes No
Milansinh Raj 149 on at

Like (0)

Report

Hi @HerrM ,

You dont need to configure a view of Project table to achieve this. You need to simple create a view in 'Teams' table with required fields.
Then on the form of Project table add a subgrid of Team's table where you need to select a view which you created in above step.

so you need to prepare this components:
1. Project Table - view with required columns
2. Teams Table - view with required columns
3. Project Form - which will have a subgrid of associated Teams Table
4. A portal page where you will place a project list view
5. Configure this list view component in you portal - use advance setting to show view details button which will show a Project Form containing selected record details.
6. This Project form will have that subgrid so it will display related teams in it.

Thanks,
Milan
5. This form will

Was this reply helpful? Yes No