web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Pages Apply extra filter on ...

Power Pages

Answered

Apply extra filter on top of existing Account access permission

(1) Share

Report

Report

Posted on by jwnz

111

There are 3 tables:

OOB Account table

OOB Contact table (which is the user table), has the OOB foreign key lookup column links to the Account table

Custom Project table, has the foreign key lookup column linking to the Account table

Have got Account access permission set up, it makes the signed in user can only see the Project records links to the user's account.

How to further apply new filter on the Project's Status field so that the user won't see the Project records when the project Status was 'Deleted' or 'Closed'?

Categories:

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

oliver.rodrigues 9,471 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi, the level of filter you are looking for now it's not in the permissions, the permissions seem correct.

You can filter by status (or any other column) within the Dataverse view configuration: Create and modify views by using the Data workspace | Microsoft Learn

If you need this additional filter in a form level, you will need to apply liquid/JavaScript

Was this reply helpful? Yes No

Join the conversation

Helpful resources

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Subscribe to this forum!

Stay up to date on forum activity by subscribing.

Leaderboard > Power Pages

#1

#2

#3

Last 30 days Overall leaderboard

Featured topics

Solution to LinkedIn Authentication in Power Apps Portals

Welcome to the Power Pages forum!

Product updates

Microsoft Power Platform Community release plans