Power Pages

Filter Dataverse table views by Logged in Portal Users

(1) Share

Report

Posted on by SriHarish

Hi,

I have created a Dataverse table view which has a lookup column for Contact table.

I am using this view in one of my pages in my Power pages site.

I have been trying to filter this view by logged in user yet not found the solution.

Could anyone help me on this?

Categories:

General topics

I have the same question (0)

All responses (3)

Answers (0)

aofosu 105 on at

Like (2)

Report
Copy link

Link copied!
To filter a view in Dataverse based on the logged-in user on the portal, follow these steps:

Go to the view in Dataverse.

Click on “Edit Filter”.

Select the lookup column.

Filter by any contact ID or name as shown below.

This setup will automatically filter the results based on the logged-in user on the portal, regardless of the specific condition entered.

Was this reply helpful? Yes No
Suggested answer

Fubar 8,487 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!
3 ways

Include a Contact lookup in the view definition set to any contact (as per aofosu's post)

If for the whole List (and not just a specific view) there is a setting on the List configuration (use the Portal/Power Pages Management App) see Portal User Attribute https://learn.microsoft.com/en-us/power-pages/configure/list-attributes-relationships

Limit access by using appropriately scoped/configured Table Permissions e.g. if the user should only ever see their own records then limiting access via table permissions is the most secure option.

Was this reply helpful? Yes No
Suggested answer

Inogic 1,265 Moderator on at

Like (1)

Report
Copy link

Link copied!

Hi,

Based on our understanding, you are trying to display a list based on the logged-in user. you can achieve this by setting the table permission to the contact level.

Please follow the steps given in the screenshot below.

Output:-

Hope this helps

Thanks!
Inogic Professional Services: Power Platform/Dynamics 365 CRM
An expert technical extension for your techno-functional business needs
Drop an email at crm@inogic.com
Service: https://www.inogic.com/services/
Tips and Tricks: https://www.inogic.com/blog/

Was this reply helpful? Yes No