Example of creating a list page

(0) Share

Report

Posted on by jwnz

111

Is there any example of how to create a list page with the below elements and functions in Power Pages?

1. having search fields

2. having a list, includes some columns from two tables, and list items pre filtered by the current login user

3. can edit the list item, but some fields needs to be disable for editing

4. having pagination so user could go to next page of the list

For example, the list page is for search/edit projects, it links to two tables, Customer and Project, each project belong to only one customer, each customer could have multiple projects, in Project table has a Customer_Id foreign key links to Customer table.

The list could have columns like: Customer.Name, Project.Title, Project.Status, Project.StartDate, Project.FinishDate, Project.Notes

The current login user is a manager of one customer, the user can only see his customer's projects but not other customers'.

The user could open a project to view/edit it (some fields needs to be disable for editing).

Thanks

Categories:

General topics

I have the same question (0)

All responses (4)

Answers (0)

Sort by

oliver.rodrigues 9,482 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi

OOB we have search option and Filter option

A list is based on a Dataverse view, you are allowed to go one-level up, which means if your list is pointing to the Projects table, and you have a lookup for Customer, you can also display columns from the Customer record. About filtering by the current user, you should look into Table Permissions and make sure users can only see records associated with them

Within the list you can associate a form for view/edit details

That's OOB configuration, within your List component you can specify how many records to be displayed in each page (default is 10), if you have more than that, it will automatically add paging

A few links that might help you:

Create and modify views by using the Data workspace | Microsoft Learn

List filter configuration - Power Apps | Microsoft Learn

Configuring table permissions in Power Pages | Microsoft Learn

About basic forms - Power Apps | Microsoft Learn

Was this reply helpful? Yes No
jwnz 111 on at

Like
a
(0)

Report
Copy link

Link copied!

@OliverRodrigues Thanks for sharing the links.

For the filtering, the steps in the link seems not working for my case:
The logged in user has a record in the Contact table, the Contact table has a lookup column point to the Customer table, the Project table also has a lookup column point to the Customer table, i.e.:
1) Relationship between Contact and Customer is many-to-one, one contact only links to one customer, but one customer could link to many contacts
2) Relationship between Project and Customer is many-to-one, one project only links to one customer, but one customer could link to many projects.
3) In Contact table, there is no lookup column pointing to Project directly

Any suggestion please.

Was this reply helpful? Yes No
oliver.rodrigues 9,482 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

From what you are describing you can resolve your problem with Table Permissions.

have you tried securing the data using that?

Is your "customer" table the OOB Account? if yes, you can use the scope Account on the permissions.

If it's a custom table, you will need to first create a permission on the Customer table with your Contact relationship, and then a child permission to Project.

Was this reply helpful? Yes No
jwnz 111 on at

Like
a
(0)

Report
Copy link

Link copied!

@OliverRodrigues thanks for your reply.
It is a custom table. I will have a look to see if could figure out your suggested method "need to first create a permission on the Customer table with your Contact relationship, and then a child permission to Project."

Was this reply helpful? Yes No