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

Notifications

Announcements

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

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Pages

#1
Fubar Profile Picture

Fubar 93 Super User 2025 Season 2

#2
Jerald Felix Profile Picture

Jerald Felix 43

#3
Lucas001 Profile Picture

Lucas001 15 Super User 2025 Season 2

Last 30 days Overall leaderboard