Filtering the data in the List based on Logged in user and a Related Field

(0) Share

Report

Posted on by justUrvashi

Currently in the portal we want to apply security model like dynamics. Currently power pages are configured with Contacts. Contacts are configured with "bookable resource" a database table.

So, in the "bookable resource" table we have "practice area" column. We are showing all the list of /bookable resource/ in portal page. We want to filter that data based on login user.

Let's say I'm the logged in user and my Practice area value = A. So, when I login in, I only want to see bookable resources where practice area = A, no other practice area related records.

How can we achieve this in power pages portal?

Categories:

General topics

I have the same question (0)

All responses (1)

Answers (0)

oliver.rodrigues 9,368 Most Valuable Professional on at

Like (0)

Report
Re: Filtering the data in the List based on Logged in user and a Related Field

Hi, you can achieve this using Table Permissions.

The way I would structure is:

Practice Area is a table

Contact record has a lookup to Practice Area, defining which area they are associated with

Bookable Resource is another table and should also have a lookup to Practice Area

Table Permission pointing to Practice Area, scope = Contact using relationship created

Child Permission pointing to Bookable Resource, scope = Parent using relationship between the two tables

Was this reply helpful? Yes No