web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Pages / Filter a list by a pro...
Power Pages
Answered

Filter a list by a profil lookup field

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

Hello,

 

I would like tell thanks in advance to people who respond.

I am trying to create a portal with 3 differents tables :

 

  • Account
  • Contact
  • Requests (Custom)

 

In Account, I use only the name column as a companyname field.

name
CompanyY

 

In Contact, I have the people who have registrer with invitations and the table profil have a lookup field "company" to the Account table for the companyname. This fields is completed before send invitation.

 

nameemailcompany
Testtest@testCompanyY

 

Requests is a custom table 

IDNameTechCompany
1TechnicianElectricityCompanyY
2ManagerEdcCompanyZ

 

In a page, I would like to use a list component who show only the row of the company field profil user.

 

For the moment, there is the relationships I use : 

 

Requests

  Req <> Contact (Many to Many)

  Req -> Account (Many to One)

Account

  Acc -> Contact (One to Many)

Contact

  Contact -> Acc (Many to One)

 

In a global access permission, all the rows are showed, but not in a Contact or Account type 😞

 

Can you help me ? 

Many thanks

 

 

Categories:
I have the same question (0)
  • Verified answer
    Christian Leverenz Profile Picture
    1,214 on at

    Hi @Anonymous ,

    this should work out of the box with a tablepermission on Request in Accountscope. Acoountscope means, take the parentcustomerid of the contact and relate it to something. So, create a table permission for Request, use Accountscope, choose the right connection between account and Requests (i assume, there is only one), and do not forget to assign that permission to an assigned webrole (you can use authenticated users if you want).

     

    May be, you have to disable the global permission for the requests as it might destroy your specific permission 🙂

     

    As usual: sync data, clear cache (may be logout) and then the user test should only see his entry Technician/Electricity.

     

    Hope this works like that for you,

      Christian

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Pages

#1
Lucas001 Profile Picture

Lucas001 21 Super User 2026 Season 1

#2
CN-06091549-0 Profile Picture

CN-06091549-0 18

#3
oliver.rodrigues Profile Picture

oliver.rodrigues 17 Most Valuable Professional

Last 30 days Overall leaderboard